|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Sql Mode - No value given for one or more required parameters | |||
| jeff 8/7/2011 12:45:04 AM | re: Sql Mode - No value given for one or more required parameters
First, here's a link to a screenshot of the message: http://www.jcapper.com/messageboard/avatars/novaluegiven.jpg Next, here's a link to a screenshot of the Sql Expression Tool in the Data Window: http://www.jcapper.com/messageboard/avatars/badtablefieldname.jpg Look at the above linked to screenshot and pay particular attention to the table field name in the sql expression. In the above linked to screenshot, I purposely keyed in a bad starterhistory table field name - one that's obviously not a valid field name listed in the table schema. FYI, link to Table Schema: http://www.jcapper.com/helpdocs/starterhistorytableschema.html The error is caused whenever the user tries to execute a query with a misspelled or otherwise bad/invalid field name for the table referenced by the query. Recommendation: Familiarize yourself with the starterhistory table field names listed in the table schema. Any time you get the above error message - immediately look at the field names referenced in the query you are trying to execute. It's about 100% likely that one of the table field names is either misspelled or not a valid field name to begin with. Hope I managed to 'splain most of that in a way that makes sense. -jp . ~Edited by: jeff on: 8/7/2011 at: 12:45:04 AM~
| |||
| jeff 8/10/2011 12:06:54 AM |
My reply: In your sql expression, DIST, INTSURFACE -- these work because they are names of data fields in the table as listed in the Table Schema. Link here: http://www.jcapper.com/helpdocs/starterhistorytableschema.html However, EARLYCONSENSUS, POWERCONSENSUS, LATECONSENSUS, FORMCONSENSUS, and LATEPACE3 are causing the interface to give you the error message because they aren't data field names in the table. If you search for them in the table schema you won't find them at all. They are however names of JCapper factors. You the user have the ability to "grab" 35 JCapper factors of your choice and add them to your sql factor setup. To display a list of your current 35 factors, bring up the Data Window in sql mode, click the sql button, and in the sql expression tool, click the Display Factors button. Then take a look at your 35 factors. Take note of the slot numbers for each factor. (To hide the list and get back to normal operation of the sql expression tool just re-click the Display Factors button.) Q. Which slot number is EARLYCONSENSUS in? In the default program setup it EarlyConsensus is in slot number 18. Unless you changed that, it should still be in slot #18. Next look at the field names toward the end of the table schema. You'll see field names in the table schema such as RANKF18, GAPF18, VALF18, etc. How do the two relate to each other? If you want to create a sql expression using rank = 1 for EARLYCONSENSUS and EARLYCONSENSUS happens to be sitting in slot #18, then your sql expression would look like this: AND RANKF18 = 1 RANKF18 happens to be a valid field name from the table schema (meaning that it won't cause the interface to raise an error if you use it in a sql expression.) If EarlyConsensus happens to be sitting in slot #18 - the interface will know - and it will give you EarlyConsensus when it processes slot #18. Please let me know if I managed to explain that in a way that makes sense, -jp .
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |