Devart Forums

Hi,
I have upgrade from ODAC 6.00 to 6.25 with your last version.
But now automatic CRUD freature doesn't work.
I have tested a simple SQL commande like with ODAC Demo in VCL.NET version,
and nothing append when I update a row !!!!!!

Thx for your help.
N.Schmied

I forget to say I use TSmartQuery component.

I have found more information about this issue

If I use this command it's work better because I place a alias.

I have trace into code and the diffrence occur in
TOraDataSet.GetFieldsInfo

with SQL command without alias, GetFieldsInof doesn't catch TableInfo for FieldDesc.
And after when SQLGenerator.GenerateUpdateSQL is call. It's return nothing because KeyAndDataFields.DataFieldDescs was empty.

I hope Help you.

NSC

In last ODAC builds we have made changes in GetFieldsInfo procedure. Old ODAC versions often generate incorrect update SQLs because table for fields is detected incorrecly.

Several last ODAC builds detect table for fields more strictly. In your query you use table name with schema in the FROM clause, and table name without schema in the SELECT clause. You should use table name in the same format for both clauses to automatic SQL generation work, or use an alias. For example:

Thx for your answer, I have found the same.
And I have make a lite change in your code.
I.e. in TOraDataSet.GetFieldsInfo procedure
after create TColumnInfo you make a test for set TableIndex.

I have make a little change for test . I'm on Dot.NET framework and I have add another test.

What you think about my modification. it's dangerous or not ?

Best Regards,
NSC

Your modification should work, and it's not dangerous.

We'll also make changes to support fields without a schema. The changes will be included in the next build of ODAC.

Thx for your feedback and fast support.

best regard,