FYI - NULLs in data to sort

Mark Schonewille 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.

--
Best regards,

Mark Schonewille

Economy-x-Talk Consulting and Software Engineering
http://economy-x-talk.com

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 mailing list