Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Chr(0) appears as last character
Message
From
08/03/1999 17:41:07
 
 
To
08/03/1999 10:45:25
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00195153
Message ID:
00195370
Views:
19
>Can anyone help !
>
>I have a remote view in VFP 6 that looks at a table held in SQL Server 7. The column is a nvarchar(8). If I enter a 3 letter code into this column and perform a tableupdate() command, it sends the update. Fine. I requery the view to see the newly entered record and browse it, I see that at position 8 of the column a square appears. It has an ascii value of 0.
>
>Am I doing something wrong ?

I noticed the same behavior while I was writing an article on SQL Server and VFP datatypes. VFP just doesn't seem to be able to handle the unicode datatypes from SQL Server 7.0. The last character is always a null.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform