XProfan

English

Christof
Neuß

Hi,

I stolpere probably time again over my own Füße

wished me The work relieve and having the following made (neckline):
Compile Mark Separation

Var Aktivvolumen$=  "(T_Volumina.VOL_Aktivvolumen+T_Volumina.VOL_Aktivvolumen_WL+T_Volumina.VOL_Aktivvolumen_BSH+T_Volumina.VOL_Aktivvolumen_DGHYP+T_Volumina.VOL_Aktivvolumen_MHB+T_Volumina.VOL_Aktivvolumen_RuV+T_Volumina.VOL_Volumen_Teambank+T_Volumina.VOL_Luxcredit)"
Var Anlagevolumen$= "(T_Volumina.VOL_Passivvolumen+T_Volumina.VOL_Passivvolumen_BSH+T_Volumina.VOL_Passivvolumen_RuV+T_Volumina.VOL_Volumen_Union+T_Volumina.VOL_Volumen_Union_Lux+T_Volumina.VOL_Swiss_Rubinum+T_Volumina.VOL_Starplan)"
SQL_Befehl$="SELECT Count(T_Kunden.KDU_KDNR) \
FROM T_Kunden LEFT JOIN T_Volumina ON T_Kunden.KDU_KDNR = T_Volumina.VOL_KDNR \
WHERE T_Kunden.KDU_Art='P' \
AND T_Kunden.KDU_Gemeinschaftskunde<>'J' \
AND T_Kunden.KDU_Mitglied='J' \
AND (:Aktivvolumen$>=20000000000  OR :Anlagevolumen$>=500000)"
SqlExec SQL_Befehl$,

the functions but unfortunately not. make I it so (is Yes clear...), then geht's naturally:
Compile Mark Separation

Var Aktivvolumen$=  "(T_Volumina.VOL_Aktivvolumen+T_Volumina.VOL_Aktivvolumen_WL+T_Volumina.VOL_Aktivvolumen_BSH+T_Volumina.VOL_Aktivvolumen_DGHYP+T_Volumina.VOL_Aktivvolumen_MHB+T_Volumina.VOL_Aktivvolumen_RuV+T_Volumina.VOL_Volumen_Teambank+T_Volumina.VOL_Luxcredit)"
Var Anlagevolumen$= "(T_Volumina.VOL_Passivvolumen+T_Volumina.VOL_Passivvolumen_BSH+T_Volumina.VOL_Passivvolumen_RuV+T_Volumina.VOL_Volumen_Union+T_Volumina.VOL_Volumen_Union_Lux+T_Volumina.VOL_Swiss_Rubinum+T_Volumina.VOL_Starplan)"
SQL_Befehl$="SELECT Count(T_Kunden.KDU_KDNR) \
FROM T_Kunden LEFT JOIN T_Volumina ON T_Kunden.KDU_KDNR = T_Volumina.VOL_KDNR \
WHERE T_Kunden.KDU_Art='P' \
AND T_Kunden.KDU_Gemeinschaftskunde<>'J' \
AND T_Kunden.KDU_Mitglied='J' \
AND ("+Aktivvolumen$+">=20000000000  OR "+Anlagevolumen$+">=500000)"
SQLEXEC SQL_Befehl$,1

white of/ one council? The Langversion Although machbar, but the Version with the : would übersichtlicher, find I.

THANK YOU

Win10 16 GB RAM

09/18/12 ▲

Vollständiges Quote

Absatzweise Quote Zeilenweise Quote

look time:
XProfan-Helpfile

with SQLEXEC can ex XProfan 9 directly variables, How in embedded SQL at C++ or. Java, inserted go. simply a colon to whom Variablennamen settle:
Compile Mark Separation

db("SQLExec", "SELECT * FROM tabelle WHERE name = :Name$ AND gehalt > :Gehalt%", 1)

XProfan X2
WinXP, SP3 v.3244, P4 3.06GHz

09/18/12 ▲

Vollständiges Quote

Absatzweise Quote Zeilenweise Quote

Christof
Neuß

Ähem, sorry, but very the have I Yes in the first drop made. though bestimme I with the variables not the value, separate the area or. a amount over several boxes what examined go should. Perhaps does it not.

is really too clear. If XProfan from "KDU_A1+KDU_A2+KDU_A3" in the SQL-commands something like power

Select 'KDU_A1+KDU_A2+KDU_A3' From XXX

instead of

Select KDU_A1+KDU_A2+KDU_A3 From XXX

then can the indeed not functions.

would have been I on it come can....

Nichtsdestotrotz has your short response me again on The track brought. thanks

Win10 16 GB RAM

09/18/12 ▲

Vollständiges Quote

Absatzweise Quote Zeilenweise Quote