Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #9446
| 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) |
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
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