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


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

Advantage Database server troubles continued...

Path csiph.com!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From "Wolfgang Riedmann" <wriedmann@gmail.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Advantage Database server troubles continued...
Date Fri, 17 Jun 2016 19:31:15 +0200
Lines 42
Message-ID <dsiqf9F9v76U1@mid.individual.net> (permalink)
Mime-Version 1.0
Content-Type text/plain; charset=iso-8859-1
X-Trace individual.net LZiJM+4pyu9OmT7adbwXrAib/d7L61aCsYyVJ6WvfaObI0UQs=
Cancel-Lock sha1:fjWWHy8MOBbFBAeut4Qdi42ZfDI=
User-Agent XanaNews/1.18.1.6
Xref csiph.com comp.lang.clipper.visual-objects:9446

Show key headers only | View raw


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 — Next 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