Article View: borland.public.cppbuilder.database.ado
Article #1740where is the problem?? (Solved)
From: Juan Luis Medina
Date: Fri, 13 Feb 2004 16:56
Date: Fri, 13 Feb 2004 16:56
26 lines
1796 bytes
1796 bytes
Hi, I finally solved :) the problem from my last post some days ago (2004-02-10). I had a "syntax error in UPDATE instruction" because some of the names I was using for the fields in the database were RESERVED words (like password or privileges), that simple! I wanted to explain it here because the error was very simple but at the same time very time consumming and if anyone ever has the same symptons I had, this may help. My application is already working fine but I have some small questions maybe someone could answer them: - When do you use the property 'Prepared' with TADOCommand? I put it false or true before calling the 'Execute' method and it works fine in both cases. Is there any advantage of preparing it before execution? - Can you give me a small example using received values from a TADOCommand? Once I do ADODataSet1->Recordset = ADOCommand1->Execute(); , what else do I have to do to get the retrieved values? JL
Technical Details
Message-ID:
<f64d4f3d.0402130856.36ec63ac@posting.google.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,92f085704253a7fa,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2004-02-13 08:56:59 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail From: juanlu38@hotmail.com (Juan Luis Medina) Newsgroups: borland.public.cppbuilder.database.ado Subject: where is the problem?? (Solved) Date: 13 Feb 2004 08:56:58 -0800 Organization: http://groups.google.com Lines: 26 Message-ID: <f64d4f3d.0402130856.36ec63ac@posting.google.com> NNTP-Posting-Host: 161.72.81.170 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1076691418 18258 127.0.0.1 (13 Feb 2004 16:56:58 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Fri, 13 Feb 2004 16:56:58 +0000 (UTC)