In database we use a GintPointSort function. How can we set the database so it sorts according to this column as default? Secondary, how can we set up also other list showing Points to be sorted according to GintPointSort as default?
Thank you for any advice
Hi Jakub,
The GinitPointSort field should do what you are looking for. A couple pointers that may help...
Make sure the GintPointSort field is not hidden. From the Point table, go to Tables>Show or Hide Fields and uncheck the Hide box.
If it's not hidden, but the field is read-only, right click in the GintPointSort column, go to Field Properties, and uncheck the gINT Method property. This should let you edit the sort values, and then gINT should use those values to sort the PointID lists.
More info can be found at Help>Index>GintPointSort and in this article.
If that's still not working, please let us know what you are experiencing, and we can look into it.
Thank you,
Jesse
Hi Jesse,
thanks for answer. I tried to set up default GintPointSort field and it works as intended. I think I know why it isn't working in our database. We use GR019 rule on database save for computing station along a baseline and GRA007 for GintPointSort method which is called via Add-Ins. The problem is that default sort rule (should be the same as GR016) works only on save also. GRA007 function seems to not saving the order nor it can be used in other dropdown menus. Can I merge both GR016 and GR019 rules so I can call them both on save? I think I could merge the rules themselves but should I merge also the Common parts? Or are they called separatedly and I can leave them as they are?
Thank you for your help.
Jakub
actualy I did manually changed the sorting logic from default one so I need to merge the rules. I will try it without merging the common procedures.
I tried to merge both GR016 and GR019 but I'm getting error which I'm unable to identify. Is there any easy way to check all the necessary thing to keep in mind when merging rules?
Thanks for any help.
There are many reasons you could be getting an error message, so it's hard to say without seeing your code or the error message.
The image below is one option you could use to merge the rules. With this approach you basically copy code from GR016 into GR019 and add the call to the HoleSortOrder procedure.
thanks for your help. I did what you suggest but the error persists. I think it is connected to the common procedures. I will send you files with code. Im not sure what valid data type there should be for the rule to work.
Any help would be much appreciated.
The error message occurred because the DAO reference was not set, which is used by the RecordsetClose procedure. To fix that, you need to open the [GR016 AND GR019 COMMON PROCEDURES] module and go to Edit>References. Then, scroll down and check "Microsoft DAO 3.6 Object Library (5.0)".
You will then need to do the same thing for the [GR016 and GR019] module.
Answer Verified By: Jakub Hruška