i figured it out
Set oRs = oConn.Execute("SELECT N_GEN FROM " & MyTable & " ORDER BY N_GEN::INT
DESC")
thanks to everyone
----- Original Message -----
From: Shavonne Marietta Wijesinghe
To: [email protected]
Sent: Tuesday, March 06, 2007 3:32 PM
Subject: Re: [SQL] convert to a string
when i try the
set oRs = oConn.Execute("SELECT N_GEN::int FROM MyTable ORDER BY N_GEN DESC")
it returns 1 and for the rest i doens't change. alsways 10
:(
----- Original Message -----
From: Bart Degryse
To: [email protected]
Sent: Tuesday, March 06, 2007 2:54 PM
Subject: Re: [SQL] convert to a string
I assume GetFieldValue is the name of a VB function or property get?
Try either
Set oRs = oConn.Execute("SELECT N_GEN::int FROM MyTable ORDER BY N_GEN
DESC")
or
GetFieldValue = cint(oRs("N_GEN")) + 1
or
GetFieldValue = clng(oRs("N_GEN")) + 1
In the last two cases make sure that the function or property get returns
an int or long
Also remember that if oRs("N_GEN") is NULL the sum will also be NULL
>>> "Shavonne Marietta Wijesinghe" <[EMAIL PROTECTED]> 2007-03-06 14:42 >>>
Hello
i have a column N_GEN in postgreSql defined as text. In this coloumn i
insert a number 10
N_GEN (text) = 10
on error resume next
Set oRs = oConn.Execute("SELECT N_GEN FROM MyTable ORDER BY N_GEN DESC")
If err <> 0 then 'If table not found
GetFieldValue = "1"
else
GetFieldValue = oRs("N_GEN") + 1
End If
But it doesn't add the 1 to my N_GEN
How can i set the Recordset to convert the string to a number and then add
1 to it??
Shavonne Wijesinghe
http://www.studioform.it
