Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parameter queries
Message
De
12/12/1999 20:13:42
 
 
À
12/12/1999 15:49:08
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00302443
Message ID:
00302537
Vues:
26
Hi,
Thanks for your response

Im using the "view designer", How can i have it in one criteria?

Why i need it like that is because:

1) I have a couple "ands" and if i do "AND EMPTY(assignedTo) OR assignedto = ?parassignto" it will give me wrong records, i need to do "AND (EMPTY(assignedTo) OR assignedto = ?parassignto)" How do i do this in the view designer?

2) It should always selects assignedto=parassignto and if it should select also the empty ones is a user driven option.

I did not give you enough information before sorry.
Thanks

>>Hi,
>>
>>I need to to select all empty assignedto and a the ones that assignedto=parassignto in one parameter, how do i do this?
>>
>>Select * from calls where assignedto=?parassignto
>
>SELECT * FROM Calls WHERE EMPTY(assignedTo) OR assignedto = ?parassignto
>
>>
>>Thanks in Advance
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform