Re: TQuery
On Mon, 07 Dec 1998 01:00:09 +0100, John Gunnarsson
<john.gunnarsson@telia.com> wrote:
>Is it possible to get informiation out of a query using params ?
>using input param is no problem but output......., i can't figure out
>how.
>example:
>
>select name from sysdatabases where name = 'stores7';>
>and now i want the name value.
>i tried:
>
>select name into :flag from sysdatabases where name = 'stores7';
>
>but that didn't work.
>
>please help !
>
>--- John Gunnarsson
>
>ps. plase send a copy to my mailbox.
>it@jamtway.se
>
With queries, you push the parameters into the query with params
property, and read the results back via the fields property. One is
input, and input only, while the other is output, and output only.
Stored procedures (if you are using a 'real' database engine) can
return data via its parameters, but that is another kettle of fish
entirely.
St'le Sannerud