Why? "Column Unknow"

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

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by xinsoft Sun, 17 Jan 1999 00:00

#1840

Author: 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!

Re: Why? "Column Unknow"

#1842

Author: Klaas Wolters
Date: Thu, 21 Jan 1999 00:00

15 lines
922 bytes

xinsoft wrote in message <77s9hp$6ns6@forums.borland.com>...
>Hi,Anybody:
>Here is my program code.Why run to BDEERROR
>"SQL general error:Column unknow".


I read in "database developers guide with delphi 2" that a "unknown column"
error can be generated by the use of "schema caching " on database that
aren't appropriate for it.

Enable Schema Cache is a driver dependend setting in de BDE


Klaas Wolters

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads