Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #9448
| Path | csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail |
|---|---|
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Advantage Database server troubles continued... |
| Date | Sat, 18 Jun 2016 09:37:52 +0200 |
| Lines | 64 |
| Message-ID | <dskc2lFj1h5U1@mid.individual.net> (permalink) |
| References | <dsiqf9F9v76U1@mid.individual.net> <nk20so$hdm$1@news.albasani.net> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=iso-8859-1 |
| X-Trace | individual.net welGyjeivTw6AO7bpvQXtgZ5coHUEhWsFCgJkg6XmzhYB+qQ4= |
| Cancel-Lock | sha1:hHZe6cmxjGJTyvYhOnHE6FBh+QA= |
| User-Agent | XanaNews/1.18.1.6 |
| Xref | csiph.com comp.lang.clipper.visual-objects:9448 |
Show key headers only | View raw
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