Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Ian Logan — — source: Usenet: comp.databases.informix
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.