At 07:36 2013-07-12, "MB Software Solutions General Account" <[email protected]> wrote:
On Thu, July 11, 2013 6:32 pm, Gene Wirchenko wrote: > At 10:29 2013-07-11, "MB Software Solutions, > LLC" <[email protected]> wrote:
[snip]
>> How would you handle it?
> Create a new table for the data in the format I want, and > grovel through the unconverted table with a loop.
That's what I've got in place now...a SCAN loop with conversion, or in an alternative version, I do a REPLACE RealDate with ConvertDate(TextDate) ALL in curTemp where ConvertDate is my UDF. I was just trying to squeeze better performance out of this.
That is not what I meant. I meant a separate new table for the converted data.
I have to say that I would generally not be too concerned with the speed. My concern would be with the conversion working right and being easily modified if the rules changed.
Sincerely, Gene Wirchenko _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
