Zeoslib Portal

miab3 wrote:@detective0922

Maybe so?:

Code: Select all

ZQuery1->First();
ZQuery1->MoveBy(4);
Edit1->Text = ZQuery1->FieldByName("slot")->AsString;

Michal

Hi, miab3, thank you very much, it is a useful solution.

I update the question, could anyone help me?

Hello detective0922, you canot use parameters for column names and table names. Parameters can only be used for sending values to the RDBMS. This is a limitation of SQL and Zeos doesn't replace the parameters by itself - it only transports them to the RDBMS which in turn has to process it. Best reg...

Hello, sorry for my poor english :oops: . I am using C++ builder 6.0+ZEOSDBO-6.6.6-stable+mysql 5.0 and not familiar with zeosdbo, when i just use ParamByName function in sql for WHERE clause just like: FMain->ZQuery1->SQL->Add("select slot from board where eqpid=:id"); FMain->ZQuery1->Par...

Hello, I am a new guy with Zeos and I am using C++ builder 6.0+zeoslib 6.6+MySQL 5.0. What I want to do is get the value of the returned rows and then copy the value to a array, my code is list below: FMain->ZQuery1->SQL->Clear(); FMain->ZQuery1->SQL->Add("select slot from boardinfo where neid=...