Gossamer Forum
Home : Products : DBMan SQL : Discussion :

DBMan SQL and relational tables

Quote Reply
DBMan SQL and relational tables
The DBMan SQL Overview at http://www.gossamer-threads.com/scripts/dbman-sql/ states "only advantadge right now to the SQL version is if you need a large database".

I don't understand this. Suppose I need a database that is not flat, ie: with relational tables ... can't DBMan SQL handle it?


Quote Reply
Re: DBMan SQL and relational tables In reply to
Yes, with a bit of hacking.

Out of box, DBMAN SQL only supports one table of data, and it is not really a Relational Database application. LINKS SQL, on the other hand, is.

Regards,

Eliot Lee Wink
http://anthrotech.com/
Quote Reply
Re: [Heckler] DBMan SQL and relational tables In reply to
Where I can find more information about this?

Ive read the help, and the only thing found was about

"GT::SQL supports the concept of foreign keys "

I understand this concept, but where I put this tipe of codes?

"

From there, performing a select is pretty simple:

# select all the people from a real cool company my $sth = $emp_cmp->select ( { COMPANY.NAME => "Gossamer-Threads" } )"and the forms for inclusion etcThanks
Quote Reply
Re: [Heckler] DBMan SQL and relational tables In reply to
Where I can find more docs?

And the forms, how it should be?

Thanks