Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Having a problem locating a view?
Message
De
11/01/2000 17:27:09
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Having a problem locating a view?
Divers
Thread ID:
00316528
Message ID:
00316528
Vues:
51
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
Fil
Voir

Click here to load this message in the networking platform