Tech Tip: Where is my 4D Pack command in 4D v11 SQL?
PRODUCT: 4D Pack | VERSION: 11 | PLATFORM: Mac & Win
Published On: March 5, 2008
4D Pack provides developers with additional functionality outside of the built-in 4D environment.
As 4D is an evolving product, certain commands in 4D Pack have been deprecated and removed from the 4D v11 SQL version of 4D Pack. The following are commands that have been removed/deprecated as well as recommended replacements.
| Command(s) | Replacement or Reason Removed/Deprecated |
| AP Save BMP 8 bits | Obsolete command, 8 bit pictures are deprecated. |
| AP Save GIF | Use CONVERT PICTURE and WRITE PICTURE FILE. |
| AP Get picture type | Will not be supported in the future. |
| AP GET PARAM/ AP SET PARAM | Most of the parameters are now obsolete and can be replaced by SET DATABASE PARAMETER. |
| AP AVAILABLE MEMORY | Values are now in Kb and this command no longer returns available memory. |
| AP FCLOSE | Can be replaced by SET CHANNEL. |
| AP fopen | Can be replaced by SET CHANNEL. |
| AP FPRINT | Can be replaced by SEND PACKET. |
| AP fread | Can be replaced by RECEIVE PACKET. |
| AP CLOSE HELP | This is not compatible VISTA and works only under Windows. |
| AP HELP INDEX | This is not compatible VISTA and works only under Windows. |
| AP HELP ON HELP | This is not compatible VISTA and works only under Windows. |
| AP HELP ON KEY | This is not compatible VISTA and works only under Windows. |
| AP PICT DRAGGER | Uses drag and drop 4D commands. |
| AP PICT UPDATER | Use READ PICTURE FILE. |
| AP Read Picture BLOB | Use Blob to picture. |
| AP Rect dragger | Use system variables MouseDown, MouseX and MouseY. |
| AP SET PICT MODE | Use SET FORMAT. |
| AP Select document | Use Select document. |
| AP Set palette | Use SET RGB COLORS. |
| AP ShellExecute, AP Sublaunch | Use LAUNCH EXTERNAL PROCESS. |
| AP PrintDefault | Use AP Blob to print setting and AP Print settings to Blob. |
| AP Text to PrintRec | Use AP Blob to print setting and AP Print settings to Blob. |
| AP PrintRec to text | Use AP Blob to print setting and AP Print settings to Blob. |
| AP PrValidate | Use AP Blob to print setting and AP Print settings to Blob. |
| AP Toolbar installed | Use the expression (Tool bar height = 0). If this expression evaluates to True, the tool bar is not installed. |
| AP SET WEB FILTERS | Use SET DATABASE PARAMETER with the Character set selector. |
| AP Add table and fields | Use CREATE TABLE SQL function. |
| AP Create relation | No scheduled replacement command right now; possibility of using SQL statements to perform a JOIN. |
Related resources:
4D Pack v11 SQL Documentation