On Friday, May 13, 2011 07:44:03 am Adrian Klaver wrote: > 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
On the surface that sounds good but I could not figure out how to do it in a dynamic way. I ran into the same problem Dabo has. How can I determine the datafields and provide the fake data for the first record. I also considered creating a DataSource for the dataset. But the Dabo routine does not look at the DataSource description. I could of course change the Dabo routine to look for a DataSource description and use it if it was available. But to be honest I consider my solution a hack! Johnf _______________________________________________ Post Messages to: [email protected] 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/[email protected]
