Drew,

Works as charm!!!
I do like 'faster approach' in 'Shipyard': delete from instead of searching in tFor_Confirmation table!
However, I'm not expert for SunBasic, but it seems to me that you missed a function call for Week-function. At least, it doesn't work on my Linux box and in 'BeforeInsert' event I can not find function call. How to do that in the SunBasic?
Just thinking: could be more comfortable if it is possible to attach whole 'Week calculation' module to  'Text modified' and  'After updating'? events of Date Field. And, perhaps, in 'When loading' event of frmInspection1, for initial calculation? Just thinking...products of tired brain. Also in frmInspection1 field Week can not be 'read only' - sometime people are lazy to update their records immediately.
Just thinking.
Thanks for your time,

Deki

--

Reply via email to