Database

Depends on how you want the server to react; MySQL :: MySQL 5.7 Reference Manual :: 13.3.6 SET TRANSACTION Syntax[^] Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

thank you

Yes it did work thank you very much Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

Hi Richard, Sorry the delay in answering. the strategy you described above worked perfectly on my real production scenario. Many thanks.

Doing it already. Hoping someone shows up who has screwed around with this before. Makes the search go faster. :)

If you ask a question we sure can. There are only 10 types of people in the world, those who understand binary and those who don't.

Debug through the application code and see what is being retrieved and the execution method for viewing the PDF file. Never underestimate the power of human stupidity RAH

Haha, I love it, dump in your school work code, don't ask a question but ask for a solution. Try reading the guidelines on asking a question. Never underestimate the power of human stupidity RAH

I was going to make some sarcastic comment about their support forum! But they don't have one :-O . Sorry, don't use the product. Never underestimate the power of human stupidity RAH

A clustered index means that when you get to the end the end leaf of the index, you are at the physical location of the data you are looking for. This makes reading data very fast. None clustered indexes by contrast point to a physical location of data - this means that when you do reach the end leaf on a non-clustered index the disk head may have to move to get you your data. The one downside of a clustered index is that if you have a lot of inserts to the indexed table a clustered index will be disadvantageous. This is because every insert into the table will probably require a reorganisation of the physical location of some rows in the table that are not connected to the rows that you are inserting. The simple answer is - a clustered index is very useful when you have a lot of reading and not much writing. “That which can be asserted without evidence, can be dismissed without evidence.” ― Christopher Hitchens

Why on an external HD? SQL Server does not support plug & play; you may loose data if the drive is removed without detaching the database. If you just want to protect the data then I'd suggest backup up to the external HD and not using it as the servers' datasource. IIRC, then only network drives are 'disallowed'. If you want to setup the data-files to be on an external disc, you'd be interested in this[^] thread. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

Member 11161625 wrote: Is this code is correct??? Syntactic it is correct, but it will do nothing, as you instructed it. That is the default behaviour. If you want the "leave" days to be removed from the database when the employee is removed from the database, then you'd want a cascading delete. (ON DELETE CASCADE, not "NO ACTION"). That way you can prevent getting "orphaned" records. If you still need the leave-data from that person and don't want to wipe the records, I'd recommend "ON DELETE SET NULL", since the key would have become invalid - but then the record isn't deleted, just the key is removed - handy if you need the leave-data for statistics or other stuff. Last, there is also a "SET DEFAULT" option; if a manager is deleted from the database, then you might want to automatically update all affected workers to some default-manager. Member 11161625 wrote: Is it will work??? Depends on the specs. Press F5 and see if it does what you expect. Disclaimer; various database-engines may use different keywords and not support them all. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

Wonde nailed it, IMHO referential integrity and constraints are the last line of defense to keep the garbage in. They also help with optimisation of course. Never underestimate the power of human stupidity RAH