SQLite. Getting a formatted row

[btiffin]

Hello campers,

Anyone here experienced with SQLite? After a sqlite3_exec there is a callback. Once for each row, with a field count and arrays of names and values. Is there an easy way to get a full row, no headers, laid out in quasi "schema" form? Something suitable for insertion into an ISAM file?

id integer primary key, first varchar(20), second date

code:

1*twenty chars*******2008-04-01              2********************2008-10-01

Kinda deal (where the * characters are just me showing the first field at 20, even though the varchar may be 5 or 40 in the record).

Or do I have to build this animal column by column? I'd prefer the engine does this from the schema as it knows all the sizes but I'm not totally up on the SQLite API yet. It looks like no, no easy way, but I thought I'd ask.

Cheers