On Monday, May 16, 2011 08:03:49 am Ricardo Aráoz wrote: > 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
Yes I thought of that. But it does depend on a value being in the field else text is the data type. Also the dataset size could be large and being recursive could cause issues with memory. A better solution but not complete for the edge cases. Adrian and I have been discussing the issue off line. We decided the best way was for the developer to supply either hints (select fieldname '[date]', ...) or change dDataSet to accept a DataSource (the structure of the dataset) as a parameter. Adrian may provide some code to deal with the issue in the near future. BTW a big thanks to everyone that tried to help! 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]
