General information
Category:
Coding, syntax & commands
>A new free table is being added to an application. It will be the child of a previously existing table.
>
>The parent table unique id is made up of three fields totaling 20 characters. I'm considering adding an auto incrementing integer to the parent table to serve as link to the child table but am afraid what may happen if somehow the id sequence gets out of control and skips ahead to the maximum integer (2^32 - 1), This is a totally critical table in the application.
>
>In the experience of those here, is this a realistic fear? I would appreciate comments.
>
>TIA,
>
>Alex
Depends on how you write the application.
If you do not use DELETE to update records, you should not find problems
otherwise, you could consume 2 billion of integers with a few million records.
The max vfp integer is (2^31 - 1 ).
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only