Page 1 of 1
XE2 SoapDataModule
Posted: Tue 14 Aug 2012 13:23
by MartyN
I'm writing a web service using a SOAP DataModule and was wondering which method would be best to connect to my Oracle 10g database. Should I use the Unidac components or the dbexpress? Using the Unidac 4.1.6 I'm having trouble getting it to write back the updates. I keep getting "INVALID SQL STATEMENT" error. Some of our fields have a space in them and need to be in quotes.
Re: XE2 SoapDataModule
Posted: Tue 14 Aug 2012 13:47
by AlexP
hello,
The choice between the dbExpress technology and Delphi Data Access Components depends on the application specificity, tasks, etc. Therefore we cannot advise you that or another data access solution.
For automatic quotting of fields in UniDAC, you should set the QuoteNames property to True, in this case, correct INSERT/UPDATE/DELETE queries will be generated.
Code: Select all
UniQuery1.Options.QuoteNames := true;
Re: XE2 SoapDataModule
Posted: Tue 14 Aug 2012 13:55
by MartyN
thank you.