I hope that someone out there might have time to help me with my question. I am playing with Servoy and enjoying it so far but I am having a hard time making a transition to the sql data manipulation in servoy.
So in my reading I would like to know…
Can anyone point me to a good resouce (thread, tutorial etc) with indepth discussion of running an sql query and getting the results in servoy.
The advanced programing guide didn’t have a lot of detail on sql and result manipulation. I have also searched the threads, but they are focused on specific problems and solutions rather then a general tutorial.
Can I maniupate an SQL Result set as if it were a multi diminsional array?
Is there a better way to display results then looping through an array?
Can I put the result of a query in a calculated field?
ie…
“Select count(idfield) FROM SomeTable”
The advanced programing guide didn’t have a lot of detail on sql and result manipulation. I have also searched the threads, but they are focused on specific problems and solutions rather then a general tutorial.
The beste way to learn using this, imho, is to read the docs (sorry) but better still to get the sample code and manipulate this is a small sample solution…
Can I maniupate an SQL Result set as if it were a multi diminsional array?
Yes, see the sample code.
Is there a better way to display results then looping through an array?
Again, see the sample code. You can use controller.loadRecors and/or controllershowRecords for this.
Marcel thanks for the advice. I am slowly figuring out how javascript, sql, and servoy works but progress for me seems more like trial and error then actually learning.
gte451f:
Marcel thanks for the advice. I am slowly figuring out how javascript, sql, and servoy works but progress for me seems more like trial and error then actually learning.
Trial and error has been proven to be one of the most succesful learning methods to learn anything.