Put a unique key that is auto updated by the database in a column. Then store the last one that you have processed. Then is a simple matter to select rows that have an id that is greater than what you last selected using code that you indicated.
Ray Thompson Tau Beta Pi (www.tbp.org) The Engineering Honor Society 865-546-4578 -----Original Message----- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 30, 2005 1:33 PM To: SQL Subject: SELECT new records Hi, I have an application to write in C, not CF, that will check for an ODBC datasource created and maintain by another application, in order to detect and read any new record added since last time. For the time being, I have to do it on a FoxPro database. I know how I could do it pretty easily just by reading directly the DBF file from a small C application, but I'd like to make the program as general as possible and be able to check any ODBC datasource. So my question is: Is there some way I can make a SELECT that will get all records after a certain number, something like : SELECT * FROM myTable WHERE recordNb > myValue Any suggestion? -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2411 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
