Also, it may be time to do a reload. If the indexes have gotten funny, and your select actually retrieves from the index you could have problems.
First rule of troubleshooting is doing the easy/quick things first. Try each of these and test after each 1. RStyle your code. It cleans out invisible garbage. 1. Shut down and restart computer. 2. Reload & test on a local drive. 3. Rewrite your declare, fetch statements from scratch Dennis -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MikeB Sent: Thursday, May 14, 2009 9:44 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Fetch cursor Also, even though you have said you have double and triple checked the data, open the table and write down the data value, then set the field to null and reenter the data manually. This would insure that there are no unprintable chars preceding the value. I have not been able to duplicate your problem, so I am suspicious of the data. Also, how is the data value added to the table to begin with? ----- Original Message ----- From: <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, May 14, 2009 10:21 AM 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
