General information
Category:
Forms & Form designer
Hi Randy,
I would have the table order by an index key (primary key, perhaps) that are incremented by 100's or 1000's, depending on your needs. Then if user wants to add a record you just need to append to the bottom of the table (doesn't matter where the record physically goes). Then assign a key/index value that would be between the key/index values of the two records in question then refresh the form.
Just off the top of my head. Hope it helps.
Aloha,
James
>Hi. I am doing an invoicing program and my end-users want to add a row in the middle of the grid.
>I considered this:
>1. Copy the rest of the records in the dbf to an array
>2. Delete those same records from the dbf
>3. Append a blank record
>4. Bring the records back in from the array
>Of course, user would have to have exclusive use of the file.
>
>Q; is there an easier method? If not, what commands would I use to copy to / append records from an array?
>
>Thanks, Randy
Previous
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