Show us your DECLARE statement. Also, when was the last time you shut down your computer?
Dennis ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, May 14, 2009 9:21 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Fetch cursor I am writing an app which involves a Declare / Fetch / While routine. It works, however with the following unexpected result. The command: FETCH c100 INTO vedifile INDICATOR ivvar1 WHILE SQLCODE <> 100 THEN --Add path to file name set var vEdiFile = ('G:\Edisoft\Sales\HOME DEPOT WESTCOAST\recv\' + .vEdiFile) The above fetch adds a space in front of the value that is fetched into vedifile. During trace I watch the variable vEdiFile and it displays a space as the first character after fetched. I can use the "Modify variable value" tool and confirm that the variable has a space as the first character. I have double and tripled checked that the data in the table does not have a space in front of it. The proceeding command to add the path then creates an invalid file name because of the added space. I have double and tripled checked that the data in the table does not have a space in front of it. Setting a variable to the column in the table at the R> returns a value with no space. I have used Cursors on tables many, many times and have never seen this before! I am at a loss to figure it out. All variables are predefined before the While statement. Has any one seen this happen or have any ideas what I might be missing? Version V8. Thanks, -Bob
