>Ed,
>My special thanks to you for heads up. If you remember the thread of Bret, he was asking a way to know who is actively using the app tables on the network. After your message about fcreate(AtServer) to get a common datetime I totally changed my schema :) Thanks.
>Cetin
I am glad my can of worms helped someone. We tossed around Ed's file creation answer and the only down thing we can think of is that the overhead in time that would be taken to create a file, check its datetime, then delete the file. We also have seen in the past that Novell does not release files very fast in order that they may be deleted. We have had code that wrote to a temporary table, then when it was done issued a USE on it, then immediately did an ERASE tempfilename and received the error FILE IN USE. If we put a wait in between the USE and ERASE of lets say 2-3 seconds then Novell would release the file for deletion. I guess we can always leave temp files in a temp directory and have a process clean out old files nightly and thus avoid the erase part of the equation. But I digress, have a good day Cetin
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope