Marcus,
When you are using variable in SQL that you want to be used as part of the SQL command statement, you have to use the square brackets (e.g. [$FileName]), change your SQL to:
Begin-procedure
Begin-SQL
Unload data SQL [$FileName] ps_health_benefit
End-SQL
End-procedure
Later...
Rob
-----Original Message-----
From: Cooper, Marcus [SMTP:MCooper@APL.GT-WIS.COM]
Sent: Friday, January 16, 1998 12:08 PM
To: Multiple recipients of list SQR-USERS
Subject: Unloading a table in SQLBase
Hello everyone,
I am trying to unload a table to a filename that is entered into a
variable using SQLBase and SQR3. When I try this is doesn't like the
variable as part of my unload statement. Here is what I am doing:
Begin-procedure
Begin-SQL
Unload data SQL $FileName ps_health_benefit
End-SQL
End-procedure
(where $FileName was entered through an input statement.)
It says it can't bind to my variable. I hope someone can help
Thanks
Marcus Cooper
Grant Thornton LLP
Mcooper@apl.gt-wis.com
Unrecognized Data: application/ms-tnef