Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Record pointer won't move
Message
De
21/12/1999 14:13:53
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
21/12/1999 13:44:13
Jimmy Ditta
Twin City Electronics
Monroe, Louisiane, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00306669
Message ID:
00306853
Vues:
25
Jimmy,
Fascinating :) How could you handle all these.
"*THIS REPORT HAS FIELDS ACBUNDLE2, ACBUNDLE4, ACBUNDLE6, ACBUNDLE7......." ???
Fields or memvar ? Reports work with tables, cursors. If at the same time there is a field named ie: ACBUNDLE2 in current workarea table.field takes precendence unless you precede it with "m.".
As far as I understand each query is expected to return one element (or do you just use its first element). Also as I understand they absolutely return at least one element (otherwise type error with .. = bunlen12 ... ). This would mean you could combine the whole SQL into one.
select ;
 data1.bundle+data2.bundle...+data8.bundle as acBundle, data1.length ;
from data1, data2.... ;
where data1.grade + data1.siz = data2.grade + data2.siz ;
 and data2.grade + data2.siz = data3.grade + data3.siz ;
 and .... ;
 and data7.grade + data7.siz = data8.grade + data8.siz ;
 and data1.grade = gdValue and data1.siz = szValue ;
 order by 2 ;
 into cursor myCursor
grade + siz might need conversion depending on their type. Report would then be based on myCursor.
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform