Re: Simple Problem ?
От | Hengky Lie |
---|---|
Тема | Re: Simple Problem ? |
Дата | |
Msg-id | 48CF7B00.9030402@gmail.com обсуждение исходный текст |
Ответ на | Re: Simple Problem ? (Guillaume Lelarge <guillaume@lelarge.info>) |
Ответы |
Re: Simple Problem ?
|
Список | pgsql-sql |
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). > > >
В списке pgsql-sql по дате отправления: