Difference between revisions of "Working with Multimedia Data"
Yvonnemilne (Talk | contribs) (→Retrieving Multimedia Data using Recital Navigational Data Commands) |
Yvonnemilne (Talk | contribs) |
||
| Line 18: | Line 18: | ||
The Recital object field containing the data to be written, is specified in the parameter <object field>, and must be a valid field in the currently selected workarea. | The Recital object field containing the data to be written, is specified in the parameter <object field>, and must be a valid field in the currently selected workarea. | ||
| + | |||
| + | <code lang="html"> | ||
| + | <% | ||
| + | open database southwind | ||
| + | use categories | ||
| + | scan | ||
| + | m_file = "" | ||
| + | //m_file = "__"+ltrim(str(recno()))+".jpg" | ||
| + | ? '<img src="'+objectwrite(m_file,picture,.t.)+'"><br>' | ||
| + | endscan | ||
| + | close databases | ||
| + | %> | ||
| + | <body bgcolor="#FFFFFF" text="#000000"> | ||
| + | </body> | ||
| + | </code> | ||
===Retrieving Multimedia Data using Recital SQL=== | ===Retrieving Multimedia Data using Recital SQL=== | ||
===Summary=== | ===Summary=== | ||
Revision as of 11:53, 17 March 2010
Contents
Working with Multimedia Data
OBJECTREAD(<filename>,<object field>)
The OBJECTREAD() function reads an external binary file into a Recital Object field. It returns .T. if the operation was successful, and .F. otherwise.
The file to read in is specified in <filename>, and can be any valid Recital/4GL expression that returns a valid file name. The first three characters of the file extension are stored in the Object field as the Objects type, as returned by the OBJECTTYPE() function.
The field into which the file is placed is specified in <object field>, and must be a Recital Object field in the currently selected workarea.
Inserting Multimedia Data using Recital SQL
OBJECTWRITE(<filename>,<object field>[,<expL>])
The OBJECTWRITE() function writes an external binary file from a Recital Object field. The OBJECTWRITE() function returns .T. if the external binary file was created successfully, and .F. otherwise.
The name of the file to create can be specified in the parameter <filename>. This can be any valid Recital/4GL expression that returns a valid filename. The filename can also be an empty string, providing that the logical expression <expL> is true (.T.). In this case, a unique temporary file name will be generated and the Object written to this file, with the file name being returned from OBJECTWRITE().
The Recital object field containing the data to be written, is specified in the parameter <object field>, and must be a valid field in the currently selected workarea.
<% open database southwind use categories scan m_file = "" //m_file = "__"+ltrim(str(recno()))+".jpg" ? '<img src="'+objectwrite(m_file,picture,.t.)+'"><br>' endscan close databases %> <body bgcolor="#FFFFFF" text="#000000"> </body>
