[Valentina-studio] Request SQL SUM() for V4MD VCursor,

[bkueffer at dplanet.ch]

>> I have a project that i would like to switch to server/client version,
>> So my tests are done with the recent V4MD Client
>> ------------------
>> In DirectorMX 9.0 / V4MD_Client.x32  2.0.0.0a51
>> ------------------

>And I am little lost.

>You have told that 

>1) SUM() works for you in viSQL
I was just trying now, 'select sum(int_fld) from counttable' in ViSQL.
YES IT WORKS, viSQL 1.9.7 windows (XP,2000)  returns the correct values for
SUM
With both, Ulong and Umedium Fields.

>2) in the Vstudio, yes?
        with LOCAL db and REMOTE ?
Vsudio (sql plugin 1.0a22,files plugin 1.10b,server plugin 2.0a46) win
(xp,2000) 
Server: Can't connect to server so i cannot try tis for the moment because i
use server ..a51,
I will try this if Vstudio with server plugin a51 is available.
Local connect: Yes IT WORKS with Ulong and Umedium Fields.


>But not works in V4MD only?

Right, does NOT WORK:

V4MD 1.9.8 b19  
Returns allways NULL  with both Ulong and Umedium Fields

V4MD_Client.x32  2.0.0.0a51 connected to Server 2a51
Does NOT work with both Ulong and Umedium Fields 
Returns allways NULL

>Please explain me all again.

Vcursor SQLString: 'select int_fld from counttable'
Returns PropList: [[#int_fld: 3], [#int_fld: 5], [#int_fld: 2], [#int_fld:
8], [#int_fld: 20], [#int_fld: 15], [#int_fld: 9]]

Vcursor SQLString:  'select sum(int_fld) from counttable'
Returns PropList: [[#Sum: <Null>]]   
(instead of  [[#Sum: 62 ]] with both Ulong and Umedium Fields)


     

     
Beat Küffer
Bözingenstr. 160
CH-2504 Biel
Switzerland 
++41 (0)76 349 7434 info at beatkueffer.ch
www.beatkueffer.ch
     
     
Web-Design und Programmierung, Multimedia-Authoring.