I have used the 1999 version on everything from Windows 3.1 to Windows 8 64 bit. I have even created my own "version 3.5" by recompiling some of the source code. I tried version 5 but found it unsatisfactory, especially as it lacked the capability to construct bespoke applications.
If I recall correctly, the manual – or maybe the help file – warns that using the record number is risky because it can change, especially if the file is re-indexed or exported then reimported. The removal of empty or defective records can also change the last record’s number.
If I need a primary key, a unique identifier for each record, I use an integer field in each record and increment it by 1 each time a new record is created. This identifier will never change and will remain with its record always.
Hope this helps. Let me know if you need more ideas!
Chris
tel 01276 51 42 34
mbl 07969 90 71 93 / 07982 934592
skype chris.hurrey
From: Ideal...@googlegroups.com [mailto:Ideal...@googlegroups.com] On Behalf Of Resurgam
Sent: Wednesday, January 09, 2013 4:39 PM
To: Ideal...@googlegroups.com
Cc: chris....@ntlworld.com
Subject: Re: Another Idealist refugee
I wonder if anyone can help with a slight snag? I overwrite my original Nov. 1995 build files with the 1999 build last month. My main database currently contains 7,597 records and I use the record number as an identifier. My standard procedure for 17 years has been to go to the end of the file and add a new record - simple! So, today: end of file, insert new record, but instead of being record number 7,598 of 7,598, the new record is 7,583 or 7,598. In fact, wherever I go in the file, the new record always wants to insert itself at the same location, record number 7,583. I had this happen once before in the 1990s and believe I got round the issue then by exporting all records and importing into a new database. But is there an easier option? There are no stacked lists, all records are on view and I'm using Windows 7 32-bit.
I wonder if anyone can help with a slight snag? I overwrote my original Nov. 1995 build files with the 1999 build last month. My main database currently contains 7,597 records and I use the record number as an identifier. My standard procedure for 17 years has been to go to the end of the file and add a new record - simple! So, today: end of file, insert new record, but instead of being record number 7,598 of 7,598, the new record is 7,583 or 7,598. In fact, wherever I go in the file, the new record always wants to insert itself at the same location, record number 7,583. I had this happen once before in the 1990s and believe I got round the issue then by exporting all records and importing into a new database. But is there an easier option? There are no stacked lists, all records are on view and I'm using Windows 7 32-bit.