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.
Related resources:
4D Pack v11 SQL Documentation
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