Re: Cursor in a report

In article <35F77F12.21BBC721@tusc.com.au>, Hans Siebrand <jhs@tusc.com.au> wrote: > In creating a report we have an open cusor and a free cusor statment, it > quite happily works with Version 5 databases with 4GL V4.1x, but does > not work with V7.x databases with 4GL V6.x. > > 1. Does anyone know why? > 2. How do you get around it? > > Cheers > -- > Hans Siebrand, jhs@tusc.com.au > Laboratory Systems Group, TUSC Computer Systems Pty. Ltd. > Phone +61 03 9840 4431 > Fax +61 03 9840 2277 Hans, Hate to answer a question with a question, but if you can be more specific, your question can be answered: 1. Can you supply the code, or the relevant code segments? 2. What exactly doe not work? Does the open fail? Does the close fail? Does the fetch fail? And when does it fail? Right away, after something ... Is the cursor successfully opened and a single fetch works, but the cursor does not stay open?? Not liking to answer a question with a question, I'll give you an answer that is probably wrong due to not lack of information: There isn't a reason that I can think of that using a cursor to feed data to a report should work in 5.X and not in 7.X. Does anyone else have any thought, while Hans is getting more data for us?? -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum