Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #9448

Re: Advantage Database server troubles continued...

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


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