Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Foxpro can't query on two tables more than 7m
Message
 
À
27/04/2007 08:41:50
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01219859
Message ID:
01223577
Vues:
12
>>This seems to be a bug in VFP 5, this works fine on my homecomputer with vfp 9 but at work it fails. Too bad for me . Could this be achieved w/o a left outer join (because left outer join has been introduced in VFP 5). Thanks beforehand. I have tried Edward's suggestion, but this is not workable.
>
>Do you mean my code doesn't work? What's the error message?

With not workable I meant that I get my initial problem back : the query doesn't get finished. But I have changed your suggesion somewhat and that seems to work very well:
Select * From oldtable Where str(mijbrpls)+ str(vlgnrbsv) + str(vlgnrplsvr) + str(vlgnr_mut)+ bdr_srt;
Not in (Select  str(mijbrpls)+ str(vlgnrbsv) + str(vlgnrplsvr) + str(vlgnr_mut)+ bdr_srt) From newtable)
Thanks for your help.
Zakaria al Azhar
My blog on Actuaris.net
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform