Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Krasimir,
Do you have some ERROR routine active that might be suppressing an error that might be coming up?
Some minor things (don't think they cause your problem):
1) "...as TO;" - "TO" is a reserved word and should be changed to something else;
2) I think it would be cleaner to have the first WHERE expression also use THISFORMSET.vlinvoiceid instead of invoices.invoiceid;
Good luck,
JimN
>Hi,
>
>I have big problem .... Please, help me !!!!!!!
>
>I have two tables INVOCES /500 records/ and INVDET /26000 recs/ . To print invoces i use command :
>
>SELECT invoices.*,invdet.*,invdet.td as to;
> FROM invdet,invoices;
> WHERE invdet.invoiceid=invoices.invoiceid;
> AND invoices.invoiceid=THISFORMSET.vlinvoiceid;
> AND !DELETED("invdet");
> ORDER BY art;
> INTO CURSOR inv_prn .
>
>It work fine.
>
>When records in INVOICES passes 5000 and INVDET - 50000 this command generate empty cursor . To edit invoice i use "local view". When I update this view SELECT command work fine.
>
>Why ?
>
>VFP6.0 SP5 , Win98SE.
>
>Krasimir Georgiev
>Sofia
>Bulgaria
Précédent
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