Hi all, I try to locate a record using a SQL query knowing only the record number. Reading SQL manual I know about the virtual field that contain the record ID (that is the record number). So I wrote something like this:
Begin SQL select field123 from table1 where __ROW_ID = 10 into :$myVar End SQL and works. The problem is that the virtual “ __ROW_ID” field seems to be mantained as "no indexed” field, and the query is sequential and really slow for very large tables. So my question is: there is a way to fast locate a record using the record number into a SQL query? TIA, Gianluca Gianluca Rigotti ---------------------------------- Via Rupi di via XXIX Settembre, 27 60125 Ancona (AN) ITALY ---------------------------------- T: +39 071 9987145 M: +39 338 4550245, +39 335 1360105 mail: [email protected], [email protected] skype: gianluca.rigotti ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
