Bugzilla – Full Text Bug Listing
| Summary: | SQL - problem when I try to delete a record in a file with two keys. | ||
|---|---|---|---|
| Product: | z_Archived | Reporter: | Trond Einar Nilsen <trond.einar.nilsen> |
| Component: | EDT | Assignee: | Project Inbox <edt.javagen-inbox> |
| Status: | RESOLVED FIXED | QA Contact: | |
| Severity: | normal | ||
| Priority: | P3 | CC: | jvincens |
| Version: | unspecified | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | Windows 7 | ||
| Whiteboard: | |||
updating to show that this was found in the 0.7.0 driver. fixed the same problem also existed in replace |
Build Identifier: Version: 0.7.0 ---------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 = ?"; http://www.eclipse.org/forums/index.php/t/275880/ Reproducible: Always