Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > ADO Data > Problemas using...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 4241 of 4320
Post > Topic >>

Problemas using "Unique Table" in PostgreSQL

by =?iso-8859-1?Q?Fabi=E1n_Tom=E1s_de_Paula?= <fabiandepaula@[EMAIL PROTECTED] Jun 4, 2008 at 12:54 PM

Working with SQL Server i havent any problem. But i start to work with 
PostreSQL and now i cannot update ADO.Recordset when de SELECT - SQL join 
other tables than de Principal or Updateable table.

The Select used is the following

SELECT unidroga.*, drogas.descrip AS NameDroga FROM unidroga INNER JOIN 
drogas ON unidroga.droga = drogas.coddroga WHERE (unidroga.articulo = 
'_838394932')

and i use this to update only the table unidroga.

oAdoRS.Properties("Unique Table").Value = "unidroga"

This works with SQL - SERVER but doesnt work with PostgreSQL, anyone can 
help me???

Fabián.
 




 2 Posts in Topic:
Problemas using "Unique Table" in PostgreSQL
=?iso-8859-1?Q?Fabi=E1n_T  2008-06-04 12:54:28 
Re: Problemas using "Unique Table" in PostgreSQL
"Bob Barrows [MVP]&q  2008-06-03 15:41:02 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 15:15:06 CST 2008.