4DToday.com
4D Net Center Hosting
Home Directory Classifieds Reference Archives
Site Info
About 4DToday.com
Contact Us
Version française
Quote
Developers (721)
4D Developers (597)
Web Developers (339)
Tools Publishers (197)
Instructors (165)
Web Hosts (60)
Resellers (86)
Software Publishers (298)
Search Developers
Products (406)
Plug-Ins (121)
Components (62)
Code Libraries (9)
Books (7)
Tools (42)
Vertical Applications (147)
Search Products
User Groups
All User Groups (22)
Classified Ads (8)
Help Wanted (3)
Opportunities Wanted (5)
Hardware Wanted (0)
Hardware for Sale (0)
Software Wanted (0)
Software for Sale (0)
Other (0)
Resources
4D
4D, Inc.
4D Wiki
4D Partner Central
4D Knowledgebase
4D Doc Center
Example Applications
4D BugDisplayer
4D, Inc. Training
Podcasts on 4D
Message Lists
4D Bulletin Board
4D-Forum
4D Mailing Lists
4D Tech Google Group
iNUG Archives (Nabble)
iNUG Archives (Gmane)
Other
4D Code Exchange
4D Resources
Sviluppo4D.it (Italy)
Quote
Pointers will not improve the performance of your database. They'll improve the performance of the developer.
Dave Batton  
  Suggest a Quote  
Weekly Tech Tips Posted
The weekly tech tips have been posted to the 4D, Inc. Web site. Some of the subjects this week include "Whitespace matters in SQL" and  "Displaying Vertical Text on a Form." Sunday
JExternal, JbyJ 6.0.0
Ronri Kobo, Inc. has announced the release of JExternal, JbyJ 6.0.0. Tuesday
 Submit Future News    Archive 
Technical Tip
ARRAY TO SELECTION
On weekends we help you brush up on your 4D vocabulary.

ARRAY TO SELECTION (array; field{; array2; field2; ...; arrayN; fieldN})

Parameter Type Description
arrayArrayArray to copy to the selection
fieldFieldField to receive the array data


The ARRAY TO SELECTION command copies one or more arrays into a selection of records. All fields listed must belong to the same table.

If a selection exists at the time of the call, the elements of the array are put into the records, based on the order of the array and the order of the records. If there are more elements than records, new records are created. The records, whether new or existing, are automatically saved.

If the arrays are of different sizes, the first array is used to determine how many elements to copy. Any additional arrays are moved into the field that follows each array name.

This command does the reverse of SELECTION TO ARRAY. However, the ARRAY TO SELECTION command does not allow fields from different tables, including related tables, even when an automatic relation exists.

WARNING: Use ARRAY TO SELECTION with caution, because it overwrites information in existing records. If a record is locked by another process during the execution of ARRAY TO SELECTION, that record is not modified. Any locked records are put into the process set called LockedSet. After ARRAY TO SELECTION has executed, you can test the set LockedSet to see if any records were locked.

4D Server: The command is optimized for 4D Server. Arrays are sent by the client machine to the server, and the records are modified or created on the server machine. As such a request is handled synchronously, the client machine must wait for the operation to be completed successfully. In the multi-user or multi-process environment, any records that are locked will not be overwritten.
  Submit a Tip    Archive 
Spotlight
iPad
iPad Apple's iPad is being touted as "The best way to experience the web, email, photos,a nd video. Hands down." All of the built-in apps on iPad were designed from the ground up to take advantage of the large Multi-Touch screen. And they work in any orientation. So you can do things with these apps that you canŐt do on any other device.
  Suggest a Spotlight  
Survey Results
This weekend, we asked you...
Would you consider purchasing the new iPad?
Survey Results

Your vote: (no vote)
Total votes received: 65
  Suggest a Survey  
Events
There are no events scheduled for the upcoming week.
  Submit an Event