Eclipse Community Forums: EGL Development Tools

Home » Archived » EGL Development Tools » Delete(Problem when file has two keyfields)

Thu, 12 January 2012 03:13

Eclipse User

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 07:15

Eclipse User

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:

-=] Back to Top [=-

Current Time: Fri Oct 24 09:55:33 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter