Re: Insert triggers, is this a bug, is there a work around?

Richard Spitz wrote: > Leffler, Jonathan wrote: > > SELECT * FROM SomeTable;> > !sleep 20 > > UPDATE SomeTable > > SET Information = 'Obsoleted by the passage of time' > > WHERE RefNum = 123456; > > SELECT * FROM SomeTable;> > Is the "!sleep 20" just "Pseudo code", or is it a valid shell > escape syntax? > On my system (dbaccess 5.10 on a SNI RM400 under ReliantUnix 5.43) > it gives me a syntax error. Either or both. If you run it in the query language option (withthe menus and editor, etc), it is a syntax error. If you run it from the command line "dbaccess database script", then it is a valid (but undocumented) shell escape -- at least, when I last tested it in ISQL it worked, and I think it is in DB-Access too... Yours,