323
PREVIOUS_ITEM built-in
Description
Navigates to the navigable item with the next lower sequence number than the current item.  If there is no
such item, PREVIOUS_ITEM navigates to the navigable item with the highest sequence number.  If
there is no such item, PREVIOUS_ITEM navigates to the current item.
The function of PREVIOUS_ITEM from the first navigable item in the block depends on the setting of
the Navigation Style block property.  The valid settings for Navigation Style include:
Same Record (Default):  A Previous Item operation from a block’s first item moves the input focus to
the last navigable item in the block, in that same record.
Change Record A Previous Item operation from a block’s first item moves the input focus to the last
navigable item in the block, in the previous record.
Change Block:  A Previous Item operation from a block’s first item moves the input focus to the last
navigable item in the current record of the previous block.
Syntax
PROCEDURE PREVIOUS_ITEM;
Built-in Type   restricted procedure
Enter Query Mode  yes
Parameters
none
PREVIOUS_ITEM examples
/*
** Built-in:  PREVIOUS_ITEM
** Example:   See PREVIOUS_BLOCK
*/
Pdf extract pages - copy, paste, cut PDF pages in C#.net, ASP.NET, MVC, Ajax, WinForms, WPF
Easy to Use C# Code to Extract PDF Pages, Copy Pages from One PDF File and Paste into Others
cut pages from pdf reader; export one page of pdf preview
Pdf extract pages - VB.NET PDF Page Extract Library: copy, paste, cut PDF pages in vb.net, ASP.NET, MVC, Ajax, WinForms, WPF
Detailed VB.NET Guide for Extracting Pages from Microsoft PDF Doc
convert few pages of pdf to word; extract pdf pages acrobat
324
PREVIOUS_MENU built-in
Description
PREVIOUS_MENU navigates to the previously active item in the previous menu.
Syntax
PROCEDURE PREVIOUS_MENU;
Built-in Type   restricted procedure
Parameters
none
PREVIOUS_MENU restrictions
PREVIOUS_MENU applies only in full-screen and bar menus.
C# PDF Text Extract Library: extract text content from PDF file in
inputFilePath); PDFTextMgr textMgr = PDFTextHandler.ExportPDFTextManager(doc); // Extract text content C# example code for text extraction from all PDF pages.
add and remove pages from pdf file online; extract page from pdf document
VB.NET PDF Text Extract Library: extract text content from PDF
PDF ›› VB.NET PDF: Extract PDF Text. VB.NET PDF - Extract Text from PDF Using VB. How to Extract Text from PDF with VB.NET Sample Codes in .NET Application.
delete pages of pdf preview; cut and paste pdf pages
325
PREVIOUS_MENU_ITEM built-in
Description
PREVIOUS_MENU_ITEM navigates to the previous menu item in the current menu.
Syntax
PROCEDURE PREVIOUS_MENU_ITEM;
Built-in Type   restricted procedure
Parameters
none
PREVIOUS_MENU_ITEM restrictions
PREVIOUS_MENU_ITEM applies only in full-screen menus.
C# PDF Image Extract Library: Select, copy, paste PDF images in C#
Image: Extract Image from PDF. |. Home ›› XDoc.PDF ›› C# PDF: Extract PDF Image. How to C#: Extract Image from PDF Document.
export pages from pdf preview; cut pages from pdf preview
VB.NET PDF Image Extract Library: Select, copy, paste PDF images
Image: Extract Image from PDF. |. Home ›› XDoc.PDF ›› VB.NET PDF: Extract PDF Image. VB.NET PDF - Extract Image from PDF Document in VB.NET.
export pages from pdf acrobat; delete page from pdf reader
326
PREVIOUS_RECORD built-in
Description
Navigates to the first enabled and navigable item in the record with the next lower sequence number than
the current record.
Syntax
PROCEDURE PREVIOUS_RECORD;
Built-in Type   restricted procedure
Enter Query Mode  no
Parameters
none
PREVIOUS_RECORD examples
/*
** Built-in:  PREVIOUS_RECORD
** Example:   If the current item is the first item in the
**            block, then skip back to the previous record
**            instead of the default of going to the last
**            item in the same block
** trigger:   Key-Previous-Item
*/
DECLARE
cur_itm VARCHAR2(80) := :System.Cursor_Item;
cur_blk VARCHAR2(80) := :System.Cursor_Block;
frs_itm VARCHAR2(80);
BEGIN
frs_itm :=
cur_blk||’.’||Get_Block_Property(cur_blk,FIRST_ITEM);
IF cur_itm = frs_itm THEN
Previous_Record;
ELSE
Previous_Item;
END IF;
END;
C# PDF Page Insert Library: insert pages into PDF file in C#.net
Page: Insert PDF Pages. |. Home ›› XDoc.PDF ›› C# PDF: Insert PDF Page. Add and Insert Multiple PDF Pages to PDF Document Using C#.
delete page from pdf file; copy pages from pdf to new pdf
VB.NET PDF Page Delete Library: remove PDF pages in vb.net, ASP.
Page: Delete Existing PDF Pages. |. Home ›› XDoc.PDF ›› VB.NET PDF: Delete PDF Page. How to VB.NET: Delete Consecutive Pages from PDF.
extract pages from pdf reader; delete page from pdf acrobat
327
PRINT built-in
Description
Prints the current window to a file or to the printer.
Syntax
PROCEDURE PRINT;
Built-in Type   unrestricted procedure
Enter Query Mode  yes
Parameters
none
PRINT examples
/*
** Built-in:  PRINT
** Example:   Print the current window.
*/
BEGIN
Print;
END;
C# PDF Page Delete Library: remove PDF pages in C#.net, ASP.NET
Page: Delete Existing PDF Pages. Provide C# Users with Mature .NET PDF Document Manipulating Library for Deleting PDF Pages in C#.
deleting pages from pdf; delete page from pdf online
VB.NET PDF Page Insert Library: insert pages into PDF file in vb.
Page: Insert PDF Pages. |. Home ›› XDoc.PDF ›› VB.NET PDF: Insert PDF Page. Add and Insert Multiple PDF Pages to PDF Document Using VB.
delete page from pdf document; delete pages from pdf acrobat reader
328
PTR_TO_VAR built-in
Description
First, creates an OLE variant of type VT_PTR that contains the supplied address.  Then, passes that
variant and type through the function VARPTR_TO_VAR.
Syntax
FUNCTION PTR_TO_VAR
(address PLS_INTEGER, vtype VT_TYPE)
RETURN newvar OLEVAR;
Built-in Type  unrestricted function
Returns  the created and transformed OLE variant.
Parameters
address
A variable whose value is an address.
vtype
The type to be given to the final version of the OLE
variant (after its processing by VARPTR_TO_VAR).
Usage Notes
In most applications, there is no need to use this function.  If the function is used, care must be taken to
ensure that the correct address value is placed in the new variant.
329
QUERY_PARAMETER built-in
Description
Displays the Query Parameter dialog showing the current values of the specified substitution parameters.
End users can set the value of any parameter you include in the list.
The Query Parameter dialog is modal, and control does not return to the calling trigger or procedure until
the end user either accepts or cancels the dialog. This means that any PL/SQL statements that follow the
call to QUERY_PARAMETER are not executed until the Query Parameter dialog is dismissed.
Syntax
PROCEDURE QUERY_PARAMETER
(
parameter_string  
VARCHAR2);
Built-in Type   unrestricted procedure
Parameters
parameter_string
Specifies a string of substitution parameters for a menu item.  The syntax
for specifying the parameter_string parameter requires the ampersand
&parm_name.  Substitution parameters are referenced in PL/SQL code
with the colon syntax ":param_name" used for all bind variables).
QUERY_PARAMETER examples
/*   
** Built-in:  QUERY_PARAMETER
** Example:   Prompt for several menu parameters
**            programmatically, validating their contents.
*/
PROCEDURE Update_Warehouse IS
validation_Err BOOLEAN;
BEGIN
WHILE TRUE LOOP
Query_Parameter(’&p1 &q2 &z6’);
/*
** If the user did not Cancel the box the Menu_Success
** function will return boolean TRUE.
*/
IF Menu_Success THEN
IF TO_NUMBER( :q2 ) NOT BETWEEN 100 AND 5000 THEN
Message(’Qty must be in the range 100..5000’);
Bell;
Validation_Err := TRUE;
END IF;
/*
** Start a sub-block so we can catch a Value_Error
** exception in a local handler
*/
BEGIN
IF TO_DATE( :z6 ) < SYSDATE THEN
Message(’Target Date must name a day in the future.’);
Bell;
Validation_Err := TRUE;
END IF;
EXCEPTION
330
WHEN VALUE_ERROR THEN
Message(’Target Date must be of the form DD-MON-YY’);
Bell;
Validation_Err := TRUE;
END;
/*
** If we get here, all parameters were valid so do the
** Update Statement.
*/
IF NOT Validation_Err THEN
UPDATE WAREHOUSE
SET QTY_TO_ORDER = QTY_TO_ORDER*0.18
WHERE TARGET_DATE = TO_DATE(:z6)
AND QTY_ON_HAND > TO_NUMBER(:q2)
AND COST_CODE LIKE :p1||’%’;
END IF;
ELSE
/*
** If Menu_Success is boolean false, then return back
** from the procedure since user cancelled the dialog
*/
RETURN;
END IF;
END LOOP;
END;
331
READ_IMAGE_FILE built-in
Description
Reads an image of the given type from the given file and displays it in the Form Builder image item.
Syntax
PROCEDURE READ_IMAGE_FILE
(
file_name  
VARCHAR2
,
   file_type  
VARCHAR2
,
   item_id    
ITEM);   
PROCEDURE READ_IMAGE_FILE
(
file_name  
VARCHAR2
,
   file_type  
VARCHAR2
,
   item_name  
VARCHAR2);
Built-in Type  unrestricted procedure
Enter Query Mode  yes
Parameters
file_name
Valid file name.  The file name designation can include a full path
statement appropriate to your operating system.
file_type
The valid image file type:  BMP, CALS, GIF, JFIF, JPG, PICT, RAS,
TIFF, or TPIC.  (Note:  File type is optional, as Form Builder will attempt
to deduce it from the source image file.  To optimize performance,
however, you should specify the file type.)
item_id
The unique ID Form Builder assigns to the image item when it creates it.
Use the FIND_ITEM built-in to return the ID to an appropriately typed
variable.  Datatype is ITEM.
item_name
The name you gave the image item when you created it.  Datatype is
VARCHAR2.
Usage Notes
Form Builder searches for the image file along the same default path as it searches for an .FMX file.  For
more information on the specific search path for your platform, refer to the Form Builder documentation
for your operating system.
READ_IMAGE_FILE examples
/* Read an image from the filesystem into an image item on the
** form. In this example, the scanned picture identification
** for each employee is NOT saved to the database, but is
** stored on the filesystem.  An employee’s  photo is a TIFF
** image stored in a file named <Userid>.TIF Each employee’s
** Userid is unique.
** trigger: Post-Query
*/
DECLARE
tiff_image_dir VARCHAR2(80) := ’/usr/staff/photos/’;
photo_filename VARCHAR2(80);
332
BEGIN
/*
** Set the message level high so we can gracefully handle
** an error reading the file if it occurs
*/
:System.Message_Level := ’25’;
/*
** After fetching an employee record, take the employee’s
** Userid and concatenate the ’.TIF’ extension to derive
** the filename from which to load the TIFF image. The EMP
** record has a non-database image item named ’EMP_PHOTO’
** into which we read the image.
*/
photo_filename := tiff_image_dir||LOWER(:emp.userid)||’.tif’;
/*
** For example ’photo_filename’ might look like:
**
**     /usr/staff/photos/jgetty.tif
**                       ------
**
** Now, read in the appropriate image.
*/
READ_IMAGE_FILE(photo_filename, ’TIFF’, ’emp.emp_photo’);
IF NOT FORM_SUCCESS THEN
MESSAGE(’This employee does not have a photo on file.’);
END IF;
:SYSTEM.MESSAGE_LEVEL := ’0’;
END;
Documents you may be interested
Documents you may be interested