error editing OracleDataSet table

[Mark]

Hello, I am new with doa (trial) and don't understand why I get "Ora 904 - invalid column name" when editing the dataset from within a dbgrid of my form...
Login is ok, data is shown correctly, but if try to edit any record I get the error.
Editing same table from SqlExplorer (bde) is successful.
Someone know what I am missing or doing wrong ?
thank you.

 

[foldenm]

Hi. Look for some of the following problems:
1) Column is a calculated column.
2) Column in table was created with double quotes (making it case sensitive)
3) Column contains special characters, such
as #

If any of the above are true, this could lead
to Oracle not recognizing the column name.

Do you have a sample of the "select" statement you are using in the dataset?

Originally posted by Mark:
Hello, I am new with doa (trial) and don't understand why I get "Ora 904 - invalid column name" when editing the dataset from within a dbgrid of my form...
Login is ok, data is shown correctly, but if try to edit any record I get the error.
Editing same table from SqlExplorer (bde) is successful.
Someone know what I am missing or doing wrong ?
thank you.