Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View two tables in a grid
Message
From
11/06/2008 10:22:47
 
 
To
11/06/2008 09:13:05
Joseph Mathai
Keyword-Tec Services
Bangalore, India
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01323052
Message ID:
01323086
Views:
12
>Is it possible to have a grid view of two tables 'OrderMaster' and 'OrderDetails' together in the same grid one bellow the other, each row with the cells of the particular table

You can display "almost everything" in a grid, as long as you can get it into a cursor, or at least derive from cursor content.
In my opinion, it's not always useful to do so, though.
How do you want it to display?
CREATE CURSOR OrderMaster (orderNo Char(10), orderDate D)
INSERT INTO OrderMaster VALUES ("27001", DATE(2003,11,2))
CREATE CURSOR OrderDetails (quantity Int, price Num(18,2))
INSERT INTO OrderDetails VALUES (5, 20.5)

SELECT orderNo as Column1, CAST(orderDate as Char(20)) as Column2 FROM orderMaster;
UNION ;
select CAST(quantity as Char(10)), CAST(price As Char(20)) FROM orderDetails ;
Into Cursor gridSource
hth
-Stefan
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform