Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server, VFP and corrupted cursors
Message
From
17/06/1998 09:30:46
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
SQL Server, VFP and corrupted cursors
Miscellaneous
Thread ID:
00109041
Message ID:
00109041
Views:
92
I have a process that joins two tables wihtin a SQL Server
stored procedure and the result set is pulled down to a
VFP 5.0a cursor. The size of the result set is 200 records.

We noticed that the VFP cursor is irratically being
corrupted after being queried via joins. The cursor has read/write
capabilities, but is never written to (no edits or adds).
Two index tags are added to the cursor.

The time this was investigated, about 60 of the 200 records
were corrupted as follows: All numeric type fields went to
0 and all character are CHR(0).

Anyone else experienced this or have a solution?


Tom Bellmer
Next
Reply
Map
View

Click here to load this message in the networking platform