|
Rank: Advanced Member
Joined: 8/19/2012 Posts: 149 Location: Ireland
|
Sometimes database design can become complex and there could be 5 or more tables required to generate the output.
Working on Mapforce blocks in this case becomes too hard as you need to manage too many conditions, whereas the database query could produce such a result straight away.
I think it would be useful to be able to pass input variables to a SQL statement. i.e. (select * from a JOIN b ON a.i=b.i where a.b=:bVariable and (a.c+b.c)>200) which would produce bVariable input in the query block (just like in SQL-Where/Order)
PS. The example is only to give the idea of how such a thing could look
Thanks for your consideration
|
|
Rank: Advanced Member
Joined: 12/13/2005 Posts: 2,856 Location: Mauritius
|
All you need is to update to MapForce 2013 - everything you are looking for is there!
|
|
Rank: Advanced Member
Joined: 8/19/2012 Posts: 149 Location: Ireland
|
vlad wrote:All you need is to update to MapForce 2013 - everything you are looking for is there!
Thanks vlad!
It looks like I somehow missed this feature in the "new features" list...
|
|
Rank: Member
Joined: 2/5/2013 Posts: 27 Location: Colorado
|
Thank you guys for this information. I would to say that all my projects are finally generated into a java code and run with ant, but the information you have provided seem not to work with java code generation. Any idea as to how to accomplish such as task in java?
Regards,
|
|
guest |