cnczh wrote:
EhLibSupport wrote:
Hello
Could you write in more detail what dynamic SQL means.
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