Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View or Sql? How do i do this...?
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
View or Sql? How do i do this...?
Divers
Thread ID:
00398920
Message ID:
00398920
Vues:
57

I have an order entry system. There are 3 tables, Orders, Order_Items, and Inventory.

Question 1:

The Orders is a one-to-many into Order_Items.
Order_Items has a foreign key, ItemId, into inventory/

I need to show a grid of order items for the selected
customer. The grid should allow the user to add, change
or remove the order line items.

The line items can be picked from the inventory table.

So had had:



CREATE SQL VIEW v_Orders;
AS SELECT * FROM Order_Items;
WHERE ParentId = ?cCustomerId;
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform