Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Still having problems with Parent/Child forms
Message
 
 
To
29/06/2000 15:12:23
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00386460
Message ID:
00386888
Views:
20
>Jess: Sorry but I'm still very new in this stuff. Could you be more specific as to how to do what you sugested?
>Thank you for your time.
>Ulises

Instead of using SELECT statement to create a cursor i.e. Select * From Table1 Into Cursor TempTable, in the load event of the form, do this:
CREATE CURSOR temptable ( name C(35), code C(10) )
You have the option to do indexing in the Init event if needed.

Create a method in the form to populate the cursor with either of the following:
SELECT temptable
ZAP 
APPEND FROM your_source_table 

OR

SELECT your_source_table
SCAN
   SCATTER MEMVAR
   INSERT INTO temptable FROM MEMVAR
ENDSCAN
Set the Grid's RecordSourceType to 6 or 2.

Other options:

1. You may want to use Local/Remote View instead of Cursor

and

2. Directly manipulate the tables by way of establishing relationship in the DE or making use of the Grid's LinkMaster, ChildOrder, RelationExpr properties.

Your choice!
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net

CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
Previous
Reply
Map
View

Click here to load this message in the networking platform