Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>Hello fellow viewers,
>>
>>I would like to include a numeric field in a view filter.
>>
>>However, when I do, and then bind that view to a query-by-example form, the numeric field cannot be null. This works fine as long as the user uses the numeric value to do the lookup, but what if he doesn't?
>>
>>If I set the .value of the field to "", I get a data type mismatch.
>>
>>Has anyone done this successfully? If so, how?
>
>If not NULLable, the empty numeric value is 0.
Ed,
I am making memory variables named after the ones I used in the filter.
(e.g. for Custid = ?vp_custid, I create a mem var named vp_custid).
I just set the memvar to "" if it's character and the view ignores it. Are you saying I should set the memvar to NULL if the field (in this case Custid) is numeric?
TIA,
Dan
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