With locks it is possible to set a timeout of say 15 seconds so that the programs does not wait "forever" for the lock to be released. It returns an error to which the user can click ok and restart what they were doing. This is handy. Much better than waiting "forever".

Is it possible to have a similar timeout on a cDbCjGrid?

I have a table with, at some sites, over 1,000,000 rows. The table has 11 indexes. It gets confusing getting the DD constrains to properly match the indexes of the grid column (eg the column StartDate is used in three indexes, one global, one per user and one per customer). I think I have finally done it. Except every once in a while things just don't work right and off goes the list, presumably reading every row of the table. This can take 4 or more minutes. It would be very nice if, after say 15 seconds, it returned so I could popup a box saying: sorry the programmer screwed up, click OK to restart the list.

Thanks
Archie