|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | A few questions | |
| rosenowsr 1/22/2012 12:33:22 PM | There are some drop downs from the data window that don't seem to work in SQL Mode such as "finish call position last out" is this normal or am I wording it wrong in the expression. Is there a list of wording syntax for the expressions in SQL mode ? I noticed some are not as written in the data window such as lifetime starts is written as startslifetime. Or am I "nitpicking"? It is a cold wintery day in Chicago and I have nothing better to do. LOL
| |
| jeff 1/23/2012 12:03:52 PM | Q. There are some drop downs from the data window that don't seem to work in SQL Mode such as "finish call position last out" is this normal or am I wording it wrong in the expression. A. The field name from the Table Schema is posfincall. Suppose for example that you wanted to write a sql expression that only flagged horses that won their most recent start. A line like the following would get the job done: AND POSFINCALL = 1 If you select Finish Call Pos Last Out from the factors drop down before running your query, you should be able to verify this. Q. Is there a list of wording syntax for the expressions in SQL mode ? I noticed some are not as written in the data window such as lifetime starts is written as startslifetime. Or am I "nitpicking"? A. There is a published list of StarterHistory table field names that can be found in the Table Schema. Examples of how to use them can be found in the Cheat Sheet. Links to both, along with links to sql videos and online sql tutorials can be found at the JCapper 101 Audio Video page at JCapper.com. Hint: Goto JCapper.com and click Capper 101 Audio Video. Then click the Operating JCapper jn Sql Mode link. -jp .
| |
| rosenowsr 1/23/2012 1:47:56 PM | Thanks JEFF.
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |