Duplicate result using DELPHI and SQLAW

Assume a table Test with  column ID CHAR(30) primary key

put 6 records with string containing the letter '_' in the column ID

Create a DBGrid in Delphi using the primary key as index

You will see 12 records

If you have an Idea , call me

Thanks

0
Yoel
5/20/1998 5:03:20 PM
sybase.sqlanywhere.general 32637 articles. 4 followers. Follow

2 Replies
569 Views

Similar Articles

[PageSpeed] 53

>Assume a table Test with  column ID CHAR(30) primary key

>put 6 records with string containing the letter '_' in the column ID

>Create a DBGrid in Delphi using the primary key as index

>You will see 12 records

>If you have an Idea , call me


Can you determin the exact SQL statement that delphi issues the engine? (Try ODBC trace) . If you
can find that, try it in ISQL.  If it returns correct results there, the bug is either in the odbc
driver, Delphi, or your code.  If it returns incorrect results there, please post a CREATE TABLE and
INSERT and SELECT statements to reproduce the problem.  Thanks. 



Leo Tohill - Team Powersoft
-- Please post in newsgroup, not via email <
0
leotohill
5/21/1998 3:21:05 AM
I have had record duplication problems in the past with DBGrids connected
to TTable components which where highlighted by having mixed case data (I
presume the '_' is having the same effect).

If you are not already doing so, try connecting the grid to a TQuery
instead.

Yoel Kalifa <yoelk@cleyal.com> wrote in article
<35630CD8.7A45AC70@cleyal.com>...
> Assume a table Test with  column ID CHAR(30) primary key
> 
> put 6 records with string containing the letter '_' in the column ID
> 
> Create a DBGrid in Delphi using the primary key as index
> 
> You will see 12 records
> 
> If you have an Idea , call me
> 
> Thanks
> 
> 
0
Adrian
5/22/1998 7:18:46 AM
Reply:

Similar Artilces:

superreview requested: [Bug 242990] Crash when LDAP query results content none UTF8 characters : [Attachment 147958] If the result strings IsUTF8 use UTF8ToNewUnicode, otherwise use general ToNewUnic
wind li <wind.li@sun.com> has asked Dan Mosedale <dmose@mozilla.org> for superreview: Bug 242990: Crash when LDAP query results content none UTF8 characters http://bugzilla.mozilla.org/show_bug.cgi?id=242990 Attachment 147958: If the result strings IsUTF8 use UTF8ToNewUnicode, otherwise use general ToNewUnicode http://bugzilla.mozilla.org/attachment.cgi?id=147958&action=edit ...

superreview granted: [Bug 242990] Crash when LDAP query results content none UTF8 characters : [Attachment 147958] If the result strings IsUTF8 use UTF8ToNewUnicode, otherwise use general ToNewUnicod
Dan Mosedale <dmose@mozilla.org> has granted wind li <wind.li@sun.com>'s request for superreview: Bug 242990: Crash when LDAP query results content none UTF8 characters http://bugzilla.mozilla.org/show_bug.cgi?id=242990 Attachment 147958: If the result strings IsUTF8 use UTF8ToNewUnicode, otherwise use general ToNewUnicode http://bugzilla.mozilla.org/attachment.cgi?id=147958&action=edit ------- Additional Comments from Dan Mosedale <dmose@mozilla.org> r+sr=dmose ...

To use or not to use Delphi
Sadly, it seems to me that there is a sort of race between the two threads, for and against using Delphi in new projects, with more or less the same users posting in both threads. Arguments are fiercely debated in both camps. Borland had their own vision. As a community, now that Delphi has changed ownership I believe we should try to be more consistent, more clear, and more articulate in what we expect from Embercadero in terms of Delphi. We can contribute to keeping Delphi alive and moving in the right direction. "Laurent Cocea" schrieb: > Sadly, it seems to me that there ...

Using Delphi 7 and Delphi 2010
I had a project in Delphi 7. I worked on it in Delphi 2010. When I try to open the .dpr again in Delphi 7, the IDE toolbar widens across both monitors, and Delphi 7 locks up. It appears that Delphi 2010 modifies the .dpr in a way that makes Delphi 7 unable to open it again. All my forms & units appear to open fine in D7 after D2010, except for the warnings on the ExplicitHeight and ExplicitWidth properties being missing... I can easily recreate the .dpr, but is this expected behavior? Thanks. Tom Field wrote: > I had a project in Delphi 7. > > I worked o...

result value not used when using Raise?
I get a compiler warning that the return value of a function is not used, when I use Raise in the onException. I do not understand how that is possible, as there are two places where the function will exit before getting to the end (as far as I understand). The intention of Raise is that it will be handled the next level up, right? Which is what I want. {code} function TTeamReference.LoadStream(AnsiReader: TAnsiReader):boolean; var AVersion, AFooter: integer; begin result := false; << Compiler warning: [dcc32 Hint] TeamSetupU.pas(207): H2077 Value assigned to 'TTeamRe...

How design a COM using Delphi and Using in PB7?
I need some component, So, we want using DELPHI5 to develop a COM or Activex. What type of knowege or Skill I must know it. Can anyone tell us? from DRAOGN Can you explain what type of component you want to create? You may not need to a) build your own, or b) use Delphi. If the component should be used from within a PB application, you ought to use PB to develop it unless it is something that PB does not let you do. regards, Bill DRAGON wrote: > I need some component, So, we want using DELPHI5 to develop a COM or > Activex. > What type of knowege or Skill I ...

