Re: [SQL] convert to a string

[Shavonne Marietta Wijesinghe]

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: pgsql-sql@postgresql.org 
  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