is their a way to goto a single record more easily then using a find
if (controller.find())
{
id = globals.selected_cons_id
controller.search()
}
it seems there should be a way of doing this with load records or something. I know the id is unique, it seems there should be a simple way of doing this.
Thanks
Hi David
Several ways to achieve this in Servoy.
Go to record from foundset in list - #5 by ROCLASI - Classic Servoy - Servoy Community
If you are looking for an equivalent of the FM GTRR command there are quite a few threads on this subject. Try putting GTRR in the Search box top right.
If you have two Forms using the same foundset - ie List and Detail Forms you can use:
var vIndex = forms.List.controller.getSelectedIndex()
forms.Detail.controller.loadRecords(vIndex);
For more examples take a look at the examples for loadrecords()
Regards
Graham Greensall
Worxinfo Ltd
Thanks Graham,
i am gradually picking this up.
I atually found a good way from the CRM solution and thats by lots of sub nested tab panels, with a drop down list of found records and then a further nested tab panel with a relationship from the selected_global_Id from the drop down list.
It all gets a bit mind boggling, but the result is well worth it and though not as quick as FM, a damn site quicker than PHP!
Youll be pleased to know i am working on the reportwriter solutiuon not the case management! I think it would be great to get that from FM to Servoy so it will keep me out of trouble with the main project!!!
Hi David
Surprised that Servoy is slower than FM
Bob Cusick has done some awesome work with Reporting from Servoy - try this link for a very good starting point. It will save many hours of work:
http://forum.servoy.com/viewtopic.php?t=5392
Regards
Graham
I wouldnt say slower Bob,
just a bit more technical and more challenging to work out how to do things.
However once mastered it is massively advantageous. I am already a true convert.
Just getting to the stage where i can annoyingly work some things out, like the above, for myself, but the forum and community advice is fabulous.
So is having the MD looking at his forum on a sunday night. I wish filemaker could look at their feedback on a sunday night and tell me why there solution falls over 3 times a week and corrupts its files!!!
Anyway not to worry, I look forward to coming over with Graham on the 23rd and persuading my team that it is time to rebuild our whole database platform in Servoy.
Thanks
Bob,
i downloaded this, but it didnt like me setting up the new database driver despite following the instructions.
it cam up with this:
org.apache.commons.dbcp.DbcpException: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused
java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused
i have attahced a file of what my setup looks like dba and sql in small letters.
My reportwriter is for medical reports rather than SQL ones but nonethe less i would be interested in looking at your application.
David
dpearce:
Bob,i downloaded this, but it didnt like me setting up the new database driver despite following the instructions.
it cam up with this:
org.apache.commons.dbcp.DbcpException: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused
java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refusedi have attahced a file of what my setup looks like dba and sql in small letters.
My reportwriter is for medical reports rather than SQL ones but nonethe less i would be interested in looking at your application.
David
David,
Try changing the Sybase Driver.
Currently, the “Driver” reads:
“com.sybase.jdbc2.jdbc.SybDriver”
The “Driver” should read:
“com.sybase.jdbc3.jdbc.SybDriver”
NOTE: Do NOT include the quote marks (")
The value that is auto-inserted for the driver when creating a new
Sybase connection is a bug that has been fixed in Servoy 3.1.
Marc Norman
Servoy
still comes up with the same error?
David
username dba
password sql
Hi i have tried this on another machine.
setup the sybase.config file properly.
made sure the database file is read and writeable
and it still give me the same error?
org.apache.commons.dbcp.DbcpException: java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).
java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).
Any clues?
David
After setting up the Sybase database and editing the config file you have to close Servoy AND close the Sybase “dbserv9” service. Then re-start Servoy Developer.
Alternatively try MySQL - just create the DB in Navicat or similar and Servoy will be able to connect immediately without any editing or re-starting.
Graham Greensall
Worxinfo Ltd
