02-19-2016 04:12 AM
I have this PreExpression to an SQL statement step:
Locals.SQL_LatestResult = "SELECT UUT_RESULT.ID, UUT_RESULT.UUT_SERIAL_NUMBER, UUT_RESULT.START_DATE_TIME FROM UUT_RESULT WHERE (((UUT_RESULT.UUT_SERIAL_NUMBER) = \"" + Locals.serial + "\") AND ((UUT_RESULT.START_DATE_TIME)=(SELECT MAX(UUT_RESULT2.START_DATE_TIME) FROM UUT_RESULT AS UUT_RESULT2 WHERE UUT_RESULT.UUT_SERIAL_NUMBER = UUT_RESULT2.UUT_SERIAL_NUMBER)));"
Locals.SQL_LatestResult has this value after the PreExpression:
SELECT UUT_RESULT.ID, UUT_RESULT.UUT_SERIAL_NUMBER, UUT_RESULT.START_DATE_TIME FROM UUT_RESULT WHERE (((UUT_RESULT.UUT_SERIAL_NUMBER) = "15514011") AND ((UUT_RESULT.START_DATE_TIME)=(SELECT MAX(UUT_RESULT2.START_DATE_TIME) FROM UUT_RESULT AS UUT_RESULT2 WHERE UUT_RESULT.UUT_SERIAL_NUMBER = UUT_RESULT2.UUT_SERIAL_NUMBER)));
I get Number of records = 0, if i run the sequence.
If i copy the exact same SQL statement into to Access i get what i want i.e. one record.
If i remove this part from the query:
((UUT_RESULT.UUT_SERIAL_NUMBER) = \"" + Locals.serial + "\")
I get 388 records which is correct and the same as running it directly in access.
What is wrong here ?
Solved! Go to Solution.
02-19-2016 04:27 AM
I was too quick to post this... it's my own fault, the database link was wrong, so data was to there....
Statements are fine !