|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Operating in Playlist and SQL Modes | |
| crestwood1972 7/31/2012 3:31:00 PM | I have been using SQL since 1991 so I am very comfortable with the language, but I prefer operating in Playlist mode. Trouble is, I would like to select certain factors for the HTML report to appear in the User Factor slots and am looking for the easiest way to do this (the factors I want will change from race to race). It appears that I need to do this in SQL mode. Can I switch back and forth between the two modes simply by changing the option in the System Settings? Or will doing the setup for SQL mode adversely affect the Playlist mode operation? Again, what I'm really trying to do is see a particular factor's ranking show up on the HTML report.
| |
| jeff 7/31/2012 5:30:42 PM | You can switch back and forth between playlist file mode and sql mode at will. A few things to be aware of: • When you switch, Calc Races routines run after the switch will be in mode just switched to. • The sql mode html report can be readily customized by the user (pretty much the entire report layout.) • The playlist file html report has a handful of items that are user defined. For example, you can choose to hide or display UserFactors. • UserFactors 1-5 that you create are identical in both modes. Switching from sql to playlist and back again won't affect value, rank, and gap of your UserFactors. -jp .
| |
| jeff 7/31/2012 5:39:37 PM | --quote: "Trouble is, I would like to select certain factors for the HTML report to appear in the User Factor slots and am looking for the easiest way to do this (the factors I want will change from race to race). It appears that I need to do this in SQL mode."--end quote Am I reading this right, are you are asking to have UserFactor1 be one thing in playlist file mode and another in sql mode? If so, you would run a playlist file mode Calc Races while UserFactor1 is defined so as to generate the number you want to see on the playlist file mode report. You would also keep the playlist file mode report itself open in the Report Viewer or a browser window. You would then switch to sql mode, change the factor definition for UserFactor1 to make it be the number you want to see on the sql mode report - run a sql Calc Races - and open the report in a second instance of the report viewer or a second instance of your web browser. If my understanding of what you are asking for is correct - that's how I would proceed. Under those circumstances you can switch back and forth between modes at will - you just need to make sure that the table entries that define UserFactor1 for sql mode are what you want them to be before running the sql mode Calc Races routine (and vice versa.) -jp .
| |
| crestwood1972 7/31/2012 6:13:41 PM | No, I wasn't asking for the User Factors to be differently defined between the two modes. Is there a way to define a User Factor to say WILLTOWIN in Playlist mode? Or must it be done in SQL mode?
| |
| jeff 7/31/2012 6:53:47 PM | Once created, a UserFactor is identical (and available) in both modes. So yes, WILLTOWIN can be grabbed in a UserFactor in both playlist file mode and in sql mode. It's the table entries in the ImpactValues table that are used by the program to control how a UserFactor is calculated (and nothing else.) Give your UserFactor a 3 translate behavior, use ALL.* for surface and distance, grab the desired factor name by selecting it from the factors drop down (in this case WILLTOWIN) and hit the save button. At that point, the UserFactor will be a direct translation of the factor you selected from the drop down - and you will get the desired result for that UserFactor (in this case WILLTOWIN) no matter what mode you happen to be operating in. -jp . ~Edited by: jeff on: 7/31/2012 at: 6:53:47 PM~
| |
| crestwood1972 7/31/2012 7:17:22 PM | OK, that's exactly what I'm looking for. Thanks Jeff.
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |