Drat, I had a function that did this very thing, but I replaced it with the dbschema_getTable() function in sqlYoga which returns everything you would want to know about a table schema. I was not aware that the CREATE TABLE command worked with sqLite.
Bob On Dec 22, 2011, at 9:34 AM, Pete wrote: > Yes, I know about that but the project I'm working on requires me to parse > out all the individual elements of the CREATE statement, not actually > create the table. The PRAGMA commands provide some information about the > table but you have to parse the CREATE command to get the rest. _______________________________________________ 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