Powered by Jitbit .Net Forum free trial version. dismiss

HomeProblems and issues

Post bug reports here. The forum is pre-moderated, your message will appear after being checked by us.

Cannot edit/delete rows from table where PK = INT Messages in this topic - RSS

falloutphil
falloutphil
Posts: 29


8/3/2017
falloutphil
falloutphil
Posts: 29
Hi,

my_table consists of:

id integer not null
stringa varchar(80) not null
stringb varchar(10) not null
stringc varchar(20)

SQL Query:
SELECT id, stringa, stringb, stringc
FROM my_table
ORDER BY stringa


I make the each column editable in the output columns, and allow data editing and delete of records in the data editing section.
PK field name is id

(Typically I would hide the id column and not make it editable - this makes no difference to the issue).

I can add records fine.

But if I try to edit or delete records I get:
42883:operator does not exist: integer = character

I can edit and remove for the SQL console fine.

My underlying database is Postgres 9.5.7

Now - if I change the PK field name to stringa (which just happens to be unique on this table) it works! So the issue is to do with the filtering of any given statement on an integer column.

Any ideas?

Thanks,

Phil.
0 link
Gleb
Gleb
Administrator
Posts: 41


10/2/2017
Gleb
Gleb
Administrator
Posts: 41
Fixed in 1.3
0 link






Powered by Jitbit Forum 8.3.8.0 © 2006-2013 Jitbit Software