Snotty error message

Posted by jmls on 18-Jun-2011 13:32

Had to have a laugh when I got this error message today :

Invalid use of deprecated word-indexed array. (14914)

No array should ever be indexed.   Back in early versions of the ABL we temporarily allowd character arrays to be word-indexed,

but that was a stop-gap before we had VIEW-AS EDITOR where you could get a multi-line set of text to appear.  This is no longer supported.

*slap* you take that array out, you *naughty* boy.
Is it easy for SQL to get the 3rd (for example) line in a text field separated with newlines ?
And when the hell did word-indexed arrays not get supported ?
I need a word-indexed field so I can search on addresses. Common industry techniques (here in the UK at least, when dealing with banks) is that there is 5 address lines and a postcode. I can't have 5 separate fields (can't word-index) so either a single field with newlines, or an array of 5.
thoughts ? Comments ?

All Replies

Posted by Tim Kuehn on 20-Jun-2011 08:32

or maintain 5 separate fields, and have some logic to map that into a single CHR(10) delimited field when any of the 5 are update (I know, it's a mess, but it'll solve your problem.)

This thread is closed