Where can I find a list of the datatypes and syntax for Access?
Specifically, I'm looking for ways to establish foreign keys and decimal
places in a CREATE TABLE statement.
To create an integer primary key,
$db->Sql("CREATE TABLE blah (Blahuga INTEGER PRIMARY KEY);");
works, but how do I specify the number of decimal places?
INTEGER(2), DECIMAL(2), NUMBER(2) (for 2 decimal places) all didn't work.
As for foreign keys, I haven't yet tried this, but would standard SQL
"REFERENCES" statements work in Access?
Assuming the above went through successfully, could I then
$db->Sql("CREATE TABLE blahMore (BlahugaAlso INTEGER REFERENCES
blah.Blahuga);");
? Or is there some special Access stuff I need to do instead?
Pointing me to a help file/web page where I can find this stuff would
actually be more appreciated than a direct answer, as I'll probably have
more questions, and I don't like to bug the board if I don't have to.
Dan
---
You are currently subscribed to perl-win32-users as: [archive@jab.org]
To unsubscribe, forward this message to
[EMAIL PROTECTED]
For non-automated Mailing List support, send email to
[EMAIL PROTECTED]