delphi Win32 using delphi .NET dll
Hi, I'm trying to use a delphi.NET dll in delphi.WIN32. I am currently using CodeGear Delphi 2007 with version2(base version) of .NET I can get the dll to import into the WIN32 application the only problem is when i include things such as: "using Classes,DateUtils, SysUtils" in the .NET dll the win32 application will instantly hang when any of the dll functions are called. Any help would be great thanks. Also I have tried this example and it also crashes for me? http://cc.embarcadero.com/Item/22688 -Braden I also found this.. "The problem is that, wehn you instal...

embarcadero.public.delphi.language.delphi.general
Hello! is the embarcadero.public.delphi.language.delphi.general forum working? Suddenly I can't post anything to it with Thunderbird Thanks! Sergio sergio wrote: > Hello! is the embarcadero.public.delphi.language.delphi.general forum > working? Suddenly I can't post anything to it with Thunderbird Works fine for me. -- Remy Lebeau (TeamB) On 27/02/2014 05:48 p.m., Remy Lebeau (TeamB) wrote: > sergio wrote: > >> Hello! is the embarcadero.public.delphi.language.delphi.general forum >> working? Suddenly I can't post anything to it wit...

can i use delphi 2007 bpls in delphi 2009
can i use delphi 2007 bpls in delphi 2009 ? "Gaetan SIRY" skrev i meddelelsen news:8703@forums.codegear.com... > can i use delphi 2007 bpls in delphi 2009 ? No. -- Finn Tolderlund The compatiblity between D2006 and D2007 was unique. Normaly they can't be compatible because new version enhance/change the API. And D2009 defines String = Unicode where older version has String = Ansistring so D200x/Dx-BPL are 200% incompatible with D2009. ...

How to use a delphi XE3 obj file in delphi 2007?
Hi, I'm migrating an application from delphi 2007 to delphi XE3 and I would like to do it in several steps. To do this I need to use a part of my new code (XE3) in the current delphi 2007 application. So I want to use the .obj file from my XE3 file. I know I have to use the {$L 'Filename'} and I know that I have to declare the functions that I want to use in external in my D2007 project. I wanted to make an easy and simple example to see how it works with only 1 function 'hello world' compiled in obj with XE3 but I can't find the way to use it in D2007. In D200...

If you use Delphi...
If you use Delphi for .NET with ASA, please vote for this: http://qc.borland.com/wc/qcmain.aspx?d=31677 ...

the general use
Name: Pilko Nera Product: Shiretoko Summary: the general use Comments: I thinks IE8 is much better than Firefox 3.1 Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.1b3) Gecko/20090305 Firefox/3.1b3 From URL: http://hendrix.mozilla.org/ Note to readers: Hendrix gives no expectation of a response to this feedback but if you wish to provide one you must BCC (not CC) the sender for them to see it. ...

Result RESULT?
Hello. I was looking at what is going on in TB 2.0.0.24 development. There is test results "result: RESULT" and "Status: RESULT". What does that mean? It is waiting for result, it has passed the test, it has results, but they has not been analyzed? What? Still TBD in releases-page. Pretty slow for security fix. Timo Pietil� On 16/02/10 09:26, Timo Pietil� wrote: > Hello. > > I was looking at what is going on in TB 2.0.0.24 development. There is > test results "result: RESULT" and "Status: RESULT". What does that mean? &...

Indy IdHMACSHA1 different results in Delphi 2007 and Delphi 2009
Hello newsgroup A test of the IdHMACSHA1 encryption method shows different results, and I am not sure if there is an error in my code or in the Indy code shipped with Delphi 2009. The Delphi 2007 version works in an application which communicates with Amazon Web Services and so it seems to be the correct one. Any suggestions are very welcome, maybe I just need to download a newer version of Indy? program Test; {$APPTYPE CONSOLE} uses IdHMACSHA1, IdCoderMIME, IdGlobal, SysUtils; function Base64Encode(const Input: string): string; begin Result := TIdEncode...

Web resources about - Duplicate result using DELPHI and SQLAW - sybase.sqlanywhere.general

Duplicate bridge - Wikipedia, the free encyclopedia
Duplicate bridge is the most widely used variation of contract bridge in club and tournament play. It is called duplicate because the same bridge ...

Search for duplicate files - Wikipedia, the free encyclopedia
Language: English Home Random Search for duplicate files Search for duplicate files based on hash values. 900 × 600 pixel File size: 377 B MIME ...

Facebook Addresses Duplicate And False Accounts, Teen Usage In Form 10-K
Facebook said in its Form 10-K filing with the Securities and Exchange Commission that duplicate accounts may have made up between 4.3 percent ...

Facebook surveys users about Timeline, duplicate profiles, more
... a 16-question survey about their experience with the social network. The survey includes questions about Timeline and whether users have duplicate ...

Search Twitter - duplicate
... using an old version of Internet Explorer. Learn more here Search Refresh Jocelyn @ jocelyn_poppy 2m great now Cleveland state gave me a duplicate ...

Mac App Store - Duplicate Searcher
Get Duplicate Searcher on the Mac App Store. See screenshots and ratings, and read customer reviews.

How-To: Safely shrink your Mac’s giant photo library, deleting duplicate images to save space
... Apple’s new Photos app , you might be surprised to learn that you’ve lost a lot of hard drive space, and that there are suddenly tons of duplicate ...

Ubaldo Jimenez seeks to duplicate fastball command, success in second start Friday
In between so many starts in 2014, right-hander Ubaldo Jimenez spoke of the fixes he knew he needed to make to improve his performance.

Unit Testing In Java, Duplicate Code in Java GUIs
... to comment on: You're perfectly right when saying that implementing ActionListener in the window class itself usually leads to loads of duplicated ...


Resources last updated: 11/27/2015 3:26:51 PM