Hi Mark, I think one way to do this would be:
use the 'SHOW Columns' SQL command ie, SHOW Columns from Table Then put the column names into an array using revDatabaseColumnNames Cycle through the array and use a SELECT command for each element ----- Andy Piddock My software never has bugs. It just develops random features. PointandSee is a FREE simple but full featured under cursor colour picker / finder. http://www.pointandsee.co.uk - made with LiveCode (v1.4.1 released 26/08/2011) -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/SQL-question-tp4655184p4655192.html Sent from the Revolution - User mailing list archive at Nabble.com. _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode