Problem updating table using tsmartquery

Guest · Post by **Guest** » 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

Plash · Post by **Plash** » Mon 19 Jun 2006 07:36

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.