Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement