Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Add MEMO field to SQL output
Message
 
 
À
15/06/2000 18:28:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00381036
Message ID:
00381318
Vues:
18
1. Yeah it does. Sorry I forgot to mention that.

2. What do you mean "nothing to join"?

SELECT * ;
FROM realtable LEFT OUTER JOIN dummycursor ON .T.

should work...

Michelle



>Michelle, DZ:
>
>It worked! with two things:
>
>1. the cursor contains dummy memo field needs one record
>2. no join in SQL SELECT, because there is nothing to join
>
>Here is my code, I added another field to the first cursor along with the dummy memo field.
>
>*******************************************
>CREATE CURSOR dummMemo ;
>(x1099 n(1), ;
>ckmemo m)
>
>INSERT INTO dummMemo (x1099, ckmemo);
> VALUES (0, "")
>
>SELECT RealInput.*, dummMemo.*;
> FROM RealInput, DummMemo into cursor MyResults
>********************************************
>
>Thought you might be interested!
>
>Have a Good Day, and Thanks!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform