Naive questions about contacting databases
Rob Cozens
rcozens at pon.net
Mon Mar 8 11:46:27 EST 2004
>>1. From RR how can I access a database and display the
>>contents of its tables/fields in RR ?
If your needs require a relational database supporting SQL syntax,
then please trash this message; however, if you don't need "Q", SDB
will do.
SDB is an open-source, native-Transcript, hierarchical client/server
available at <http://www.oenolog.net/ftp/serendipity_downloader.htm>.
In the first RAD version, which I am fine tuning for release later
this week, the steps involved are:
A. Create a front-end card with title fields with sharedText = true
and data fields with sharedText = false. (The RAD version will ship
with a stack of front-end templates you an use, customize, and/or add
to.)
B. Create the database
C. Run SDB Tools' Record Type From Card menuItem, which creates the
data dictionary record type definition & installs SDB handlers in the
front-end stack.
>
>>
>>2. From RR how can I access a remote data base and . . . ?
>
A. Set up TCP/IP communications
B. Build & install an SDB Server standalone
C. Change the communications mode of the front-end you created above
from "direct connection" [single user] to "TCP/IP" and enter the
server's IP address & port.
>>
>>3. How can I export processed data in a more useful format
>>than a tab-delimited text document?
>>
A. Use SDB Tools or SDB Utilities to open the data base directly.
B. Run the Export Record menuItem in the db's Edit menu
C. Select the record type & key range, type the numeric value of the
delimiter of your choice, and send mouseUp to the "Proceed" [Thumbs
Up"] button. [Your format can then be described in the Import Record
dialog; so files exported from one database can be imported into
another.]
--
Rob Cozens
CCW, Serendipity Software Company
http://www.oenolog.net/who.htm
"And I, which was two fooles, do so grow three;
Who are a little wise, the best fooles bee."
from "The Triple Foole" by John Donne (1572-1631)
More information about the use-livecode
mailing list