= 2007-03-06 14:42 >>> Hello=20 i have a column N_GEN in postgreSql defined as text. In this coloumn i = insert a number 10 N_GEN (text) =3D 10=20 =20 =20 on error resume next Set oRs =3D oConn.Execute("SELECT N_GEN FROM MyTable ORDER BY N_GEN = DESC") If err <> 0 then 'If table not found GetFieldValue =3D "1" else GetFieldValue =3D oRs("N_GEN") + 1 End If =20 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?? =20 Shavonne Wijesinghe http://www.studioform.it ( http://www.studioform.it/ ) =20 =20 --=__Part4662E3FA.0__= Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Description: HTML

As Andreas already asked: do you really have a good reason to store = numbers as text

If so, show us some more information: table definition, some table = data, a complete (vb?) function/property get, ... anything that is = directly involved.

>>> "Shavonne Marietta Wijesinghe" <shavonne.marie= tta@studioform.it> 2007-03-06 15:32 >>>

when i try the

set oRs =3D = 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 =3D oConn.Execute("SELE= CT N_GEN::int FROM MyTable ORDER BY N_GEN DESC")

or

   GetFieldValue =3D = cint(oRs("N_GEN")) + 1

or

   GetFieldValue =3D = 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" <shavonne.marietta@studioform.it> 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) =3D 10

on error resume next
  Set = oRs =3D oConn.Execute("SELECT N_GEN FROM MyTable ORDER BY N_GEN DESC")
&= nbsp; If err <> 0 then 'If table not found
   = GetFieldValue =3D "1"
  else
   GetFieldValu= e =3D 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

--=__Part4662E3FA.0__=--