Board index » delphi » BIG BIG BIG problem? - or it is normal?
Vinicius
![]() Delphi Developer |
Wed, 17 Nov 2004 05:23:57 GMT
|
Vinicius
![]() Delphi Developer |
Wed, 17 Nov 2004 05:23:57 GMT
BIG BIG BIG problem? - or it is normal?
I has a application write using IBX compopnentes, and it works well but now
I have change this application to use the dbExpress component and my problem STARTS!!! I am having problem to updates some table like this : select * from table1 SQLClientDataSet.Locate... BUG... ( Unable to find record. No key specified. ) I have changes all the ProviderFlags correctly and ( I need to use dbExpress because I can have the database at Interbase, the Interbase is a : Firebird server 1.0 796 but if I need I can back to the Anybody help-me? -- |
Thomas Mille
![]() Delphi Developer |
Wed, 17 Nov 2004 08:43:46 GMT
Re:BIG BIG BIG problem? - or it is normal?Upper case your SQL statement QuoteVinicius wrote: Thomas Miller Delphi Client/Server Certified Developer BSS Accounting & Distribution Software BSS Enterprise Accounting FrameWork http://www.bss-software.com |
Viniciu
![]() Delphi Developer |
Sat, 20 Nov 2004 04:10:04 GMT
Re:BIG BIG BIG problem? - or it is normal?THANK YOU!!! IT WORKS!!! Why? Vinicius Marques De Bernardi "Thomas Miller" <tmil...@bss-software.com> escreveu na mensagem Quote> Upper case your SQL statement |
Viniciu
![]() Delphi Developer |
Sat, 20 Nov 2004 04:14:36 GMT
Re:BIG BIG BIG problem? - or it is normal?I noticed 2 problems First : You cannot use another types of UpdateMode, just the UpWhereAll Second : If you have another problem with the table not found, I have change Vinicius Marques De Bernardi "Thomas Miller" <tmil...@bss-software.com> escreveu na mensagem Quote> Upper case your SQL statement |
Thomas Mille
![]() Delphi Developer |
Sat, 20 Nov 2004 21:45:38 GMT
Re:BIG BIG BIG problem? - or it is normal?The TDataSetProvider automatically quotes all database objects. Why? I don't know, but hopefully we will see a flag in D7 to You are better off setting this kind of stuff using the TField QuoteVinicius wrote: Thomas Miller Delphi Client/Server Certified Developer BSS Accounting & Distribution Software BSS Enterprise Accounting FrameWork http://www.bss-software.com |