>>>Hi,
>>>
>>>I have come across the following problem, which duplicated in multiple tests.
>>>
>>>First a little background for those who have not seen my other thread. In order to update Identity column in the cursor created with a CursorAdapter I use the following method. I have the following code in the BeforeInsert method of the CA:
>>>
>>>
>>> cInsertCmd = cInsertCmd + ;
>>> "; DECLARE @id int; SELECT @id = SCOPE_IDENTITY()" + ;
>>> "; EXEC Get_identity_Value @id, ?@" + ;
>>> this.Alias + "." + ALLTRIM(this.IDENTITY_FIELD)
>>>
>>>
>>>The above code is suppose to set value of the identity column to the value of scope_identity(). And it work UNLESS one of the columns where entry is made is of type VARCHAR(MAX) NULL. That is, if I leave the editbox control empty and let SQL Server set NULL as the value in the VARCHAR(MAX) column, the above code sets the value to the identity column in the cursor to the identity value from the SQL Server. But if I make any entry into the editbox control, the value in the identity column of the cursor is 0 (zero).
>>>
>>>What could be happening here? TIA.
>>
>>post LIST STRUCTURE of the vfp cursor
>
>Here is the structure:
>
>
> Memo file block size: 64
> Code Page: 1252
> Field Field Name Type Width Dec Index Collate Nulls Next Step
> 1 PONUMBER Character 10 No
> 2 VENDORID Character 8 No
> 3 PROJECTMANAG.. Character 10 Yes
> 4 ORDERDATE Date 8 No
> 5 REQUESTEDDEL.. Date 8 Yes
> 6 POAMOUNT Numeric 18 2 No
> 7 PROJECTACCOU.. Character 16 No
> 8 POCHANGE Character 2 Yes
> 9 PAIDAMOUNT Numeric 18 2 No
> 10 POREFERENCE Character 10 Yes
> 11 AUTOINVOICE Integer 4 Yes
> 12 PODESCRIPTIO.. Memo 4 Yes
> 13 POPK Integer 4 No
> 14 REC_ID Character 1 Yes
>
>
>I just posted the structure and see that some of the field names are longer than 10. Could this have caused the issue?
No.
Uses SQL Server 2000 ODBC Driver ?
Are you sure that this old drive supports VARCHAR(MAX) on every operation ?
I'm not.