updatetable problem

[juned_seskoad]

Dear All,

On Postgress I have a table test with field id and name.
I'm trying to insert data using updatetable
=> updatetable test;
but it not work, error message
ERROR: column "id" of relation "test" does not exist
Position: 27 - SQL: insert into base.test (id,name) values (&&{Id},&&{name})

I try this SQL on postgress directly also problem with same message

Than I change SQL with add quote (") for identify field name
=> insert into base.test ("id","name") values (1, "test")
and it work. why could this happen ? does ebase SQL and postgress SQL different ? because I'm trying using MYsql with SQL from ebase it work (without quote (") for field name)

can somebody help me, thanks for attention

Regards

Juned

[juned_seskoad]

yesterday I find the answer, before i have table on postgres name "test", with field ID and Name. in ebase updatetable() running sql script inser into (nameoffield) value (value), name of field in ebase always using lowercase and postgress is case sensitive. after i change all field name with lowercase it work fine.

thanks for all attention

Regards

Juned

[Steve]

Thanks Juned,

This is useful information.

Steve