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


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

Advantage Database server troubles continued...

Started by"Wolfgang Riedmann" <wriedmann@gmail.com>
First post2016-06-17 19:31 +0200
Last post2016-06-18 09:37 +0200
Articles 3 — 2 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  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

#9446 — Advantage Database server troubles continued...

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2016-06-17 19:31 +0200
SubjectAdvantage Database server troubles continued...
Message-ID<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

-- 

[toc] | [next] | [standalone]


#9447

From"Jim" <nospam@example.com>
Date2016-06-17 19:25 -0400
Message-ID<nk20so$hdm$1@news.albasani.net>
In reply to#9446
How about doing it without a Trim()?

cSelect:= "select KName from Kunden where kdnr = '" + cKdnr + "'" )

"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

--  

[toc] | [prev] | [next] | [standalone]


#9448

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2016-06-18 09:37 +0200
Message-ID<dskc2lFj1h5U1@mid.individual.net>
In reply to#9447
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



-- 

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web