Re: ISQL - Reports with ACE (saceprep, sacego) - lock problem

Reinhard Habichtsberg wrote: > > Jonathan Stowe <gellyfish@gellyfish.com wrote: > > Reinhard Habichtsberg <Reinhard.Habichtsberg@unilux.de> wrote: > > > in SQL statements, esqlc programs, even in odbc connections > > > I can use "set lock mode to wait ...". Thereby the program does > > > not stop if a table is locked temporary. > > > > You cant do it in an ACE report - you can only have select > > statement. > > That's poor. Not the answer :-) but the fact :-( . > Isn't there any workaround? As I had replied off-list, you can set the environment variable SACEISOL to the value "DIRTY READ" and get the desired effect for ACE.