Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Searching setup in a form
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Divers
Thread ID:
01496112
Message ID:
01496160
Vues:
48
>I am setting up a means to search for the following information:
>
>Last Name (in Customers table)
>License Plate (Orders Table)
>Vehicle ID Number (Orders Table)
>Order Number (Orders Table)
>
>My concern is "How do I search by "Last Name" if it is actually in the CUSTOMERS table, which is related to the ORDERS table?
>
>I could over-program this, but I wonder if anyone else has run into this situation?
>
>I was thinking about making a View that would handle this. Is there another way?
>
>Cecil

When I was developing a search form a while ago, I used CursorAdapter and set SelectCmd dynamically on the fly. In SQL Server this is one of the most commonly asked questions and the advice is usually to go with the dynamic SQL. Same thing applies to the searches from VFP - you construct the select dynamically by checking which parameters are set in the form.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform