Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Add MEMO field to SQL output
Message
From
16/06/2000 09:44:28
 
 
To
15/06/2000 18:28:00
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00381036
Message ID:
00381318
Views:
19
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!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform