|
|
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 |
