Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Having a problem locating a view?
Message
From
11/01/2000 17:27:09
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Having a problem locating a view?
Miscellaneous
Thread ID:
00316528
Message ID:
00316528
Views:
50
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
Map
View

Click here to load this message in the networking platform