Errore di funzione Round con ADO in una Select.

Article View: free.it.visual-basic

Article #2902

Back to free.it.visual-basic Previous Next

#2902

From: Silvio
Date: Mon, 30 Dec 2002 14:21

27 lines
1755 bytes

Salve,
chiedo lumi su un problema:
� possibile ricavare in una select con ado, la funzione round su un numero ?
In pratica ho bisogno di ottenere dinamicamente l' arrotondamento e non il
valore intero (int) di un valore.
Scrivendo il seguente codice, mi da eerore di SQL:


  Dim connAS As New ADODB.Connection
  Dim cmdAS As New ADODB.Command
  Dim rsAS As New ADODB.Recordset


  connAS.Open "Provider=IBMDA400;Data Source=S442B51C;", "QSECOFR", "PROVA"
  Set cmdAS.ActiveConnection = connAS

  cmdAS.CommandText = "SELECT round(DPREZZ,2) FROM PRFGE0004.MFFBDE00"


  rsAS.CursorLocation = adUseServer
  rsAS.Open cmdAS, , adOpenStatic, adLockReadOnly
  rsAS.MoveFirst


Mi domando: "Come mai non riesco ad effettuare il round ?"

Grazie, saluti.

Technical Details

Message-ID: <QDYP9.8122$%p6.631910@news.edisontel.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!newsfeed.gamma.ru!Gamma.RU!newsfeeder.edisontel.com!news.edisontel.com!53ab2750!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ITALIAN,ASCII
X-Google-Thread: f94ee,b8c4b424f1670117,start
X-Google-Attributes: gidf94ee,public
X-Google-ArrivalTime: 2002-12-30 06:22:34 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!newsfeed.gamma.ru!Gamma.RU!newsfeeder.edisontel.com!news.edisontel.com!53ab2750!not-for-mail
From: "Silvio" <apocalipse@infinito.it>
Newsgroups: free.it.visual-basic
Subject: Errore di funzione Round con ADO in una Select.
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <QDYP9.8122$%p6.631910@news.edisontel.com>
Date: Mon, 30 Dec 2002 15:21:36 +0100
NNTP-Posting-Host: 62.94.37.84
X-Complaints-To: news@edisontel.com
X-Trace: news.edisontel.com 1041258096 62.94.37.84 (Mon, 30 Dec 2002 15:21:36 MET)
NNTP-Posting-Date: Mon, 30 Dec 2002 15:21:36 MET
Organization: EdisonTel SpA