Recent content by protagonist

I'm using access 2000, and I have,for instance, the following simple query: PARAMETERS name TEXT(30); ALTER TABLE Table1 ADD COLUMN game TEXT(30); Now, without the parameter bit, the alter table section works fine. I add in the parameter (which does nothing, you'll notice) and it won't work...

Ah, that would explain it! thanks.

Now this is odd. I'm running mysql Ver 12.22 Distrib 4.0.18, for apple-darwin6.8 (powerpc) right? And I can't get any subquery to work. I even tried SELECT (SELECT 1); and I still get ERROR 1064: You have an error in your SQL syntax near 'SELECT 1)' at line 1 help?

That gives the exact same result, I'm afraid...

Now, in my database, I'm trying to include foreign keys. An example: CREATE TABLE Person(PersonID INTEGER PRIMARY KEY AUTO_INCREMENT, FOREIGN KEY(Owner_OwnerID) REFERENCES Owner(OwnerID) ON DELETE CASCADE, Name VARCHAR(20), Job VARCHAR(20), DOB DATE, StartEmploymentDate DATE,EndEmploymentDate...

Hello, I have an Access 2000 database for a library, with the entries you would expect: Author, title etc. now, My question is: I want to write a query where it will give the details for a specified author, eg, we want a list of all the books by Douglas Adams. Now, I know theres a...