On Friday, May 13, 2011 7:26:35 am John Fabiani wrote: > > > > John,
> > I don't see how it can be fixed. If the routine requires that a record be > used to determine datatype then we are stuck with the results. Even if you > had the routine check 100 records they all could be null and the 101 record > contain a date. I didn't find any information_schema function for sqlite. > And the suggestion on PRAGMA Paul said would not work. I had another thought after my previous post. Create a dummy record that has all the fields filled with the appropriate data types. Include it in the initial dataset to 'seed' the table creation process. Delete it from the dataset once the table is created. > > Johnf > -- Adrian Klaver adrian.kla...@gmail.com _______________________________________________ Post Messages to: Dabo-users@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/201105130744.04038.adrian.kla...@gmail.com