KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
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
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

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