I have to use sql command because i want to retrieve data according to
several criteria.
The SQL command just a sample to show that the data i retrieve not
updateable. The real query like :
SELECT * FROM TBLPRODUK WHERE SUBKAT='abc';
So i do not need to view data from data viewer, but using query with an
updateable result.
Any suggestion ?
Thanks in advance
Guillaume Lelarge wrote:
Hengky Lie a écrit :
This is the same as what i think but the table has primary key and has
no relation to other table. This is the table definition :
[...]
These query result non updateable records :
SELECT kode, namabarang from tblproduk;
SELECT * from tblproduk;
What is the problem ?
Oops, I was wrong on this. You can't edit results in the query tool. You
need to use the data viewer (menu Tools/View Data/View All Rows ;
there's also a button in the toolbar).
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql