Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ChildOrder, LinkMaster and so on
Message
From
20/10/2000 15:59:12
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
20/10/2000 15:19:58
Héctor Lizarraga
Gobierno Del Edo de Querétaro
Querétaro, Mexico
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00432241
Message ID:
00432279
Views:
22
>How can i populate a one-to-many form. I want to have one textbox for the user input and one grid for displaying the secondary records. This without using the dataenviroment, only with free tables. I'm having some troubles with the use of ChildOrder, LinkMaster and other grid related propertys.

Hector,
By saying displaying if you mean readonly then you could use SQL rowsourcetype provided your where clause only refers to indexed fields. ie :
* Textbox.lostfocus
thisform.myGrid.refresh

* Grid.Init
* Rowsourcetype and rowsource are their default during designtime
with this
 .RowSourceType = 4
 .RowSource = 'select * from myChild '+;
         'where myField = trim(thisform.myTextbox.Value) '+;
         'into cursor crsDispGrid'
endwith
If myField is not indexed you get a blank grid.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform