Michael,
Thanks for the reply. I thought the SQL Update would be easiest, but I receive an error. It is expecting my AS400 file to be in the VFP dbc. Here is my code:
CREATE CONNECTION .....
SQLEXEC(lnHandle, "SELECT * FROM QS36F.GMBIAP6 GMBIAP6;
WHERE GMBIAP6.WDC=' ' AND GMBIAP6.WSBTC = ' '", 'cRefunds')
UPDATE QS36F!GMBIAP6 SET GMBIAP6.WSBTC = 'Y'
SQLDISCONNECT(0)
DELETE CONNECTION .....
What am I doing wrong? Thanks again for your help! :)
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