Oh sorry, I posted this just before Ralph replied. Thanks Ralph I will try your suggestions.
Bob S > On Sep 17, 2021, at 16:32 , Bob Sneidar <bobsnei...@iotecdigital.com> wrote: > > Okay something is not right with the API! First, my query in my script is set > to: > > SELECT * from files where siteid = '1659' > > If I run this in mySQLWorkbench, I get one record, so I know the query works. > Also, I know the cursor contains records, because as I step through the loops > which get the column values, I can see the vlaues in the variables populate > when I use: > > put revDatabaseColumnNumbered(pCursorID, i) into tColumnValue > > Here is the rub though. The first record of a cursor is 0. ZERO!!! And if > there is only one record, guess what the LAST record is??? ZERO!!!!! > > Does that make the least bit of sense to ANYONE??? There is no call that I > can find to get the number of records of a cursor! Therefore I can NEVER TELL > if a cursor contains any records. > > If anyone has a method for doing so, your help will be very much appreciated. > > Bob S > >> On Sep 17, 2021, at 16:04 , Bob Sneidar via use-livecode >> <use-livecode@lists.runrev.com> wrote: >> >> Hi all. >> >> I am trying to discern between when I have an empty cursor, and when I have >> reached the last record of a cursor. >> >> I have noticed that if I query a database that returns no results, I still >> get a cursor ID, so I cannot test for a cursor ID. So after my loop to >> convert a cursor to an array, I check to see if I am on the last record by >> using put revCurrentRecord(pCursorID) into tLastRecord, then testing to see >> if it returns 0, which it will if the cursor is empty. >> >> But it seems that if I am already on the last record of the cursor, then I >> use revMoveToNextRecord pCursorID, revCurrentRecord ALSO RETURNS 0! So now I >> am left without a way to tell if the cursor is empty, or if otherwise, I >> have reached the last record. >> >> How is this done?? Normally I use sqlYoga so these things are spared me, but >> in this instance I am using the native API calls. >> >> Bob S >> >> >> _______________________________________________ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode