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 strongm 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: jennypsion
- Order by date
-
What's wrong with my trigger
I have found the error, but now i get a new error. closed is a field in table auction, so i don't understand why it can't find it. mysql> CREATE TRIGGER updateAuction -> BEFORE UPDATE ON auction -> FOR EACH ROW -> SET closed = 'true' WHERE current_date() > deadline; ERROR 1193...- jennypsion
- Post #2
- Forum: MySQL
-
What's wrong with my trigger
Hello, I have just written a trigger, which changes a field in my table after a certain date was reached. This is my trigger, including the error message: mysql> create trigger closeAuction before insert on auction for each row begin update auction set closed = 'true' where current_date() >...- jennypsion
- Thread
- Replies: 4
- Forum: MySQL
-
case sensitivity
Hello, I am designing a database but I have a problem because Access doesn~t seem to allow case sensitivity. I have a field containing the component names and a field containing the connector names. The components have connectors named a and A, but it doesn~t allow me to enter a and A because...- jennypsion
- Thread
- Replies: 4
- Forum: Microsoft: Access Tables and Relationships
