Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL sum() on 186 fields causes crash
Message
De
13/09/2000 11:13:04
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Titre:
SQL sum() on 186 fields causes crash
Divers
Thread ID:
00415834
Message ID:
00415834
Vues:
64
I have an intermediate cursor with 192 fields. I need to 'SQL' sum fields 7-192. First I did this :
lcPattx = ''
for ix = 1 to 186
 lcPattX = lcPattx + ;
   ',sum(T'+padl(ix-1,3,'0')+') as T'+padl(ix-1,3,'0')
endfor
select f1,f2,f3 &lcPattX from ...
Then this :
lcPattx = ''
for ix = 1 to 186
 lcPattX = lcPattx + ;
   'sum(T'+padl(ix-1,3,'0')+') as T'+padl(ix-1,3,'0')+', ;'+chr(13)
endfor
_cliptext = lcPattX
and pasted the code. I even tried removing 'as ...' part. Total commandline length is 4199 at max. Both approaches crash VFP. Any ideas other than not using SQL ? TIA
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform