Eclipse Community Forums: EGL Development Tools » Cannot use GET with FROM clause within FOREACH

Help

Home

Home » Archived » EGL Development Tools » Cannot use GET with FROM clause within FOREACH

Show: Today's Messages :: Show Polls :: Message Navigator

Cannot use GET with FROM clause within FOREACH [message #810818]

Thu, 01 March 2012 15:40

Daniel Rippa

Messages: 10
Registered: March 2012

Junior Member

EGL Development Tools
Version: 0.8.0.v201202280901-1Co-FjuJ6QMNSP3ynscd8h8C
DedicatedService
Eclipse 3.7.1
Generation Language: Java, JavaScript

Error:
IWN.VAL.6510.e 36/28
The FOREACH SQL I/O statement does not allow the FROM option to be specified more than once.

...
ds SQLDataSource? {@Resource{uri="binding:SomeValidBinding"}};
...
 
function ...
 
  rs SQLResultSet?;
  open rs from ds using(someParameter) with #sql{
    select * from someTable where someField = ?
  };
  someRecord1 SOMERECORD;
  forEach (someRecord1 from rs)
    someOtherRecord1 SOMEOTHERRECORD { id=someRecord1.ID };
    get someOtherRecord1 from ds; <-- ERROR occurs here
  end

end

Is this illegal syntax?

Report message to a moderator

Re: Cannot use GET with FROM clause within FOREACH [message #810837 is a reply to message #810818]

Thu, 01 March 2012 15:57

Justin Spadea

Messages: 66
Registered: July 2009

Member

Hi Daniel,

This is a bug in validation. Please submit a bug report at "https: //bugs.eclipse .org/bugs/enter_bug.cgi?product=EDT" (remove the spaces, this forum isn't allowing me to post hyperlinks).

For now you can work around this by putting the code in another function and invoking the function inside the forEach block.

-Justin

Report message to a moderator