where is the problem??

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

Article #1830

Back to borland.public.cppbuilder.database.ado Previous Next

#1830

From: Juan Luis Medina
Date: Tue, 10 Feb 2004 22:03

23 lines
1470 bytes

Since an UPDATE query to MSAccess 2000 is not working in my
application, i decided to isolate it in a new form.

The form has:
 - a TADOConnection connected at design time in mode = cmReadWrite
 - a TADOCommand with prepared = true at design time and CommandText =

    UPDATE Users
    SET Privileges = 3 
    WHERE Username = 'antonio';

   also from design time (all field and table names are right).

I click on button and just ADOCommand->Execute() is inside (simpler
sample impossible!)

I get an error "syntax error in UPDATE instruction"

Does anybody have a clue to what is happening here???

Thanks a lot,

Juan Luis Medina

Technical Details

Message-ID: <f64d4f3d.0402101403.580a7011@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,5acd8f958b96f181,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2004-02-10 14:03:18 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??
Date: 10 Feb 2004 14:03:17 -0800
Organization: http://groups.google.com
Lines: 23
Message-ID: <f64d4f3d.0402101403.580a7011@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 1076450597 8660 127.0.0.1 (10 Feb 2004 22:03:17 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 10 Feb 2004 22:03:17 +0000 (UTC)