Path: csiph.com!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "Wolfgang Riedmann" 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: 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 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 --