Topic: syntax help
How can I put SQL result in variable and then read each value from variable.
Example
myvariable := SQLExecute('SELECT Contracts.id, Clients.company,Contracts.contractno,Products.prodname FROM Contracts INNER JOIN clients ON clients.id = contracts.id_clients INNER JOIN products ON products.id = contracts.id_products WHERE Contracts.id = 2');
showmessage(first value in myvariable);
showmessage(second value in myvariable);
showmessage(third value in myvariable);
Thanks for help