[Openroad-users] ADO and decimal(8,0) problem

[Kim Ginnerup]

Hi All,

I have a problem extracting decimal data from MS SQLServer.

            con = MSADO!connection(MSADO!connection.new());
            rec = MSADO!_recordset(MSADO!_recordset.new());

            connectString =
                        'Provider=sqloledb;' +
                        'Network Library=DBMSSOCN;' +
                        'Data Source=xxx.xxx.xxx.xxx,1433;' +
                        'Initial Catalog=VIS_META;' +
                        'User Id=sa;' +
                        'Password=xxxxxxx';
            con.connectionString = connectString;
            con.open();
            selectString = selectString +' * FROM dbo.KUND_Reklamation where kunde = ''97295''';
            rec = con.execute(selectstring,,);
            if rec.EOF != TRUE THEN
                        rec.movefirst();
                        while rec.EOF = FALSE do
                                    i = i + 1;
                                    issues[i].kunde                          = rec.fields.item(0).value;

                        etc.

All other data in the select is ok but decimal data is always zero

In clues?


Venligst,/Regards,

Kim Ginnerup
Technical Manager
Bording Data A/S
Bredskifte Allé 11
DK-8210  Århus V
________________________
Tlf.:             4324 5424
Direkte tlf.  4324 5370
Fax:            8624 8626
Mail: kgi at bording.dk<mailto:kgi at bording.dk>
web: http://www.bordingdata.dk/
________________________________________________________________________
Til Deres information:
Med henblik på at dokumentere kommunikationen mellem Bording Data og kunder/partnere, foretages automatisk journalisering af ind- og udgående mails på firma/kontaktperson niveau.
For Your information:
In order to ensure documentation of communication between Bording Data and our customers/partners, in- and outgoing emails are journalized at company/contact level .

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.peerlessit.com/pipermail/openroad-users/attachments/20080520/210dc32f/attachment.html