You would have to select results and page tthrough them.
Claude Schneegans wrote: > 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? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase RoboHelp from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=59 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2413 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=11502.10531.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
