>I am having trouble adding the first record to a table.
>
>The record is being added using a APPEND BLANK. The primary key is populated using a stored procudeure called from the default value property of the field in the DBC.
>
>Using the EXE with the runtime libraries:
>Beginning with an empty table the first record is added to the table and can be seen using browse. However SEEK() will not find the record searching on the primary key field. The second record added shows up in a browse window and is found by SEEK(). The first record is found using LOCATE FOR; and by isuing reindex and USING SEEK().
>
>
>
>Using the development environment :
>The first record is added and can be found using SEEK() and all subsequent records are added correctly.
>
>
>Why will a fox table NOT index the first record of a table?????
Superficially, sounds like a buffering issue. If you're buffering, new records will only show up in the underlying table (and be visible to SEEK, LOCATE, etc.) after you TABLEUPDATE().
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up