I run XP and installed SQLite today as I have done many times before on this computer. Started a new database file at ongame without luck. Any ideas?
*********************************
PT Version: 2.17.02a
Error Date: 08/04/2008 17:25
Database Error: 1
Error Text: Select error: SQLSTATE = S1000
no such table: HAND (1)
DataObject: d_gr_proom_hands_new_2
Syntax In Error: SELECT DISTINCT HAND.ID, DEALERPOSITION, RAKE, POT, HAND.TABLEID,
ENDEDATYEAR, ENDEDATMONTH, ENDEDATDAY, ENDEDATHOUR, ENDEDATMINUTE, ENDEDATSECOND,
NAME, 0 AS ROWID,
ENDEDATYEAR || CASE WHEN ENDEDATMONTH < 10 THEN '0' || ENDEDATMONTH ELSE ENDEDATMONTH || '' END ||
CASE WHEN ENDEDATDAY < 10 THEN '0' || ENDEDATDAY ELSE ENDEDATDAY || '' END ||
CASE WHEN ENDEDATHOUR < 10 THEN '0' || ENDEDATHOUR ELSE ENDEDATHOUR || '' END ||
CASE WHEN ENDEDATMINUTE < 10 THEN '0' || ENDEDATMINUTE ELSE ENDEDATMINUTE || '' END ||
CASE WHEN ENDEDATSECOND < 10 THEN '0' || ENDEDATSECOND ELSE ENDEDATSECOND || '' END AS TIMELINE
FROM HAND, POKERTABLE
WHERE HAND.TABLEID = POKERTABLE.ID
AND GAMETYPE = 0
AND MONEYTYPE = 1
AND ENDEDATYEAR || CASE WHEN ENDEDATMONTH < 10 THEN '0' || ENDEDATMONTH ELSE ENDEDATMONTH || '' END ||
CASE WHEN ENDEDATDAY < 10 THEN '0' || ENDEDATDAY ELSE ENDEDATDAY || '' END ||
CASE WHEN ENDEDATHOUR < 10 THEN '0' || ENDEDATHOUR ELSE ENDEDATHOUR || '' END ||
CASE WHEN ENDEDATMINUTE < 10 THEN '0' || ENDEDATMINUTE ELSE ENDEDATMINUTE || '' END ||
CASE WHEN ENDEDATSECOND < 10 THEN '0' || ENDEDATSECOND ELSE ENDEDATSECOND || '' END > ?
ORDER BY ENDEDATYEAR ASC, ENDEDATMONTH ASC, ENDEDATDAY ASC,
ENDEDATHOUR ASC, ENDEDATMINUTE ASC, ENDEDATSECOND ASC ;
*********************************
