XE2 SoapDataModule
XE2 SoapDataModule
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
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.
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;