Why? "Column Unknow"

Article View: borland.public.cppbuilder.database.multi-tier

Article #1840

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#1840

From: xinsoft
Date: Sun, 17 Jan 1999 00:00

21 lines
1211 bytes

Hi,Anybody:
Here is my program code.Why run to BDEERROR
"SQL general error:Column unknow".

frmDB->xyQuery->Close();
frmDB->xyQuery->DatabaseName="xyDatabase";
frmDB->xyQuery->ParamCheck=false;
frmDB->xyQuery->SQL->Clear();
frmDB->xyQuery->SQL->Add("update righte");
frmDB->xyQuery->SQL->Add("set passkey = :pk");
frmDB->xyQuery->SQL->Add("where userid = UPPER(:ui);");
frmDB->xyQuery->Params->CreateParam(ftString, "pk", ptInput);
frmDB->xyQuery->Params->CreateParam(ftString, "ui", ptInput);
frmDB->xyQuery->ParamByName("ui")->AsString=Edit1->Text;
frmDB->xyQuery->ParamByName("pk")->AsString=Edit3->Text;
frmDB->xyQuery->Prepare();
frmDB->xyQuery->ExecSQL();
frmDB->xyQuery->Close();
frmDB->xyDatabase->Connected=false;

Thank you very much!

Technical Details

Message-ID: <77s9hp$6ns6@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,7981af505ee50d5,start
X-Google-Attributes: gidfcd2b,public
From: "xinsoft" <xinsoft@163.net>
Subject: Why? "Column Unknow"
Date: 1999/01/17
Message-ID: <77s9hp$6ns6@forums.borland.com>
X-Deja-AN: 433587516
Organization: Another Netscape Collabra Server User
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Newsgroups: borland.public.cppbuilder.database.multi-tier