Re: Problem with merge command.

[Steve McLeod]

Vineela,

When you say "doesn't work", what exactly do you mean? What do you expect and what actually happens?

Can you post a complete example that reproduces the problem?

On Thursday, 2 August 2012 20:29:12 UTC+2, Vineela Gampa wrote:

"CREATE TABLE IF NOT EXISTS states ("
                               + "time TIMESTAMP,"
                               + "state INT,"
                               + "test VARCHAR,"
                               + "test12 VARCHAR,"
                               + "CONSTRAINT latest_pk PRIMARY KEY (test,test12),"
                               ");

MERGE INTO states(time,state,test,test12)" +
                                                    " KEY(test,test12) VALUES(?,?,?,?)"
                                                    ,timestamp,2,"<test>abc</test>","<test12>abc12</test12>");

This doesn't seem to work incase of an update. Inserts are happening fine.
Is there something wrong with the statement?

[Vineela Gampa]

Inserts are working fine. But updates are not.

[Thomas Mueller]

Hi,

Inserts are working fine. But updates are not.

The question was "Can you post a complete example that reproduces the problem?"

Regards,

Thomas

[Vineela G]

Hi Thomas

Merges are working fine with h2.  There seems to be someother problem wiht our code.

Thanks for the help.

--
You received this message because you are subscribed to the Google Groups "H2 Database" group.
To post to this group, send email to h2-da...@googlegroups.com.
To unsubscribe from this group, send email to h2-database...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.