Naive questions about contacting databases

[Rob Cozens]

>>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)