Components for Delphi and C++ Builder.

How to execute dynamic SQL statements in ADOdatadriverEH of dbgrideh
for example: 'SELECT * FROM mytable WHERE ID>1'
thank you

Hello

Could you write in more detail what dynamic SQL means.

_________________
Best regards
EhLib Support Team

How to write query statements

ADOConnectionProviderEh and ADODataDriverEh and MemTableEh and DataSource

How to execute ADODataDriverEh.SelectSql or UpdateSql or InsertSql or DeleteSql

for example

ADOConnectionProviderEh1.InlineConnection.ConnectionString := 'Provider=SQLOLEDB.1;Password=MYWORD;Persist Security Info=True;User ID=MYDATA;Initial Catalog=MYDATA;Data Source=127.0.0.1';
ADOConnectionProviderEh1.InlineConnection.Connected:= True;

message missing connection or connectionString




ADODataDriverEh.SelectSql.Text:='SELECT * FROM MYTABLE WHERE ...';
ADODataDriverEh.SelectSql.Open;
OR
ADODataDriverEh.SelectSql.Action;

Where is it written?

DBGridEh.Options.dgEditing:=true;
When the cell changes the content, it can't be null. Where to judge

If the value of cell is allowed to be null, I want to update the value of database to null. How to set


thank you very much

Hello

ADODataDriverEh.SelectSql or UpdateSql or InsertSql or DeleteSql
are executed automatically.

You need to assign
MemTableEh.DataDriver = ADODataDriverEh


When you open MemTableEh (MemTableEh.Active = True)
It executes ADODataDriverEh.SelectSql command and load data to MemTableEh buffer, so you can work with it.

When you MemTableEh.Edit and MemTableEh.Post record it executes ADODataDriverEh.UpdateSql
(If MemTableEh.CachedUpdates = False).

If MemTableEh.CachedUpdates = True then
after you Post, Delete, Insert in MemTableEh you need to call MemTableEh.ApplyUpdates to execute
UpdateSql or InsertSql or DeleteSql for the corresponding type of editing.

_________________
Best regards
EhLib Support Team