ansaurus

Question

Delphi ADO + MySQL + Developer Express Grid

Answer 1

+3 A:

I will suggest to use 3d party components, like Anydac. They will work with MySQL right out of the box.

oodesigner 2010-10-25 19:31:39

will this work with any database engine ?, how will it cope with example MS Access or MS Excel? some excel files uses formulas which causes alot of trouble

Plastkort 2010-10-26 13:05:24

Anydac, afaik, has native connectivity for Access and through their ODBC link will work with Excel. Regarding formulas - check your self of with their technical support. You will like it ! :)

oodesigner 2010-10-26 14:19:30

Answer 2

+2 A:

It seems better to use data acess components that are specialized for MySQL. MyDAC from DevART shoud be good enough. I do not use their MyDAC, but their SDAC (MS SQL access) successfully work in most of my projects. Or there should be other third-party components, may be free also.

Badiboy 2010-10-25 20:46:53

all answers are good answers :)

Plastkort 2010-10-26 13:08:29

what if customers just want to use excel, or some other unknown db that might use ADO, would this still work?

Plastkort 2010-10-27 11:18:41

Nope, DEVART components are dedicated for DB servers (list of supported servers are here: http://www.devart.com/ru/dac.html . If you need a fully-functional solution for ADO this should be inspected: I do not like ADO and its Delphi implementation and prefer to avoid it as often as it possible :)

Badiboy 2010-10-30 14:02:20

Answer 3

+1 A:

With the DevExpress grid check out the GridMode and associated properties - this may have an effect. The DevExpress support knowledge base has many examples and questions about this. Also with some dataset types it's necessary to do something like:

dataset.Open;
dataset.Last;
dataset.First;
//...do stuff

in order to get the recordcount correct.

shunty 2010-10-26 07:36:09

I will test this as well, thanks

Plastkort 2010-10-26 13:06:48

ansaurus

tags:

views:

answers:

Delphi ADO + MySQL + Developer Express Grid

related questions