Tag Filter - (Xe2)

Error Incompatible type TWideStringList under XCode

If your trying to use a TStringList in your IOS Xe2 Firemonkey application you will probably encounter the following errors when compiling under Xcode...

dynamically create a Firemonkey drop shadow

Just a quick code example of how to dynamically create a drop shadow effect, pretty simple stuff but with the lack of documentation examples are rare so it seems. This example adds a drop shadow to a TMemo...

embarcadero dbexpress SQLConnection DriverName access violation DbxCommon150.bpl

I struck a problem trying to use the dbExpress TSQLConnection components on an upgraded BDS2006 application where the program would compile and link fine but when you ran the application it would fail with the following access violation error...

Getting embarcadero dbexpress mysql working - DBX Error: Driver not initialized

Sometimes the simple things are harder than you expected and dbexpress probably comes under that category, it was less express than I had expected but once you figure things out it does work. Some of the problems were my fault while others took time due to the obscur nature of the errors returned by XE and XE2...

(default) 9 queries took 8 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `posts`17171
2DESCRIBE `comments`11110
3DESCRIBE `tags`221
4DESCRIBE `categories`221
5DESCRIBE `posts_tags`221
6DESCRIBE `categories_posts`221
7SELECT Post.* FROM posts Post, posts_tags pt, tags t WHERE t.tag = ('Xe2') AND t.id = pt.tag_id AND pt.post_id = Post.id AND Post.status = 1 ORDER BY Post.created DESC442
8SELECT category, COUNT(*) AS cat_cnt FROM categories_posts c2p INNER JOIN categories Cat ON c2p.category_id = Cat.id GROUP BY category15150
9SELECT tag, COUNT(*) AS tag_cnt FROM posts_tags t2p INNER JOIN tags Tag ON t2p.tag_id = Tag.id GROUP BY tag49491