Page 1 of 1

Problem updating table using tsmartquery

Posted: Fri 16 Jun 2006 16:17
by Guest
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

Posted: Mon 19 Jun 2006 07:36
by Plash
We cannot reproduce the problem. If it is possible send to ODAC support address complete sample that demonstrates the problem and include script to create server objects.