RE: Ifx +odbc +lock
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C0285F.E1A27B20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable If you use ADO, check the values for these properties: - CursorLocation - CursorType - LockType =20 I think they are for something in your problem. But I am not sure. -----Message d'origine----- De : Ramon Marquez [mailto:ramonmarquez@costanet.es] Envoy=E9 : mardi 26 septembre 2000 17:32 =C0 : informix-list@iiug.org Objet : Ifx +odbc +lock I'm using VB6 as a client program that access data stored in a Informix On-line 5.10 database through ODBC. I've used Informix Client and the driver that comes with it's latest version (for me 2.5). I can do almost anything but I simply can not lock a single row (neither a page) from the program so I can prevent concurrent problems. What's the thing I should do, or the point I'm mising that let me use locking against these Informix database. BTW, I can use transaction, I point that I think could be involved in solving the problem. I also use Informix star product for accessing the information in the unix boxes (the Informix database) and tcp/ip as the protocol underlying. TIA ------_=_NextPart_001_01C0285F.E1A27B20 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=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <TITLE></TITLE> <META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR></HEAD> <BODY> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN = class=3D097104208-27092000>If you=20 use ADO, check the values for these properties:</SPAN></FONT></DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN = class=3D097104208-27092000>-=20 CursorLocation</SPAN></FONT></DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN = class=3D097104208-27092000>-=20 CursorType</SPAN></FONT></DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20 class=3D097104208-27092000>- LockType</SPAN></FONT></DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20 class=3D097104208-27092000></SPAN></FONT> </DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN = class=3D097104208-27092000>I=20 think they are for something in your problem. But I am not=20 sure.</SPAN></FONT></DIV> <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px"> <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT = face=3DTahoma=20 size=3D2>-----Message d'origine-----<BR><B>De :</B> Ramon = Marquez=20 [mailto:ramonmarquez@costanet.es]<BR><B>Envoy=E9 :</B> mardi 26 = septembre=20 2000 17:32<BR><B>=C0 :</B> = informix-list@iiug.org<BR><B>Objet :</B>=20 Ifx +odbc +lock<BR><BR></DIV></FONT> <P><FONT size=3D2>I'm using VB6 as a client program that access data = stored in=20 a<BR>Informix On-line 5.10 database through ODBC.<BR><BR>I've used = Informix=20 Client and the driver that comes with it's latest<BR>version (for me=20 2.5).<BR><BR>I can do almost anything but I simply can not lock a = single=20 row<BR>(neither a page) from the program so I can prevent=20 concurrent<BR>problems.<BR><BR>What's the thing I should do, or the = point I'm=20 mising that let me use<BR>locking against these Informix = database.<BR><BR>BTW,=20 I can use transaction, I point that I think could be involved = in<BR>solving=20 the problem. I also use Informix star product for accessing<BR>the = information=20 in the unix boxes (the Informix database) and tcp/ip<BR>as the = protocol=20 underlying.<BR><BR>TIA<BR></FONT></P></BLOCKQUOTE></BODY></HTML> ------_=_NextPart_001_01C0285F.E1A27B20--