Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- RaSQL/B 6.1a for Clipper - <b>n_xappend()</b> http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
N_XAPPEND()
Append into current table from specified table

Syntax
N_XAPPEND(<cSource>|<nSource> [,<lPositional>])

RDD
Use APPEND FROM or __DBAPP()

Arguments
<Source> is the source table. It  may be specified by its alias (see 
N_XALIAS()), or by the area number it is opened in.

<lPositional> specifies the method used to move fields from source to 
destination.

If <lPositional> is .F. or omitted then RaSQL moves fields from the source 
to destination fields of the same name.  If a field name in the source table 
corresponds to none of the names in the target DBF,  RaSQL will not move the 
field. If a field exists in the target but not in the source, RaSQL will 
leave the target field blank.

If <lPositional> is .T., then RaSQL moves fields from source to destination 
in field order, regardless of the name. Undesirable results will occur if 
the files have incompatible structures.

Returns
True if successful. False on failure. Use N_XERROR() to get an error code.

Remarks
Both tables must currently be open.   Records from the  source table will be 
appended to the destination table.  If N_XFILTER is in effect in the source 
area, only records matching the filter will be appended.

Example
* Append into TEMP1.DAT from TEMP2.DAT
N_XSELECT(1)
N_XUSE('temp1.dat', ...)
N_XSELECT(2)
N_XUSE('temp2.dat', ...)
N_XAPPEND(1)
* Alternatively: N_XAPPEND('temp1')


See Also: N_XSELECT()

Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson