DataSet editing in ODAC 5.1 (C++Builder 6.0) problem !!!

KSalawa · Post by **KSalawa** » Tue 02 Nov 2004 20:46

Hi,
Can anyone tell me, how can I edit a dataset using TOraQuery without using SQLUpdate property ?. In BDE, it may be done by following code:
Query->Edit();
Query->FieldByName("field_name")->AsString = field_value
....
....
Query->Post();

K.Salawa

Paul · Post by **Paul** » Wed 03 Nov 2004 09:27

TOraQuery cannot update records without using SQLUpdate. Please use TSmartQuery for this purpose. Please see "Working with TSmartQuery component" topic in ODAC help.

KSalawa · Post by **KSalawa** » Sat 06 Nov 2004 20:48

Tanks for your help.

By the way, I found this feature (TSmartQuery) a few minutes after I send my previous post