Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View two tables in a grid
Message
De
11/06/2008 10:22:47
 
 
À
11/06/2008 09:13:05
Joseph Mathai
Keyword-Tec Services
Bangalore, Inde
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01323052
Message ID:
01323086
Vues:
13
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform