Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #9446 > unrolled thread
| Started by | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| First post | 2016-06-17 19:31 +0200 |
| Last post | 2016-06-18 09:37 +0200 |
| Articles | 3 — 2 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
Advantage Database server troubles continued... "Wolfgang Riedmann" <wriedmann@gmail.com> - 2016-06-17 19:31 +0200
Re: Advantage Database server troubles continued... "Jim" <nospam@example.com> - 2016-06-17 19:25 -0400
Re: Advantage Database server troubles continued... "Wolfgang Riedmann" <wriedmann@gmail.com> - 2016-06-18 09:37 +0200
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2016-06-17 19:31 +0200 |
| Subject | Advantage Database server troubles continued... |
| Message-ID | <dsiqf9F9v76U1@mid.individual.net> |
Hi, since I was not able to use the AdvantageRDD.dll with Vulcan 4, I have tried to use the Advantage ADO.NET provider to look up values in a AXDBFCDX table. This works most of the time, but some of the values are not found (on every round the same), but when I try with another program to use the same select, it works. This is my code: cKdnr := _oGKonto:FGTrim( "kdnr" ) cSelect:= "select KName from Kunden where trim( kdnr ) = '" + cKdnr + "'" ) oCommand:CommandText := cSelect oReader := oCommand:ExecuteReader() if oReader:Read() cKName := oReader:GetValue( 0 ):ToString():Trim() endif A sample select is this one: select KName from Kunden where trim( kdnr ) = 'TVNATZ' or select KName from Kunden where trim( kdnr ) = 'DIEWALDRUH' There are no special characters in the select string.... Has anyone seen similar things? I was suspecting that there were some strange characters in the cKdnr variable, but it seems they are ok. Could this be an issue of ANSI/Unicode conversions? TIA Wolfgang --
[toc] | [next] | [standalone]
| From | "Jim" <nospam@example.com> |
|---|---|
| Date | 2016-06-17 19:25 -0400 |
| Message-ID | <nk20so$hdm$1@news.albasani.net> |
| In reply to | #9446 |
How about doing it without a Trim()? cSelect:= "select KName from Kunden where kdnr = '" + cKdnr + "'" ) "Wolfgang Riedmann" wrote in message news:dsiqf9F9v76U1@mid.individual.net... Hi, since I was not able to use the AdvantageRDD.dll with Vulcan 4, I have tried to use the Advantage ADO.NET provider to look up values in a AXDBFCDX table. This works most of the time, but some of the values are not found (on every round the same), but when I try with another program to use the same select, it works. This is my code: cKdnr := _oGKonto:FGTrim( "kdnr" ) cSelect:= "select KName from Kunden where trim( kdnr ) = '" + cKdnr + "'" ) oCommand:CommandText := cSelect oReader := oCommand:ExecuteReader() if oReader:Read() cKName := oReader:GetValue( 0 ):ToString():Trim() endif A sample select is this one: select KName from Kunden where trim( kdnr ) = 'TVNATZ' or select KName from Kunden where trim( kdnr ) = 'DIEWALDRUH' There are no special characters in the select string.... Has anyone seen similar things? I was suspecting that there were some strange characters in the cKdnr variable, but it seems they are ok. Could this be an issue of ANSI/Unicode conversions? TIA Wolfgang --
[toc] | [prev] | [next] | [standalone]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2016-06-18 09:37 +0200 |
| Message-ID | <dskc2lFj1h5U1@mid.individual.net> |
| In reply to | #9447 |
Hi Jim, > How about doing it without a Trim()? > > cSelect:= "select KName from Kunden where kdnr = '" + cKdnr + "'" ) unfortunately the same result.... I have also checked the DBF table contents with a VO application, and there seem no strange characters in the fields. Wolfgang > > "Wolfgang Riedmann" wrote in message > news:dsiqf9F9v76U1@mid.individual.net... > > Hi, > > since I was not able to use the AdvantageRDD.dll with Vulcan 4, I have > tried to use the Advantage ADO.NET provider to look up values in a > AXDBFCDX table. > > This works most of the time, but some of the values are not found (on > every round the same), but when I try with another program to use the > same select, it works. > > This is my code: > > cKdnr := _oGKonto:FGTrim( "kdnr" ) > cSelect:= "select KName from Kunden where trim( kdnr ) = '" + cKdnr + > "'" ) > oCommand:CommandText := cSelect > oReader := oCommand:ExecuteReader() > if oReader:Read() > cKName := oReader:GetValue( 0 ):ToString():Trim() > endif > > A sample select is this one: > > select KName from Kunden where trim( kdnr ) = 'TVNATZ' > > or > > select KName from Kunden where trim( kdnr ) = 'DIEWALDRUH' > > There are no special characters in the select string.... > > Has anyone seen similar things? I was suspecting that there were some > strange characters in the cKdnr variable, but it seems they are ok. > > Could this be an issue of ANSI/Unicode conversions? > > TIA > > Wolfgang --
[toc] | [prev] | [standalone]
Back to top | Article view | comp.lang.clipper.visual-objects
csiph-web