JCapper Message Board

JCapper 101
-- track condition

Home	Register Log In

track condition

parshooter
10/19/2010
4:53:43 PM

I am unsuccesful at creating sequel mode UDM trying to eliminate muddy track conditions.
tkcond <> my kicks back an error message
Can anyone please advise correct wording?
Thank you

dvlander
10/19/2010
8:26:34 PM

Did you remember the quotes in the syntax?

TKCOND <> "MY"

parshooter
10/20/2010
12:26:49 PM

I hadn't used quotations. thank you for assistance. that worked. much appreceiated

jager fury
1/15/2011
10:50:03 AM

This may be a good thread to post this question;

What is the SQL text to narrow your query to inner dirt tracks, the "d" in Dirt.

For example, a query of AQU inner dirt track...?

SELECT * FROM STARTERHISTORY
WHERE INTSURFACE <= 2
AND TRACK='AQU'

Thank you for your assistance all!

jeff
1/15/2011
12:40:16 PM

From the Table Schema:


Field Name		Data Type	Description
---------------------   -------------   --------------------------------------
intsurface		number integer	surface type (1=D, 2=d, 3=O, 4=T, 5=t)

Grab inner dirt surfaces in a sql udm like this:

AND INTSURFACE = 2

-jp

.

JCapper Message Board

JCapper 101 -- track condition

JCapper 101
-- track condition