I have not seen your code but in general the idea of a temporary table to
update a permanent table is not the normal way to use SQL. When you start
adding data to a table from the program it will not be written until you
'commit'. Therefore, appending or any changes to a table can be considere
> I gave an SQLQuery2 with SQL = 'select * from purchdtemp'
> I mapped its datasource to a dbgrid. But the dbgrid acts 'read only'
> now. This is a temporary table I which I used in Delphi for keying in
> Purchase order details. Then, I write the data from this table to
> actual 'purchorderdetails'
Hi
I gave an SQLQuery2 with SQL = 'select * from purchdtemp'
I mapped its datasource to a dbgrid. But the dbgrid acts 'read only'
now. This is a temporary table I which I used in Delphi for keying in
Purchase order details. Then, I write the data from this table to
actual 'purchorderdetails',
> I need to have a TTable component for MySQL using SQLDB. This is to
> straight away key in data into the table using dbgrid.
You can do that with sqldb
> How do I simulate this using a TSQLQuery compo? Will 'InsertSQL'
> property help me this?
It could, but in the most cases (select * from t
Hi
I need to have a TTable component for MySQL using SQLDB. This is to
straight away key in data into the table using dbgrid.
How do I simulate this using a TSQLQuery compo? Will 'InsertSQL'
property help me this?
Where do I get the docs for TSQLQuery component?
regards
Nataraj
begin:vca
