Thanks all. Here is the actual code snippet pasted from the program. I will
use the
trim for now.
-- Define a cursor to step through each file.
SET ERROR MESSAGE 705 OFF
DROP CURSOR c100
SET ERROR MESSAGE 705 ON
DECLARE c100 CURSOR FOR SELECT Short_name +
FROM dir_table
OPEN c100
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)
... continues
----- Original Message -----
From: "Lawrence Lustig" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, May 14, 2009 10:09:46 AM GMT -06:00 US/Canada Central
Subject: [RBASE-L] - Re: Fetch cursor
<<
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.
>>
If you're 100 % certain the problem is not in the data, can you post the
DECLARE CURSOR for c100? It sounds like you may be using an expression of the
form (Col1 & ' ' & Col2) where you think you're referring only to Col2.
--
Larry
