1. wxEDB

Is there any chance there may be a way of printing the basic structure etc of a
database from EDB in the future?

Alex

new topic     » topic index » view message » categorize

2. Re: wxEDB

Alex Chamberlain wrote:
> 
> Is there any chance there may be a way of printing the basic structure etc of
> a database from EDB in the future?

Maybe.  The printing capabilities of wxEuphoria are pretty immature, 
currently.  It should be fairly easy to give you the schema of a database,
however.  Since there aren't any formal foreign key relationships in 
EuSQL, it's simply a printout of the tables with field names, data types
and indices.

Could you be a little more specific in what you'd like to see?

Matt Lewis

new topic     » goto parent     » topic index » view message » categorize

3. Re: wxEDB

Simply, I would like to print out the field names basically. Maybe also the
field types? Like the schemeas in EuSQL's documentation.

Alex

new topic     » goto parent     » topic index » view message » categorize

4. Re: wxEDB

Alex Chamberlain wrote:
> 
> Simply, I would like to print out the field names basically. Maybe also the
> field types? Like the schemeas in EuSQL's documentation.
> 

I suspect that this would be implemented to output to a text file (and you
can do whatever you want with it later).  It's a good idea...

Matt Lewis

new topic     » goto parent     » topic index » view message » categorize

5. Re: wxEDB

Alex Chamberlain wrote:
> 
> Simply, I would like to print out the field names basically. Maybe also the
> field types? Like the schemeas in EuSQL's documentation.
> 

Is this the sort of thing you're looking for?


Table: ARCHIVE
Field         Data Type   Index      
-----------   ---------   ---------  
ID            Integer                
PLATFORM      Integer                
HREF          Text                   
TITLE         Text                   
SIZE          Integer                
NAME          Integer     PROG_AUTH  
DATE          Sequence               
YEAR          Integer                
MONTH         Integer                
DAY           Integer                
MONEY         Integer                
DESCRIPTION   Text                   
UPDATED       Integer                
STAMPED       Integer                
CATEGORY      Integer     PROG_CAT   
EMAIL         Object                 

Table: AUTHORS
Field         Data Type   Index      
-----------   ---------   ---------  
ID            Integer                
NAME          Text                   

Table: CATEGORY
Field         Data Type   Index      
-----------   ---------   ---------  
ID            Integer                
NAME          Text                   

Table: MONTH
Field         Data Type   Index      
-----------   ---------   ---------  
ID            Integer                
MONTH         Text                   

Table: PLATFORM
Field         Data Type   Index      
-----------   ---------   ---------  
ID            Integer                
PLATFORM      Text

new topic     » goto parent     » topic index » view message » categorize

6. Re: wxEDB

I think that will be great - others may want slightly different - I don't know?

Thanks,
 Alex

new topic     » goto parent     » topic index » view message » categorize

Search



Quick Links

User menu

Not signed in.

Misc Menu