Error when executing sql update statement in OE Architect

[mc_pop]

Hello Everybody.

I have problem with sql update statemets.
When i run statement like below:

Update pub.Table
set Table.Field1 = 'aaaa'
where Table.field2 = 'bbbb'



I receive error like this:

[DataDirect][OpenEdge JDBC Driver][OpenEdge] Syntax error in SQL
statement at or about ".field1 = 'aaaa' where Table.field2" (10713).

What is the problem?
I thank you in advance and best regards.

 

[sdjensen]

Update pub.Table
set pub.Table.Field1 = 'aaaa'
where pub.Table.field2 = 'bbbb'?

 

[mc_pop]

Unfortunately it doesn't work.
Anyway thanks.

 

[Casper]

This works for me:

SQLExplorer>update pub.customer set name = 'casper' where "cust-num" = 16;
Update count = 1.

and the proof:

SQLExplorer>select name from pub.customer where "cust-num" = 16;
Name
----------------------------------------
casper

HTH,

Casper.