General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only