>>>>>>You and Thomas both misunderstood what I meant.
>>>>>>
>>>>>>Here is what I wrote
>>>>>>
>>>>>>CREATE CURSOR Inventory_Locations (Descrip C(10), ExternalId varchar(50), Id I AUTOINC NEXTVALUE 2 UNIQUE)
>>>>>
>>>>>ROFL
>>>>>Oops!
>>>>>Sorry.
>>>>
>>>>Please see my updated reply as I added 2 more questions. To clarify - I created an Excel with 12 sheets. I now want to insert data from these sheets into cursors and add extra column for Row (I call it ID).
>>>>
>>>>I also want to make sure that if I declare columns as C in VFP, I will not be adding trailing spaces to the values which defined as varchar in SQL - just want to make sure.
>>>
>>>
>>>>By the way, will the spaces be automatically dropped when passing the values back to SQL Server if declared as C(50) in
>>>VFP?
>>>
>>>Nope. Spaces will be there.
>>>BTW I don't know how you update SQL Server table.
>>
>>Using SQLExec. So, do you suggest to use varchar then declaring the columns in the cursor?
>
>No, just use ALLTRIM() when you update.
>BTW why you don't want to use varchar?
I'm not yet sure how I will update, but adding alltrim around every field will be cumbersome. May be I'll try varchar instead.
If it's not broken, fix it until it is.
My Blog