Gastion

Hello, ExecuteSQL("select count(Distinct /"Date/" ) from Reports";"";"") should work... I agree with Wim, Date is a reserved word. , It's better to use dat to name this type of field.

Thanks Fabrice ! Great technic without calculation in the sales table. I'm happy to discover this snapshot link manipulation. It will make fast sort on big foundset. Have a nice day !

Hello Fabrice, I'm back after some corrections. Color line trouble is solved. Date Range Filter is activated. I think that it might ok... Just waiting for few suggestions if needed ? Best regards. DynamicSortChallenge v2 FB.fp7.zip

Hello Fabrice, I'am french but I do appreciate Belgian chocolate. So , I've tried to find a rapid solution for this dynamic sorting. I have to solve the remaining problem with my empty color lines, but now it 's to late in the evening. Otherwise, I wanted to post my file. This is my first approach. It's so fun to participate to this sweet challenge. Best regards DynamicSortChallenge FB.fp7.zip

Thank you John for your advice. Best regards :smile:

WOUAH !!!! GREAT :yep: Thanks a lot ! In my solution, nothing was returned with SMGetLoadedJars. Next, I was looking in ScriptMaster solution. Mail and Activation.jar are ticked. I thought that this problem could be with these two librairies, as said on the top most Jar Librairies panel of this solution. But I had no idea on how to solve the problem. You found the Answer . THANKS

Hello, It seems that I have the same problem than emosensei. My function's code is unmodified. I just copy the code in ScriptMaster (copy to clipboard in the Register Panel) and then copy this code in SetVariable in my StartupScript of my solution. I will post tonight the result of SMGetLoadedJars (I'm not now with my own computer)...

Hello, I'am using Scripmaster 4_131 with FM10A and FM11 on Mac (10.6.8 and 10.5.8) and on windows XP. I have also tried with Scripmaster 4_132 I have no problem for registering CreateFolder, with the variable declaration in my startup script. But, when I try to register Send Email With Authentication on startup, with a variable declaration (copy to clipboard method), this function is not registered. The report with SMLastError is: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed: Script1.groovy: 10: unable to resolve class MimeMessage @ line 10, column 14. MimeMessage msg = new MimeMessage(Session.getInstance(props)); ^ Script1.groovy: 10: unable to resolve class MimeMessage @ line 10, column 20. MimeMessage msg = new MimeMessage(Session.getInstance(props)); ^ Script1.groovy: 11: unable to resolve class Multipart @ line 11, column 12. Multipart content = new MimeMultipart(); ^ Script1.groovy: 11: unable to resolve class MimeMultipart @ line 11, column 22. Multipart content = new MimeMultipart(); ^ Script1.groovy: 13: unable to resolve class MimeBodyPart @ line 13, column 15. MimeBodyPart bodyPart = new MimeBodyPart(); ^ Script1.groovy: 13: unable to resolve class MimeBodyPart @ line 13, column 26. MimeBodyPart bodyPart = new MimeBodyPart(); ^ Script1.groovy: 18: unable to resolve class MimeBodyPart @ line 18, column 16. MimeBodyPart attachmentPart = new MimeBodyPart(); ^ Script1.groovy: 18: unable to resolve class MimeBodyPart @ line 18, column 33. MimeBodyPart attachmentPart = new MimeBodyPart(); ^ Script1.groovy: 24: unable to resolve class InternetAddress @ line 24, column 14. msg.setFrom(new InternetAddress(from)); ^ Script1.groovy: 25: unable to resolve class InternetAddress @ line 25, column 45. ent(Message.RecipientType.TO, new Intern ^ Script1.groovy: 27: unable to resolve class Transport @ line 27, column 12. Transport transport = Session.getDefaultInstance(props).getTransport("smtp"); ^ 11 errors The only way to register this function in my solution is to use the Register on startup method with a scripts that opens and closes ScripMaster. Do you have any idea for this problem ? Thanks a lot