Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / lazarus / 2012-11

How to assign a SQL field to a variable

4 messages · 2 people ·

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Eric Kom

Good day,

After connected to the database and assign the SQL query to SQLQueryMySQL.SQL.Text and opened the query as follow:

SQLQueryMySQL.SQL.Text := 'SELECT usernameLogin, passwordLogin,
fullNameLogin FROM `tux`.`login`';
SQLQueryMySQL.Open;

My question is, how do manage to assign a specific fields to a variables defined?

Kind Regards Eric Kom System Administrator - Metropolitan College _________________________________________ / You are scrupulously honest, frank, and \ | straightforward. Therefore you have few | \ friends. / ----------------------------------------- \ \ .--. |o_o | |:_/ | // \ \ (| Kom | ) /'\_ _/`\ \___)=(___/ 2 Hennie Van Till, White River, 1240 Tel: 013 750 2255 | Fax: 013 750 0105 | Cell: 078 879 1334 | www.kom.za.net | www.kom.za.org | www.erickom.co.za Key fingerprint: 513E E91A C243 3020 8735 09BB 2DBC 5AD7 A9DA 1EF5

Reply by email

Eric Kom

Good day,

After connected to the database and assign the SQL query to SQLQueryMySQL.SQL.Text and opened the query as follow:

SQLQueryMySQL.SQL.Text := 'SELECT usernameLogin, passwordLogin,
fullNameLogin FROM `tux`.`login`';
SQLQueryMySQL.Open;

My question is, how do manage to assign a specific fields to a variables defined?

Kind Regards Eric Kom System Administrator - Metropolitan College _________________________________________ / You are scrupulously honest, frank, and \ | straightforward. Therefore you have few | \ friends. / ----------------------------------------- \ \ .--. |o_o | |:_/ | // \ \ (| Kom | ) /'\_ _/`\ \___)=(___/ 2 Hennie Van Till, White River, 1240 Tel: 013 750 2255 | Fax: 013 750 0105 | Cell: 078 879 1334 | www.kom.za.net | www.kom.za.org | www.erickom.co.za Key fingerprint: 513E E91A C243 3020 8735 09BB 2DBC 5AD7 A9DA 1EF5

Reply by email

Eric Kom

Good day,

After connected to the database and assign the SQL query to SQLQueryMySQL.SQL.Text and opened the query as follow:

SQLQueryMySQL.SQL.Text := 'SELECT usernameLogin, passwordLogin,
fullNameLogin FROM `tux`.`login`';
SQLQueryMySQL.Open;

My question is, how do manage to assign a specific fields to a variables defined?

Kind Regards Eric Kom System Administrator - Metropolitan College _________________________________________ / You are scrupulously honest, frank, and \ | straightforward. Therefore you have few | \ friends. / ----------------------------------------- \ \ .--. |o_o | |:_/ | // \ \ (| Kom | ) /'\_ _/`\ \___)=(___/ 2 Hennie Van Till, White River, 1240 Tel: 013 750 2255 | Fax: 013 750 0105 | Cell: 078 879 1334 | www.kom.za.net | www.kom.za.org | www.erickom.co.za Key fingerprint: 513E E91A C243 3020 8735 09BB 2DBC 5AD7 A9DA 1EF5

Reply by email

Reinier Olislagers
to Eric Kom: After connected to the database and assign the SQL query to SQLQueryMySQL.SQL.Text and…
Eric Kom wrote 12 lines
Good day, After connected to the database and assign the SQL query to SQLQueryMySQL.SQL.Text and opened the query as follow: SQLQueryMySQL.SQL.Text := 'SELECT usernameLogin, passwordLogin, fullNameLogin FROM `tux`.`login`'; SQLQueryMySQL.Open; My question is, how do manage to assign a specific fields to a variables defined?

http://wiki.lazarus.freepascal.org/SQLdb_Tutorial3

Reply by email