Information générale
Catégorie:
The Mere Mortals Framework
Titre:
Requery parameterized view
When I requery a view (v_taxlines) that has 2 parameters that are set up in my bizobj's aviewparameters array like:
aViewParameters(1,1) = "vp_TaxEntryId"
aViewParameters(1,2) = 0
aViewParameters(1,3) = "v_TaxLines"
aViewParameters(1,4) = .f.
aViewParameters(1,5) = .f.
aViewParameters(1,6) = .f.
aViewParameters(2,1) = "vp_ClientId"
aViewParameters(2,2) = ""
aViewParameters(2,3) = "v_TaxLines"
aViewParameters(2,4) = .f.
aViewParameters(2,5) = .f.
aViewParameters(2,6) = .f.
I get an error in the requery code coming from kbizobj on the Store line in:
IF TYPE(This.aViewParameters[lnCount,1]) == "U"
STORE &luTemp TO (This.aViewParameters[lnCount,1])
ENDIF
Problem is that the query returned no records so the IF statement is true because vp_TaxEntryId is undefined. The code then tries to store "&0" (luTemp is set to aViewParameters(1,2) earlier in the code) to (vp_TaxEntryId) and produces an error.
Does anyone know what I'm doing wrong?
Thanks again for help!
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