🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #1740

where is the problem?? (Solved)

#1740
From: Juan Luis Medina
Date: Fri, 13 Feb 2004 16:56
26 lines
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-mail

Show 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)