<<
Richard Harding wrote:

Great - thank you Raul. Works well - except for the poor SQL grammar that uses IMMEDIATE as adverb.
>>

Richard - for what it's worth most major db's use same keywords so i think Tim was just trying to save developer sanity  &#128513;

Raul

<<

Richard Harding wrote:

Last night I could not power off my machine. <ctl><alt><del> would ldid not give me access to the taks manager. It was difficult to tturn of the machine with the power switch. I tried several times to reboot the PC without success.

Eventuallly powered off the PC, we all went to bed and had a good night's sleep.

This morniing the PC re-booted, did its hard drives disk check and and is now working perfectly well.

>>


Richard - just a guess but assuming its a modern Windows (Win 8 or newer) it sounds to me like a Windows/Driver/Hardware/Anti-Virus type of issue.

While apps can still freeze or crash I cannot think of any app hanging windows itself in my case for multiple years now.

My first goto item is windows event logs - see if any red error entries show up - maybe like disk having bad sectors or such.

Raul

Raul wrote:

<<
Richard Harding wrote:

Great - thank you Raul. Works well - except for the poor SQL grammar that uses IMMEDIATE as adverb.
>>

<< Richard - for what it's worth most major db's use same keywords so i think Tim was just trying to save developer sanity>>

It is standard SQL grammar - the SQL developer community appararently missed out on their English grammar classes.

Richard