[archive] SQL Varchar
[Migrated content. Thread originally posted on 19 September 2005]Hello,
Is anyone having trouble passing SQL Server Varchar fields into working-storage in Acucobol 6.2?
My WS area is set up as follows:
06 A-Field1-Length PIC s9(4) comp-5.
06 A-Field1-Name PIC X(50).
06 A-Field2-Length PIC s9(4) comp-5.
06 A-Field2-Name PIC X(50).
My SQL Code looks like this:
DECLARE COBCUR1 CURSOR FOR
FROM TBL_Test WITH (NOLOCK)
FOR READ ONLY
FETCH COBCUR1 INTO :A-Test-Data
where Field1 and Field2 are varchar(50) fields in tbl_Test.
When I execute this code, the data from Field1 is lost and the data from Field2 is put into A-Field1-Name.
If anyone has had similar trouble, please let me know how you solved the problem. The same code worked fine on version 6.0.