Re: [SQL] convert to a string

[Shavonne Marietta Wijesinghe]

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