Problem with inserting

[MarkusG]

Hello Forum,

is there any know issue about problems with inserting new datasets into a table using query.insert?

I have the following prob:

When using the query.insert method, the following statement is send to the db-server:

"SELECT N FROM Dual;"

This is not correct and results (obviuosly) in an error.

Unfortunately, i am not able to send a small example, because this only happens in our relative large app.
There is only one hint i can give:
We just switched from BDS 2006 to RAD 2007. There was no problem under BDS 2006. Ok, we also changed the ODAC Version to ODAC 6.50.0.36

I try to debug it in our app - and your source code - and reply to this topic when there is any more information...

But if you already know about this problem, please reply here.

Regards

Markus

[MarkusG]

Hi Forum,

i solved it.
There was a default expression in one field.

This has to be in ' '
I just wonder why there was no error in BDS 2006.
Only in RAD 2007.

Greetings

Markus

[Plash]

The error appears because you are using a newer version of ODAC. Starting with ODAC 6.50, string default expressions should be quoted: 'N'. If an expression is not quoted, ODAC suggests that it is a name of a stored function.