Problems with views?
This is a multi-part message in MIME format. ------=_NextPart_000_003A_01C3C3E5.F75CFF60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi I have a problem with our system which is yielding error -243. Platform: Windows 2000 Informix 9.21 TC6R1 Single user development environment VB6 front end Scenario: Running a stored procedure which involves a view as part of a SELECT may sometimes cause the error "Could not position within a table ((Temp = table for view))". If I either restart the instance or try again after a short = while then it runs fine. This error seems to be normally linked to issues with locks on a table = but in this instance I think it is views (and different ones at that). Any ideas anyone? I'd be glad of some assistance. Kind Regards Ian Logan Project Manager Straker Systems Ltd ------=_NextPart_000_003A_01C3C3E5.F75CFF60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi<BR><BR>I have a problem with our = system which is=20 yielding error -243.<BR><BR>Platform:<BR>Windows 2000<BR>Informix 9.21=20 TC6R1<BR>Single user development environment<BR>VB6 front=20 end<BR><BR>Scenario:<BR>Running a stored procedure which involves a view = as part=20 of a SELECT may<BR>sometimes cause the error "Could not position within = a table=20 ((Temp table for<BR>view))". If I either restart the instance or try = again after=20 a short while then<BR>it runs fine.<BR><BR>This error seems to be = normally=20 linked to issues with locks on a table but in<BR>this instance I think = it is=20 views (and different ones at that).<BR><BR>Any ideas anyone? I'd be glad = of some=20 assistance.<BR><BR>Kind Regards<BR>Ian Logan<BR>Project = Manager<BR>Straker=20 Systems Ltd</FONT></DIV></BODY></HTML> ------=_NextPart_000_003A_01C3C3E5.F75CFF60-- sending to informix-list