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


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

Advantage Database server troubles continued...

From "Wolfgang Riedmann" <wriedmann@gmail.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Advantage Database server troubles continued...
Date 2016-06-17 19:31 +0200
Message-ID <dsiqf9F9v76U1@mid.individual.net> (permalink)

Show all headers | 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