Louis Verbraak
[WD12] HReadFirst after HExecuteSQLQuery June 15, 2009 11:32AM |
Louis Verbraak
Re: [WD12] HReadFirst after HExecuteSQLQuery June 15, 2009 12:07PM |
Louis Verbraak
Re: [WD12] HReadFirst after HExecuteSQLQuery June 15, 2009 05:39PM |
Fabrice Harari.pcs.crosspost
Re: [WD12] HReadFirst after HExecuteSQLQuery June 15, 2009 05:59PM |
Louis Verbraak
Re: [WD12] HReadFirst after HExecuteSQLQuery June 15, 2009 06:45PM |
Quote
lsSQL="SELECT SUM(TelOpenstaandBedrag) AS Bedrag FROM HF_ADM_Transacties WHERE SorteerveldFactuur='"+lsSorteerveldFactuur+"'"
lsSQL+=" AND Sorteerveld<>'"+lsSorteerveldFactuur+"'"
// Alleen de gevraagde periodes meetellen.
lsSQL+=" AND (BoekjaarGeboekt<"+gwiBoekjaar
lsSQL+=" OR (BoekjaarGeboekt="+gwiBoekjaar+" AND PeriodeGeboekt<="+gwiPeriodeTem+"))"
// Alleen zelfde debiteur.
lsSQL+=" AND "+lsSubAdm+"='"+lsDebCred+"'"
gppTraceTijd("Pos.11 - Voor SQLQuery")
// Should I use the connection?
IF HExecuteSQLQuery(lqBestand,gpsConnection,hQueryDefault,lsSQL) THEN
//IF HExecuteSQLQuery(lqBestand,hQueryDefault,lsSQL) THEN
____gppTraceTijd("Pos.12 - Voor HReadFirst")
____HReadFirst(lqBestand)
____gppTraceTijd("Pos.13 - Na HReadFirst")
____IF NOT HOut(lqBestand) THEN
________// Do something
____END
END
Fabrice Harari
Re: [WD12] HReadFirst after HExecuteSQLQuery June 15, 2009 07:53PM |
Louis Verbraak
Re: [WD12] HReadFirst after HExecuteSQLQuery June 15, 2009 08:12PM |
Arie
Re: [WD12] HReadFirst after HExecuteSQLQuery June 15, 2009 08:28PM |
Fabrice Harari
Re: [WD12] HReadFirst after HExecuteSQLQuery June 15, 2009 08:35PM |
Louis Verbraak
Re: [WD12] HReadFirst after HExecuteSQLQuery - THANKS June 15, 2009 08:38PM |
Louis Verbraak
Re: [WD12] HReadFirst after HExecuteSQLQuery - THANKS June 15, 2009 08:41PM |
Fabrice Harari
Re: [WD12] HReadFirst after HExecuteSQLQuery - THANKS June 15, 2009 10:48PM |