Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Word OLE Error
Message
From
22/06/2002 11:06:20
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
21/06/2002 15:49:20
Irv Adams
MSC Managed Care, Inc.
Florida, United States
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Miscellaneous
Thread ID:
00671226
Message ID:
00671366
Views:
16
>Hello All:
>
>We have a Word OLE automation letter merge within VFP 6.0 that works well (most of the time). I am getting the following error currently:
>
>
>Error number: 1429
>Error message: OLE Dispatch exception code 0 from MS Word; String is longer than 255 characters.
>
>
>This occurs during the create header source routine prior to the actual data merge, after Word object has been launched.
>
>Anybody seen this one and have any ideas? TIA,

It's documented. For source SQL string can't be longer than 255 chars (word VBA problem not fox). However there is 2 SQL string parameters. Divide the string into 2 (first 255 in first) and put into 2 parameters.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform