FYI - NULLs in data to sort
m.schonewille at economy-x-talk.com
Mon Aug 31 18:22:44 EDT 2009
Being unable to sort unicode data would indeed be a Very Bad Thing.
Economy-x-Talk Consulting and Software Engineering
Download Snapper Screen Recorder at http://snapper.economy-x-talk.com
On 1 sep 2009, at 00:11, Paul Looney wrote:
> General information,
> Over the past several months we have noticed that version 3.5 of Rev
> is much more sensitive to data that contains NULL characters.
> Several programs that worked well previously, with the same data,
> broke when using Rev 3.5 - or a standalone made from it.
> The problem comes when the data is sorted; the sorting drops
> records. Adding the following line, before the sort, fixes the
> problem for us:
> replace NULL with "" in theData --"theData" is whatever variable
> contains the data to be manipulated.
> We had minor problems with NULLs previously, but 3.5 will drop up to
> 80% of our data.
> One way NULLs can get into a database is if Unicode text is copied
> from another document.
> Hope this saves you some time.
> Paul Looney
More information about the Use-livecode