Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL command too complex - what should I do?
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00301958
Message ID:
00301971
Vues:
34
>Hi everyone,
>
>Just now I got this error message. I know why it happened, it's because I choose lot's of items in multilist, which affect on Init method one of my other controls. I think, it's VFP limitation 255 char on the macro string. So, my questions are:
>1) Will in VFP7.0 this limitation be fixed?
>2) How can I resolve this situation? Do I need to calculate length of my macro string, finding space, etc. Would be a real PITA :(

Don't put the entire SQL into 1 string for macro expansion. Do something like:
select &cFieldList ;
 from table1 join table2 on table1.pk = table2.pk ;
 where table1.fieldx in ('val1', 'val2') ;
 and table2.fieldy &cFilter1 ;
 group by &cGroupBy ;
 order by &cOrderBy ;
 into cursor MyCursor nofilter
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform