Welcome to the SQLitening support forums!
Started by Marty Francom, January 20, 2010, 02:53:15 pm
QuoteThe ROWID is essentially a record number for a specific record. Correct?
QuoteFor a particular RECORD the ROWID will be the same no matter what index is being used to look up that record. Is that correct?
QuoteIf records are deleted will their ROWID be reused by a different record or will all Records be ressign a different ROWID when a record is deleted?
QuoteWhat I am getting at is Can I depend on the ROWID always being associated with a specific record? Is it safe for me to store the ROWID of a RECORD in one Table in the Record of another Tablet and that the other Record with always be able to retriev the record it needs by getting the record using the ROWID it had stored for that Record. Is this thinking correct?
QuoteDoes vacumming the database to remove deletes effect the Record's RowID?
QuoteIf I want to get a record by its ROWID woud this be the correct syntax?SQL1 = "SELECT ROWID, * FROM Refills WHERE [" rowid "] " & direction & " '" & sTxt & "' ORDER BY [" rwoid "]"
Quote"Select * from Refills where RowID=" format$(llSavedRowID)
Quote from: Marty Francom on January 20, 2010, 06:30:43 pmI am still not quite sure how to set a field with "Integer Primary Key" properties.