Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unexpected Character in SQLEXEC() Cursor Results
Message
 
 
To
26/04/2002 12:03:04
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00649655
Message ID:
00649674
Views:
6
I would close VFP and reboot PC.

>I am doing a standard VFP 6.0 SQLEXEC() against the Northwind database (SQL 2000) and the resulting set has strange characters in the address and extension fields.
>
>SQLEXEC(
>SQL shows an extension of 3457
>VFP shows an extension of 345|
>
>Also, when you tab onto the field in the browse window, the strange character is not visible, just the 345.
>
>The ASC() translation of the characters are 10 and 13.I am trying to write a solution that will take the resulting query and output it to an excel spread sheet. However, with the characters changing the resulting field values it won't be of much use. Has anyone exeperienced this?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform