[Lazarus] How to assign a SQL field to a variable

Eric Kom erickom at metropolitancollege.co.za
Sat Nov 17 14:37:29 CET 2012


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
erickom at kom.za.net | erickom at metropolitancollege.co.za
www.kom.za.net | www.kom.za.org | www.erickom.co.za

Key fingerprint: 513E E91A C243 3020 8735 09BB 2DBC 5AD7 A9DA 1EF5





More information about the Lazarus mailing list