From: | Cha Men Hui <chamen_mail(at)yahoo(dot)com> |
---|---|
To: | PostgreSql MailList <pgsql-general(at)postgresql(dot)org> |
Subject: | Problem adding a record with vb6 |
Date: | 2006-06-01 18:43:51 |
Message-ID: | 20060601184351.69879.qmail@web31605.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Turner | 2006-06-01 20:30:27 | Re: SCSI disk: still the way to go? |
Previous Message | John DeSoi | 2006-06-01 17:25:19 | Re: problemas con psql -l |