Round Function

[PremalathaP]

The following code in VB shows the error : "Undefined function 'round' in expression". [CODE] DataEnvironment1.Commands(1).CommandText="Select Round(Altitude,2) from Alt" [\CODE] Here, Altitude is a variable of type 'Number-Double' Alt is a table in MS-Access Database. Help me regarding this. Thanks in advance. -- modified at 2:18 Wednesday 1st February, 2006

[Lost User]

Try: DataEnvironment1.Commands(1).CommandText="Select Round(" & Altitude & ", 2) from Alt"

[PremalathaP]

Altitude is not a variable used in VB. Altitude is a Field in table Alt.

[Guffa]

I tried using Round in a query in Access, and that works fine, just as expected. Are you sure that it is an Access database that the connection is connecting to? Are you sure that the query that you have shown is causing the error? The code you show can never cause that error by itself, there has to be som code that runs the query also. --- b { font-weight: normal; }

[PremalathaP]

It is in access database only. I am getting the values if i use the query without using round function. It is showing error when i use the round function

[Guffa]

What is the complete error message? What databasedriver are you using, e.g. what does your connectionstring look like? --- b { font-weight: normal; }

[PremalathaP]

Error Message : "Undefined function 'round' in expression". Connection String : Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Premalatha\30_01_06-VrefAnalysis\VrefAnalysis.mdb; Persist Security Info=False Database Driver : Microsofy.Jet.OLEDB.4.0 -- modified at 7:07 Wednesday 1st February, 2006

[Lost User]

PremalathaP wrote:

Select Round(Altitude,2) from Alt

Try: SELECT ROUND(Alt.[Altitute], 2) FROM Alt