General information
Category:
Coding, syntax & commands
>>Make it
>>lvdate={04/09/1997}
>>SELECT claim_number FROM DEDUCTIONS WHERE voucher_date=lvdate
>
>Did the last solution work? Where you including the braces in the command just as shown in the example you gave. I have made the stupid mistake of having a table field name the same as the variable name and not putting a "M." in front of it.
>
>Arthur
Thanks, it worked fine. However, I have a bigger problem. I'm trying to execute an INSERT INTO sql command using a SELECT statement to provide the values of the INSERT INTO command. The sql worked fine in an IBM DB/2 database, at the runs fine when executed directly on the SQL Server. I've tried using SQLEXEC but it still doesn't work.
Jeff
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only