Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Blum
  Where is Ken Blum?
 Chicago
 Illinois - United States
 Ken Blum
 Tags
Subject: "Invalid Cursor State" binding SQL Text to EditBox
Thread ID: 22327 Message ID: 22327 # Views: 40 # Ratings: 0
Version: Visual FoxPro 7 Category: Databases, Tables and SQL Server
Date: Tuesday, April 15, 2003 8:09:02 PM         
   


I have a SQL Server 2000 table and a Remote View set to this table which the end result is the following structure...

Structure for table: C:\DOCUME~1\KBLUM\LOCALS~1\TEMP\E63W004H.TMP
Number of data records: 3474
Date of last update: / /
Memo file block size: 64
Code Page: 1252
Field Field Name Type Width Dec Index Collate Nulls
1 CFR172101_IDKey Integer 4 No
2 SHIPPING_NAME Memo 4 Yes
3 SYMBOLS Character 8 Yes
4 HAZARD_CLASS Character 15 Yes
5 UN_NUMBER Character 10 Yes
6 PACKING_GROUP Character 5 Yes
7 LABEL Character 30 Yes
8 SPECIAL_PROVISION Character 90 Yes
9 PKGEXCEPTION Character 15 Yes
10 PKGNONBULK Character 15 Yes
11 PKGBULK Character 15 Yes
12 PASSENGER_AIR Character 15 Yes
13 CARGO_AIR Character 15 Yes
14 VESSEL Character 5 Yes
15 VESSELSP Character 10 Yes
16 REPORTABLE_QTY Numeric 11 4 Yes
** Total ** 270

Whenever I attempt to add an EditBox with the ControlSource set to CFR172101.Shipping_Name I get an "Invalid Cursor State" error, and VFP crashes. It does not crash when doing a Modify Memo (using it in a grid).

I have numerous other SQL Server tables that have Text fields which are converted to memo fields in VFP Remote Views and use them without a problem. It's just this one Remote View that has been a little !@*$ for a week now. I have tried recreating the SQL Server table along with the Remote View numerouse times.

Anybody else have this problem before?


KTB

COMPLETE THREAD

"Invalid Cursor State" binding SQL Text to EditBox Posted by Ken Blum @ 4/15/2003 8:09:02 PM
RE: "Invalid Cursor State" binding SQ... Posted by Yuri Rubinov @ 4/15/2003 8:55:36 PM
Nope. Anybody Else? Posted by Ken Blum @ 4/17/2003 3:43:18 PM
Resovled by checking Fetch Memo advanced option Posted by Ken Blum @ 4/17/2003 7:19:15 PM