Re: PowerBuilder Front-End to Informix
This is a multi-part message in MIME format. ------=_NextPart_000_0138_01C03F43.894DA620 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have found out that powerbuilder seems to have a problem when doing an = int to char conversion of the value zero(0). i.e. when I attempt to = insert an integer value of 0 into a char field it gives the problem, any = other integer value works fine.This only occurs with Informix 7.3 works = fine with informix 5.0... -----Original Message----- From: Mickler, Frank <Frank.Mickler@twinsoft.de> To: 'informix-list@iiug.org' <informix-list@iiug.org> Date: Thursday, October 26, 2000 12:50 PM Subject: AW: PowerBuilder Front-End to Informix =20 =20 We use an ODBC-Connection via an Intesolv ODBC-Driver plus = Informix-Connect 7.2 to access Informix 7.31UC... from PowerBuilder = 5.0.4 This works very fine. Some time ago we tried the Informix-native-Driver PBIN750.DLL but = this was very unstable =20 Frank Mickler =20 -----Urspr=FCngliche Nachricht----- Von: Dayton Spencer [mailto:dspencer@fsl.org.jm] Gesendet: Dienstag, 24. Oktober 2000 23:54 An: informix-list@iiug.org Betreff: PowerBuilder Front-End to Informix =20 =20 I am currently using PowerBuilder 5.03 to connect to Informix = 7.3 database engine running on Unixware. I am using Inforimx Connect = version 9.2.=20 =20 I am having problems inserting data into one of my database = tables using an embedded SQL statement in powerbuilder. Whenever I = attempt to do an Insert or an Update the database engine crashes without = giving any error messages. Has anyone experienced any similar problems = that could guide me as to where the problem might lie. =20 Regards, Dayton. =20 =20 ------=_NextPart_000_0138_01C03F43.894DA620 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN"> <HTML> <HEAD> <META content=3Dtext/html;charset=3Diso-8859-1 = http-equiv=3DContent-Type><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 = Transitional//EN"> <META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV> <DIV><FONT color=3D#000000 size=3D2>I have found out that powerbuilder = seems to have=20 a problem when doing an int to char conversion of the value zero(0). = i.e. when I=20 attempt to insert an integer value of 0 into a char field it gives the = problem,=20 any other integer value works fine.This only occurs with Informix = 7.3=20 works fine with informix 5.0...</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV> <BLOCKQUOTE=20 style=3D"BORDER-LEFT: #000000 solid 2px; MARGIN-LEFT: 5px; PADDING-LEFT: = 5px"> <DIV><FONT face=3DArial size=3D2><B>-----Original = Message-----</B><BR><B>From:=20 </B>Mickler, Frank <<A=20 = href=3D"mailto:Frank.Mickler@twinsoft.de">Frank.Mickler@twinsoft.de</A>&g= t;<BR><B>To:=20 </B><A = href=3D"mailto:'informix-list@iiug.org'">'informix-list@iiug.org'</A>=20 <<A=20 = href=3D"mailto:informix-list@iiug.org">informix-list@iiug.org</A>><BR>= <B>Date:=20 </B>Thursday, October 26, 2000 12:50 PM<BR><B>Subject: </B>AW: = PowerBuilder=20 Front-End to Informix<BR><BR></DIV></FONT> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN = class=3D637225213-26102000>We=20 use an ODBC-Connection via an Intesolv ODBC-Driver plus = Informix-Connect 7.2=20 to access Informix 7.31UC... from PowerBuilder = 5.0.4</SPAN></FONT></DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20 class=3D637225213-26102000>This works very fine.</SPAN></FONT></DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20 class=3D637225213-26102000>Some time ago we tried the = Informix-native-Driver=20 PBIN750.DLL but this was very unstable</SPAN></FONT></DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20 class=3D637225213-26102000></SPAN></FONT> </DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20 class=3D637225213-26102000>Frank Mickler</SPAN></FONT></DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20 class=3D637225213-26102000></SPAN></FONT> </DIV> <BLOCKQUOTE=20 style=3D"BORDER-LEFT: #0000ff solid 2px; MARGIN-LEFT: 5px; = MARGIN-RIGHT: 0px; PADDING-LEFT: 5px"> <DIV align=3Dleft class=3DOutlookMessageHeader dir =3D ltr><FONT = face=3DTahoma=20 size=3D2>-----Ursprüngliche Nachricht-----<BR><B>Von:</B> = Dayton=20 Spencer [mailto:dspencer@fsl.org.jm]<BR><B>Gesendet:</B> = Dienstag, 24.=20 Oktober 2000 23:54<BR><B>An:</B>=20 informix-list@iiug.org<BR><B>Betreff:</B> PowerBuilder Front-End = to=20 Informix<BR><BR></DIV></FONT> <DIV><FONT color=3D#000000 size=3D2>I am currently using = PowerBuilder 5.03=20 to connect to Informix 7.3 database engine running on Unixware. = I am=20 using Inforimx Connect version 9.2. </FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV> <DIV><FONT color=3D#000000 size=3D2>I am having problems = inserting data into=20 one of my database tables using an embedded SQL statement in=20 powerbuilder. Whenever I attempt to do an <STRONG>Insert = </STRONG>or an=20 <STRONG>Update</STRONG> the database engine crashes without = giving any=20 error messages. Has anyone experienced any similar problems that = could=20 guide me as to where the problem might lie.</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Regards,</FONT></DIV> <DIV><FONT size=3D2>Dayton.</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV> <DIV><FONT color=3D#000000=20 size=3D2></FONT> </DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML> ------=_NextPart_000_0138_01C03F43.894DA620--