Prev: Advantage Vulcan.NET RDD Beta Available
Next: Code Signing Certificates...
From: Johan Kwaspen on 10 Jul 2008 09:47
Hello Bart,

You can get the value by use the FIELDGET, in this case

oStmt:FIELDGET(#EXP1)

Hope this helps.

Johan Kwaspen


"Bart" <bartATdc-soft.com> schreef in bericht
news:48737158$0$2847$ba620e4c(a)news.skynet.be...
> Another question about SQL :
>
> the next code works fine (.T.)
>
> oStmt:=SQLStatement{"SELECT AVG(IM7BEDRAG) AS EXP1 FROM ARTIKEL WHERE
> (IDARTSOORT = "+NTrim(self:Server:IDARTSOORT)+") AND (AANWEZIG =
> 'J')",oConn}
>
> but how can I get the value of that SQLStatement (EXP1)
>
> tia,
> Bart.
>

From: Bart on 11 Jul 2008 07:28
Johan,

this doesn't work !
oStmt is a SQLStatement not SQLSelect !

Bart.




"Johan Kwaspen" <jkwaspen(a)dyka.com> schreef in bericht
news:4876130d$0$2859$ba620e4c(a)news.skynet.be...
> Hello Bart,
>
> You can get the value by use the FIELDGET, in this case
>
> oStmt:FIELDGET(#EXP1)
>
> Hope this helps.
>
> Johan Kwaspen
>
>
> "Bart" <bartATdc-soft.com> schreef in bericht
> news:48737158$0$2847$ba620e4c(a)news.skynet.be...
>> Another question about SQL :
>>
>> the next code works fine (.T.)
>>
>> oStmt:=SQLStatement{"SELECT AVG(IM7BEDRAG) AS EXP1 FROM ARTIKEL WHERE
>> (IDARTSOORT = "+NTrim(self:Server:IDARTSOORT)+") AND (AANWEZIG =
>> 'J')",oConn}
>>
>> but how can I get the value of that SQLStatement (EXP1)
>>
>> tia,
>> Bart.
>>
>

 | 
Pages: 1
Prev: Advantage Vulcan.NET RDD Beta Available
Next: Code Signing Certificates...