Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG: Fox2x memo fields are union incompatible in VFP8
Message
From
20/05/2003 11:34:57
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00790525
Message ID:
00790529
Views:
19
This is documented in the VFP 8 help file. There were some changes made in VFP 8 to make it more compatable with SQL standards. Look at SET ENGINEBEHAVIOR in help, and RTFM.

>Fox2x memo fields are union incompatible in VFP8. The following code works in VFP7 but generates an error in VFP8:
>
>Close Databases
>Set Safety Off
>Create Table Test (MemoFld m)
>Insert Into Test (MemoFld) Values ('Some Text')
>
>* This line works
>Select * From Test Union All Select * From Test
>
>Select Test
>Copy To Test2x Fox2x
>
>* This line generate a "Selects are not Union Compatible" error
>Select * From Test2x Union All Select * From Test2x
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform