Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Requery parameterized view
Message
De
30/12/2001 20:02:33
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
The Mere Mortals Framework
Titre:
Requery parameterized view
Divers
Thread ID:
00599263
Message ID:
00599263
Vues:
50
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
Fil
Voir

Click here to load this message in the networking platform