SQLCommandBuilder

[Artificial_Intelligence]

Hi all is there anything in delphi similar to ado.net SQLiteCommandBuilder?

[Blunty Killer]

Doesn't appear that anybody has any components to mimic that functionality in native code Delphi (Win32). But I'm sure the logic can be coded fairly easily, given that the SELECT statement should give you the metadata for the table, from here you can build your own SQL. Most table components basically do this for their updates and inserts into underlying databases in Win32.

[Artificial_Intelligence]

While i dont use Vs products on a daily basis it gave me a good feeling to know that it was made by a former Borland Engineer,dont remember his name right now. Anyway i found what i was looking for (at least in text) at this address.

http://bdn1.borland.com/article/borc...aper/3244.html
happy coding

[Blunty Killer]

Great post. But be cautious when deploying applications that use TClientDataSet to get data from a separate machine; there are licensing issues that arise and can be costly.

[Artificial_Intelligence]

I think sticking to Mysql/Postgresql/Firebird should help...............will keep that in mind though

[Blunty Killer]

These are Borland MIDAS licensing issues, not database ones.