Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EGL Development Tools » Delete(Problem when file has two keyfields)
Delete [message #778298] Thu, 12 January 2012 08:13 Go to next message
Trond Einar Nilsen is currently offline Trond Einar NilsenFriend
Messages: 33
Registered: December 2011
Member
I have a problem when I try to delete a record in a file with two keys.

---------error----------
[SQL0104] Token G8C5NB was not valid. Valid tokens: OR USE SKIP WAIT WITH.: [sqlstate:42601][sqlcode:-104]

---------record---------
Record G8
{@table{name = "SESQL.SNG8CPP"}}

G8JWNB decimal(6){@ID};
G8C5NB decimal(5){@ID};
G8AUNA string;
end
--------EGL service----------
function deleteG8(delG8 g8 in)
delete delG8 from ds;
end
--------generated Java----------
String stmtStr = "DELETE FROM SESQL.SNG8CPP WHERE G8JWNB = ?G8C5NB = ?";
--------------------------------
When I correct the generated Java to:
String stmtStr = "DELETE FROM SESQL.SNG8CPP WHERE G8JWNB = ? AND G8C5NB = ?";
it works fine. I guess this is due to an error in EDT that will be fixed for later releases?
Re: Delete [message #778331 is a reply to message #778298] Thu, 12 January 2012 12:15 Go to previous message
Joseph Vincens is currently offline Joseph VincensFriend
Messages: 31
Registered: December 2011
Location: Prospect CT
Member
Hi,

Yes that is a defect. Please open a bugzilla defect for this so it gets fixed and tested. htps://bugs.eclipse.org/bugs/ Please include a link to your forum post, set the component to JavaGen, and put SQL in the summary so the defect gets routed to the correct person.

thanks,
Joe
Previous Topic:EDT 0.8.0 Planning
Next Topic:New blog post - Creating EGL projects
Goto Forum:
  


Current Time: Wed Nov 26 15:29:17 GMT 2014

Powered by FUDForum. Page generated in 0.01826 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software