Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: protagonist
- Order by date
-
Problem using parameters and Alter Table together?
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...- protagonist
- Thread
- Replies: 0
- Forum: Microsoft: Access Queries and JET SQL
-
-
Subquery problem
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?- protagonist
- Thread
- Replies: 2
- Forum: MySQL
-
Foreign Key Problem
That gives the exact same result, I'm afraid...- protagonist
- Post #3
- Forum: MySQL
-
Foreign Key Problem
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...- protagonist
- Thread
- Replies: 3
- Forum: MySQL
-
User defined SQL searches...?
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...- protagonist
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
