On 13/05/2011 11:53 a.m., John Fabiani wrote: > 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.
select top 1 a, b, c ,d, ..., z where a is not null, b is not null, .... , z is not null If there is at least one record where no field is null this should work. > 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] _______________________________________________ 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]
