Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with Upsizing Wizard
Message
From
28/02/2002 18:49:54
Joel Leach
Memorial Business Systems, Inc.
Tennessee, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Problem with Upsizing Wizard
Miscellaneous
Thread ID:
00626735
Message ID:
00626735
Views:
52
When upsizing a couple of large files (one > 100,000 records, one > 300,000), I get the following error: Error #1234 in convertvfplogicaltosqlserverbit (1995): Subscript is outside defined range.

The following line of code is the culprit:
lnLines = ALINES(laLines, lcFileStr)
lcFileStr contains a string version of the entire file, evidently used for bulk inserts. At this point, the string is pretty big. I'm wondering if ALINES() can handle strings this large. MemLines() seems to work, but it will fall apart for records >8192 characters, since that is the limit for Set MemoWidth. Any suggestions?
Joel Leach
Microsoft Certified Professional
Blog: http://www.joelleach.net
Next
Reply
Map
View

Click here to load this message in the networking platform