🚀 go-pugleaf

Thanks Geoff.

I'll give it a shot and let you know.

 -Craig

Geoff S. Wass wrote:

> Craig,
>
> You can use this approach to your particular SQL query:
>
> x = 1
>
> SELECT * FROM Customers WHERE myCode = :x
>
> The colon attached to the front of the variable tells SQL that "x" is a
> variable and not a literal or key word.
>
> You will have to watch that the scope of x matches the scope of your
> SQL. If you have to, you can make it a property of _app like this:
>
> _app.x = 1
>
> SELECT * FROM Customers WHERE myCode = :_app.x
>
> I hope this helps.
>
> --
> Geoff Wass
> Kuala Lumpur, Malaysia
>
> == In news groups use a reply (not e-mail) so all can help and learn!
> ==
> == Report Inprise/Borland bugs...
> == http://www.inprise.com/devsupport/bugs/bug_reports.html
> == dBASE Archives http://forumsearch.borland.com:88/
> == or http://www.dejanews.com
> == Alan Katz's Visual dBASE Magazine http://www.ksoftinc.com/vdb/