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 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
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
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',
