tag:blogger.com,1999:blog-6222893893652665733.post7480742870812084951..comments2024-01-08T00:30:35.594-08:00Comments on Cary Jensen "Let's Get Technical": Advantage AdsQuery and RecNoUnknownnoreply@blogger.comBlogger3125tag:blogger.com,1999:blog-6222893893652665733.post-89013968066063248702011-07-31T05:51:37.751-07:002011-07-31T05:51:37.751-07:00Cary that was an amazing explanation. This is one ...Cary that was an amazing explanation. This is one of those hard to find nuggets that is a very simple fix to a very frustrating behavior.Michael Rileyhttps://www.blogger.com/profile/15959746627356186242noreply@blogger.comtag:blogger.com,1999:blog-6222893893652665733.post-92008443369005169902011-05-05T17:52:44.057-07:002011-05-05T17:52:44.057-07:00Doug: Thank you for the explanation. On the other ...Doug: Thank you for the explanation. On the other hand, the TAdsQuery is a TDataSet (Delphi) component. As such, I would expect TDataSet behavior. Nonetheless, your explanation makes a lot of sense.Cary Jensenhttps://www.blogger.com/profile/09264435441034661563noreply@blogger.comtag:blogger.com,1999:blog-6222893893652665733.post-23934940912316432912011-05-05T12:32:40.547-07:002011-05-05T12:32:40.547-07:00Another reason for this behavior is that a lot of ...Another reason for this behavior is that a lot of older dbase/clipper/foxpro systems didn't bother with a unique identifier, but used the record number as that ID (yes, I know, if you pack it gets messed up...I didn't say it was a good idea, but I have seen it a LOT), so the only good way to have a usable key for those systems is to pass through the underlying record number. Since a lot of people first experience Advantage because they are looking for a way to migrate from one of those database systems, it makes sense to support those practices as the default.Anonymousnoreply@blogger.com