Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Having a problem locating a view?
Trying to populate a cursor from a view with muliple(duplicate records) to drive a label form. I keep getting "g:\data\lproducts.dbf does not exist." error message as indicated below. Can anyone see the obvious? Using VFP6 SP3 btw.
set path to g:\data
set defa to g:\data
open database posdata.dbc
* this is my view - lproducts
use lproducts in 0 alias lproducts
afields(lcursor)
create cursor crslabel from array lcursor
sele lproducts
sum howmany to totallabels
calc max(howmany) to maxlabels
totloops = 0
sele crslabel
for x = 1 to maxlabels
appe from lproducts for howmany > totloops
* and it bombs right here on the append
totloops = totloops + 1
endfor
brow last
This is still in a testing phase, so the logic may be suspect at this point. As the view opens, and 2 subsequent calcs run fine, and the Data Session Windows shows 'Lproducts' is open, I am clueless. TIA.
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