ONLINE 7.01.UC1 CRASHES

Dear All, I recently posted about a crash with online 7.01.UC1 using RDS 6.01.UD3 on Solaris 2.4. I have been able to duplicate this on the stores2 database and also found some workarounds. I suspect this is a bug but it may be a configuration problem. So if some of you could try this on your systems I would appreciate it. The symptom is that your database engine goes down on a segmentation violation the second time that the cursor is closed. If you dont close the cursor the engine still goes down on the implied close when it is re-opened. The code is below that causes the problem. You can stop the crash from occuring by doing: 1. Declaring the cursor WITH HOLD. 2. Taking the "[]" notation out of the matches. 3. Using any number of variables in the open (except 2). I would appreciate any feedback on this. Jason Harris (RSWA) -- code database stores2 main define a integer, b integer, c char(256), d integer, e char(30) let c = "SELECT SUM(quantity) FROM items WHERE order_num = ? and stock_num IN (select stock.stock_num from stock where description matches ?)" prepare t1 from c declare test1 cursor for t1 let a = 1002 let e = "[be]*" open test1 using a,e fetch test1 into d close test1 display d let a = 1002 let e = "[fe]*" open test1 using a,e fetch test1 into d close test1 display d end main -- end code ============================================================================= Jason Harris Fill with >--------+ Welcome to the information back tracks. favourite | v | contents | | private email - shooter@perth.DIALix.oz.au and DRINK! \\**/ business email - jasonh@rswa.DIALix.oz.au **** =============================================================================