My.ADVISOR.com Sign-In
ID
Password

Member Center / Sign-Up
   
SUBSCRIPTION STATUS
If you are a subscriber to this publication, sign-in to access locked articles. To subscribe or renew go to www.AdvisorStore.com.
Go to Article
Advanced Search 

ADVISOR TIPS

UNION Explained

Discover how to avoid errors using the UNION clause in Visual FoxPro 8.

By Chuck Urwiler

THIS ARTICLE IS SUBSCRIBER-ONLY
To read this article you must have a current Subscription or Passport for:
DataBased.Advisor.com
or
MSpro.Advisor.com

If you have a correct subscription, sign-in (pink box) to view the complete article and access any Download.

Purchase or renew your Subscription or Passport at www.AdvisorStore.com.

Click this link for help with subscriber online access.

About this Article:

My co-worker encountered an unexpected error using a SQL statement with a UNION clause in Visual FoxPro 8 that had always worked in other versions of FoxPro: "Operation is invalid for a Memo, General or Picture field." We knew VFP 8 was in stricter compliance with standard SQL syntax than previous versions, but why the error message all of a sudden?

Keyword Tags: Application Development, Database, Database Development, Database Management, Development, Microsoft, Microsoft Outlook, Microsoft Visual FoxPro, Programming

ADVISORAMA
The universal regard for money is one hopeful fact in our civilization.
-- George Bernard Shaw, Irish playwright (1856-1950)

ARTICLE INFO

DataBased.Advisor.com

Print Edition: July 2003, Page 37

SUBSCRIBER ONLY ARTICLE LOCKED

Use of this or any other site, content, product or service of Advisor Media constitutes acceptance of Terms of Use.
Portions copyright ©1983-2008 Advisor Media, Inc. All Rights Reserved.
Reuse or reproduction of any portion or quantity of Advisor Media's copyrighted content, in any form, for any purpose, requires written permission.
ADVISOR®, the ADVISOR logo, and other names and logos that incorporate ADVISOR are registered trademarks, trademarks or service marks of Advisor Media, Inc. in the United States and/or other countries.
Other trademarks are used for identification, editorial or descriptive purposes and are the property of their owners.
Hosted by Prominic.NET Website powered by
LOTUS SOFTWARE
SILVC04-04 posted 06/16/2003 modified 06/29/2009 03:09:46 AM ztdbms/ztdbms
domino-144.advisor.com my.advisor.com 07/04/2009 05:20:29 PM