Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #9448
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Advantage Database server troubles continued... |
| Date | 2016-06-18 09:37 +0200 |
| Message-ID | <dskc2lFj1h5U1@mid.individual.net> (permalink) |
| References | <dsiqf9F9v76U1@mid.individual.net> <nk20so$hdm$1@news.albasani.net> |
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 --
Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Find similar | Unroll thread
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
csiph-web