KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Changes to ARRAY TO SELECTION
PRODUCT: 4D | VERSION: 11 | PLATFORM: Mac & Win
Published On: October 1, 2008

This command now returns an error if the arrays are not the same size. The error code is 74 ("The size of arrays do not match").

The command does not modify the "One" record in any way. In 2004 if you passed fields from both the One table and the Many table to ARRAY TO SELECTION the data in the One field was not modified (this is normal) but the One record was unloaded (this is not normal). With 4D v11 SQL, the One record remains completely unmodified. Data changes are not saved, and the “loaded” status is not touched.