Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Relational data wrongly linking
Message
From
07/06/2006 19:25:51
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
06/06/2006 20:58:47
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01127417
Message ID:
01127722
Views:
15
>Tried that, Cetin, bot no luck yet...
>
>Steve

I would insist that you should check relations and indexes. ie:
Public oForm
oForm = Createobject("myForm")
oForm.Show

Define Class myForm As Form
  DataSession = 2
  Height = 400
  Width = 600
  Add Object myGrid As Grid With ;
    Top=5,Left=5,Height=390,Width=590,RecordSource="customer",ColumnCount=5

  Procedure Load
    Use (_samples+"data\customer") In 0
    Use (_samples+"data\orders") In 0 Order Tag cust_id
    Select customer
    Set Relation To cust_id Into orders
    *    Set Skip to orders
    Locate For Empty(orders.order_id) && show one initially
  Endproc

  Procedure Init
    With This.myGrid
      .Columns(3).ControlSource = "orders.cust_id"
      .Columns(4).ControlSource = "orders.order_id"
      .Columns(5).ControlSource = "orders.order_date"
    Endwith
  Endproc
Enddefine
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
Next
Reply
Map
View

Click here to load this message in the networking platform