can anyone help me create a trigger to limit the number of records in a table? Some told me that is the only way to limit the number of records in a table, but I do not know what is that (trigger) and how to use it.
Thnx. :-) I hope that tomorow I'll still be alive and kicking.
Then what's the use of MAX_ROWS ?
Anyway, i'm giving acces to a certain customer to a certain table and I want to limitate the numer of rows he can insert in that table. Is it possible in MySQL? I hope that tomorow I'll still be alive and kicking.
Does anyone know how to state a maximum number of rows in a table? I tried to create the table with MAX_ROWS=5 but didn't work. I hope that tomorow I'll still be alive and kicking.
I give access for each user to one table.I want to control taht table to contain only a fixed number of records.That's the only thing that I want to constraint. I hope that tomorow I'll still be alive and kicking.
Maybe your're using session variables or cookies in your script and your IE security settings doesn't allow them to run. I hope that tomorow I'll still be alive and kicking.
I should better explain my problem. I have a web interface in wich I give to other users acces to an Access table.It creates an Access table for each user and I cannot change the interface to limitate the number of records in each table. This property must be set in db.I do not know how. Pls...
Piece of cake? Not for me.I'm new to this and I cannot understand how to do it. I should better explain my problem. I have a web interface in wich I give to other users acces to an Access table.It creates an Access table for each user and I cannot change the interface to limitate the number of...
Does anyone have an ideea about how to set a table to have a fixed number of records? It is possible in Access? I hope that tomorow I'll still be alive and kicking.
I would like to know if there is a way to limit a table to contain, for example maximum 5 records. Pls help !! I hope that tomorow I'll still be alive and kicking.
I have a form wich is submitted using w3jMail to mail me the information, but I got the following error:
jmail.Message error '8000ffff' on the line where is the command to send the mail. I must mention that my ISP is using load balancing and the error comes out only on one machine. Any ideas?
I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.