Problem adding a record with vb6 - Mailing list pgsql-general

From Cha Men Hui
Subject Problem adding a record with vb6
Date
Msg-id 20060601184351.69879.qmail@web31605.mail.mud.yahoo.com
Whole thread Raw
List pgsql-general
I have visual basic 6 with sp6 and I'm trying to add data to PG table, but it gives a error msg like this:

Current recordset doesn't support updating. This may be a limitation of the provider or  of the selected locktype.

and I don't know what can it be, this is the code that I use:


strSql = "Provider=PostgreSQL; User ID=postgres; Password=mykey; data source=mypc; location=mybd;"
conex.Open strSql

strSql = "select * from prueba limit 1"
rsTabla.Open strSql, conex, adOpenKeyset

rsTabla.AddNew
rsTabla!ced = 1
rsTabla!nombre = "prueba"
rsTabla.Update


just when arrive to add method explode

some advice???

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: Re: problemas con psql -l
Next
From: "Alex Turner"
Date:
Subject: Re: SCSI disk: still the way to go?