Welcome to the SQLitening support forums!
Started by Bern Ertl, February 19, 2009, 04:05:16 pm
'slSel "SELECT * FROM cat_y1_s1 where id=(SELECT MAX(id) FROM cat_y1_s1)" 'works'slGetRow'? slF(1)'the above worksslSel "SELECT MAX(id) as Max_id FROM cat_y1_s1"? "Max_id=" & Max_id 'printing out 0 ???'the above does not irrespective of whether Max_id is a long,quad or string
SELECT MAX(id) as Max_id FROM cat_y1_s1slGetRow? "Max_id=" & slFN("Max_id")