Re: ROWID

Alex@arcfan.demon.co.uk (Alex McLintock) writes: >Someone quite helpfully pointed me at ROWID since >I was after some sort of Record Number. >I am using various SELECT statements and I want the ROWID >for any table's row to remain the same for the entire lifetime >of my program - even if other records in the table are deleted >or more records added. >Is this a correct assumption? No, No, No! You'll be in big trouble if you depend on ROWID for all but a very short timespan. They are used internally by the engine, and for the most part you should consider it undocumented (I kind of wish it was). >I am obviously in need of a beginner's guide to standard SQL. Informix Guide to SQL Tutorial & Reference, part number 000-7545. Although I don't know if it would have answered this specific question. ============================================================ Dennis J. Pimple Informix Software Inc Senior Consultant Denver Colorado USA dennisp@informix.com Voice:303-850-0210 Fax:303-779-4025