🚀 go-pugleaf

You might try sql.addstrings and build your select statement this way you
can assign tablename to a string variable sTablename
sql.addstring('SELECT *' )
sql.addstring('FROM '+sTablename)

Hope this helps.

Chris Townsend
Atlanta Georgia
townsend@bellsouth.net



Mario Verschuur wrote in message <7c07oo$g51$2@news2.xs4all.nl>...
>I'm trying to do a query on a specific table. But since I've got multiple
>tables ( for each year a paradox-table) I want to change the table I'm
using
>using the params property. But I'm getting an error "token : ?", which
would
>suggest that the parameters isn't substituted correctly.
>
>I was wondering if this is possible at all, and if possible how do I solve
>this problem. Since I wanted to continue my development I worked around the
>problem by editting the SQL property and replacing the tablename. But this
>isn't a very elegant solution.
>
>So anyone ???  Any help would be appreciated.
>
>--
>-------------------------------------------------
>Mario Verschuur
>Barendrecht, The Netherlands
>Email : Mario@Mediaport.Org
>
>
>