Problem updating table using tsmartquery
Posted: Fri 16 Jun 2006 16:17
I have this very simple query statement
Select d1.*, d1.RowID
from TableA
TableA has 2 fields that cannot be null and is not indexed
When I insert a record through the DBGrid I get an error message
ORA-00928 Missing SELECT Keyword.
I was able to edit another table with a query that has multiple tables. What am I missing on this one.
Btw, I am using ODAC 4.50.3.23 for Delphi6
Thanks
Select d1.*, d1.RowID
from TableA
TableA has 2 fields that cannot be null and is not indexed
When I insert a record through the DBGrid I get an error message
ORA-00928 Missing SELECT Keyword.
I was able to edit another table with a query that has multiple tables. What am I missing on this one.
Btw, I am using ODAC 4.50.3.23 for Delphi6
Thanks