Tuesday, December 10, 2013
Tip of the Day: Using Enhanced ATTACH Command
Product.: R:BASE eXtreme 9.5 (32/64)
Build...: 9.5.3.21205 or higher www.rupdates.com
Keywords: ATTACH, dBASE Files
Section.: Enhanced Commands
The ATTACH command is used to attach a dBASE file to currently
connected R:BASE database.
Similar to the enhanced SATTACH command, the ATTACH command has
also been enhanced to support an ALIAS names for the TABLE and
COLUMNs, and to specify if the table is TEMPORARY.
-- Example 01:
ATTACH TEMPORARY filename.dbf +
AS TableAlias +
ALIAS Column1, Column2, Column3, Column4, Column5
TEMPORARY allows you to create a temporary table with the ATTACH
command. The temporary tables will disappear when the database
is disconnected.
AS TableAlias specifies an alias, or temporary name, for the dBASE
table. A table alias is sometimes required when attaching a dBASE
file that do not follow the same table name restrictions as R:BASE.
ALIAS AliasList (Column1 ... ) to specify alias names for columns.
Once the dBASE file is ATTACHed successfully, you may use the
PROJECT ... command or "Copy Table ..." option using the R:BASE
Database Explorer to create a native R:BASE table.
Use the DETACH ... command or "Delete Table ..." option using the
R:BASE Database Explorer to remove a dBASE file table and its
associated dBASE index files from the open R:BASE database.
For complete details and examples:
HELP ATTACH
HELP DETACH
HELP PROJECT
Enjoy the showcase and pride of our eXpanded R:Dream Team!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
30+ years of continuous innovation!
15 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================