Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL UNION with Memo fields
Message
 
À
23/10/1997 12:53:10
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00056360
Message ID:
00056389
Vues:
38
>Create Cursor dummy (mymemo m)
>select dummy
>append blank
>
>SELECT ReadDate, Comments, mymemo ;
> FROM MyTable1, dummy ;
>UNION ;
>SELECT ReadDate, mymemo, Cparam ;
> FROM MyTable2, dummy ;
>ORDER BY 1 ;
>INTO CURSOR ac_Cursor
>
>Should get you what you're looking for.

Valerie,

This works perfect. Thanks very much. The only thing I changed in the SELECT was the mymemo references to mymemo AS Cparam and mymemo AS Comments respectively. Without this my final cursor's fields were Readdate, mymemo, Cparam. Once again thanks tons.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform