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


See if this help: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B308215

> 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