jaleman:
== page 180==
Servoy only has one form of goto releated which does exactly what it says, it shows related records, nothing more and nothing less.
We frequently invoke Show GTRR just before jumping to a layout, or before running a loop. But there must be dozens of different ways we use this very useful command. I need much greater clarity on this one, please. Comments?
What else would you like to know about it?
In FMP there are two forms – just go to the first available related record, and Show which presents only records that satisfy the relationship.
It sounds as if Servoy has only the equivalent of FMP’s Show GTRR, which is fine. Initially I read your text as the other way around.
Within FMP we frequently use the Count function to identify whether there are any records satisfying the relationship before involking GTRR. Even more frequently we use Show GTRR before initiating a loop.
jaleman:
== page 198==
Show index is a specific Filemaker function that is not available in Servoy. First of all most SQL environments don’t allow you to retrieve the contents of an index, secondly most SQL database index per column as opposed to Filemaker which indexes per word. There are many other ways in Servoy to help users search for data, keep in mind that in Servoy you have navigation panels to help navigation and search as well as popup forms that you can design to offer fast searches with much greater flexibility. Lastly you also have full SQL access to any datasource for even greater flexibility.
The major way we currently use the Index function is this. In FMP we present the user with a “Search…” button, which switches the user into Find mode and a special screen. Here they are shown with fields with buttons next to each. The button presents the user with an Index of all the valid options for that field.
This has been a very user friendly intuitive search technique for our users. What would be a suitable Servoy technique for an equivalent?
We frequently use the Index function when developing within FMP but the above is the only one I can think of to which the end user has access.
== page 273==
getSummary is not supported at this point in time. You can get the same behaviour by using a selfjoin or you can use an executeSQL statement to accomplish the same. Your SQL query will look like this:
FMP: GetSummary(summary field, break field)
SQL: Select SUM(summary field) from tablename where BreakField= break field
Replace SUM with desired summary function, tablename with the name of the table, summary field with the field you want to sum on, BreakField with the column name of the break field and “break field” with the value of BreakField in the current record.
== status current error==
More errors will appear soon, it is work in progress
==page 295==
getMaxRecordIndex() returns max 200 rows, so it is very usable to check on counts, if you have more rows you can use getFoundSetCount() which will be expensive if you have millions of rows so only use it if you really need to know the TOTAL foundcount
Servoy doesnt have a unique form number so the currentLayoutnumber function cannot be supported
==page 309==
There is no usercount currently but it will be added in future versions
==page 313==
In servoy you can fill a valuelist with a custom selection of choices.
Within FMP we frequently use the Count function to identify whether there are any records satisfying the relationship before involking GTRR. Even more frequently we use Show GTRR before initiating a loop.
jaleman:
== page 210==
Import Records/Export is not available as a method step. You can do export and import using dialogs or write directly data to a file (using a method to gather the data). Import and export through methods is planned for a future version.
Recommend adding that clarification to the text.
We use FMP’s Import function quite extensively behind the scenes in supporting clients. We definitely need to know the options for bringing data in.
Currently we also give users access to FMP’s Export function through a script. Select a document and instead of choosing the Print button, choose Export. The user is then given a choice of Excel or FMP formats. In fact the Excel option is tab delimited text with a “.xls” extension.
It would be useful to know what options we can give to end users for migrating selections of their data for independent analysis. A genuine Excel format would be excellent.
jaleman:
Servoy will support Halt in the future to be able to support converted scripts. It is not recommended to use Halt both in Servoy and in Filemaker. It’s better to program your scripts/methods correctly
Here’s how we’re currently using the Halt command within FMP. I’d be curious to know an alternative.
Because the Mac OS supports zoom, as control is shifted from file to file, open windows of other files appear underneath. Therefore we’ve created a utility script which calls a Hide command in the other files, then calls Halt.
When we make a call to an external script that transfers control, we follow it up with a call to that file’s Halt Script which also ensures the user is left in the target file, not dangling in the originating file.
I would assume within a Servoy environment calls to such Halt Scripts would not be required.
Because in Servoy methods have access to the entire solution (in filemaker only one file) you don’t have to do the HALT workaround to end up somewhere. You should never use halt, always make your conditions in such a way that everything is catched properly.
jaleman:
== page 198==
Show index is a specific Filemaker function that is not available in Servoy. First of all most SQL environments don’t allow you to retrieve the contents of an index, secondly most SQL database index per column as opposed to Filemaker which indexes per word. There are many other ways in Servoy to help users search for data, keep in mind that in Servoy you have navigation panels to help navigation and search as well as popup forms that you can design to offer fast searches with much greater flexibility. Lastly you also have full SQL access to any datasource for even greater flexibility.
The major way we currently use the Index function is this. In FMP we present the user with a “Search…” button, which switches the user into Find mode and a special screen. Here they are shown with fields with buttons next to each. The button presents the user with an Index of all the valid options for that field.
This has been a very user friendly intuitive search technique for our users. What would be a suitable Servoy technique for an equivalent?
We frequently use the Index function when developing within FMP but the above is the only one I can think of to which the end user has access.
Can you give an example on how that helps? Doesn’t a user know what he is searching for that he has to be presented with all possiblw words he can search for?
jaleman:
== page 219==
showdialog only does very basic dialogs. For more controll use showFormInDialog, with that function you can pop a form into a dialog giving you ALL the flexibility (design, scripts, events) you could ever need.
Excellent.
Currently we use the excellent Troi FMP Dialog exclusively, but I’d like to branch beyond even its limitations. Eager to see examples of what’s possible within Servoy. Some references and screenshots in your document would be helpful.
jaleman:
==page 295==
getMaxRecordIndex() returns max 200 rows, so it is very usable to check on counts, if you have more rows you can use getFoundSetCount() which will be expensive if you have millions of rows so only use it if you really need to know the TOTAL foundcount.
In other words Servoy really does have equivalents to FMP’s CurrentFoundCount function. One which will efficiently report if a relationship has any rows, a handful or something more than 200.
I doubt very much we’ll have much call on getFoundSetCount() but it’s good to know it’s available.