Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using set skip
Message
 
To
15/09/2001 07:07:52
Denis Filer
University of Oxford
United Kingdom
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00556894
Message ID:
00557402
Views:
19
>When using set skip with set relation, is there a way to show the actual repeated field values rather than '***********'? Thanks.

Denis,

For what you want don't use set skip for your grid. You have two choices (assuming two tables named Table1 and Table2 related on Id field);
1) USE Table2
   USE Table1 ORDER Id IN 0
   SET RELATION TO Id INTO Table1
Now drive your grid from table2

or

2) SELECT Table1.*, Table2.* ; 
     FROM Table1 JOIN Table2 ;
       ON Table1.Id = Table2.Id ;
    INTO CURSOR Results
Now drive your grid on the Reasults cursor
JimB
Previous
Reply
Map
View

Click here to load this message in the networking platform