Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Al, I'm having a tough time integrating a parameterized view into my order entry program.
I've created a pv using test3.dbc as the container and ? nInvNo as the parameter in the view called view10
In the onload method I include the following code:
this.dataenvironment.cursor1.cursorsource="J:\DB\DATA\INVENTOR.DBF"
this.dataenvironment.cursor2.cursorsource="J:\DB\DATA\INVOICE1.DBF"
this.dataenvironment.cursor3.cursorsource="J:\DB\DATA\INVOICE2.DBF"
this.dataenvironment.cursor4.cursorsource="J:\DB\DATA\MAILLIST.DBF"
this.dataenvironment.cursor5.DATABASE"J:\VFP6\PHOTOEYE\FORMS\TEST3.DBC"
When I add an item to the invoice2.dbf, I capture the invoice number by setting nInvNo=invoice1.invoice
Then when I browse the view that resides in Test3.dbc, (I haven't gotten to the point of filling the grid yet) the buffered records are not there, nothing is! Yet when I use this view outside the form in a test case, it works fine on data that already resides in Invoice2. This is not sinking through yet. What am I missing? TIA.
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