Naive questions about contacting databases
rcozens at pon.net
Mon Mar 8 10:46:27 CST 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
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
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
>>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
CCW, Serendipity Software Company
"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