>>thanks Larry - I will try this. please excuse me if this is a dup messaage.
>>Without using buffering everything is working good, but when I APPEND BLANK,
>>the record pointer to going to the last record instead of adding a blank
>>record at the end. Do you know why? thanks
>>also, once you told me how to add. You said to use up all the deleted
>>records and then append blank. In a single user system, I do not see
>>why you should use buffering at all. If the users aborts, just delete the
>>record and use it the next time the user wants to add. What to you think?
>>You can always APPEND BLANK OR INSERT INTO for adding.
>>I did try using INSERT INTO like to said, but I got a messsage saying I needed
>>to be in exclusive mood.
>>please comment :)))
>Robert,
>
>First off if you write your app as a multiuser app from the start it will not require rewriting later when it needs to become multiuser.
>
>If you got a message about exclusive use then you were using the old xBase Insert commadn and not the SQL INSERT INTO command, check the help file for syntax. If the help file says "included for backwards compatibility" then it is not the one you want.
I guess it is that I have so many options, that I have not settled..
you no what I mean...