Posts filtered by the tag - Xe | Wilton Software Limited

Tag Filter - (Xe)

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) 7 queries took 18 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `tags`221
2DESCRIBE `categories`222
3DESCRIBE `posts_tags`225
4DESCRIBE `categories_posts`222
5SELECT Post.* FROM posts Post, posts_tags pt, tags t WHERE t.tag = ('Xe') AND t.id = pt.tag_id AND pt.post_id = Post.id AND Post.status = 1 ORDER BY Post.created DESC223
6SELECT category, COUNT(*) AS cat_cnt FROM categories_posts c2p INNER JOIN categories Cat ON c2p.category_id = Cat.id GROUP BY category15152
7SELECT tag, COUNT(*) AS tag_cnt FROM posts_tags t2p INNER JOIN tags Tag ON t2p.tag_id = Tag.id GROUP BY tag49493