Copy Open Dbf

[Charles Hoens]

I've looked around through the forum, but surprisingly I could not find an instance of someone having this problem. I have a networked app where people are constantly putting things into one particular dbf. Every 15 minutes or so I want a copy operation to run taking just the daily records from today and copying them to another database. Easy to do? Well, I keep getting an error on the copy operation saying that "the process cannot access the file, because it is being used by another process" which to me means that the dbf is open. I'm not sure why the copy process needs exclusive access and I haven't tried coding it outside of the operation code, but why is this so and secondly is there some sort of workaround anyone has thought of?

Many thanks!

Charlie

[Stan Mathews]

Re: Copy Open Dbf

Try this as the field rule onsaverecord event code for the table you are copying from.

dim tbl_source as P
tbl_source = table.current()
on error goto failed_to_copy
result = tbl_source.copy_record_to("tabletocopyto")
on error goto 0
end

failed_to_copy:
    ui_msg_box("Record not copied.", error_text_get(error_code_get()))
end

Your current table and the table you are currenty appending to should always be in sync.

[Tom Cone Jr]

Re: Copy Open Dbf

Stan, this may be more complicated. Won't your approach create new records in the external table each time a change is made to an existing record? Charlie hasn't given us many details. It's not clear how he handles edits to existing records. Presumably the copy op would create multiple records in the receiving table, though I'm not sure.

Charlie, it's odd to me that you're using a copy operation instead of an append. Are you creating separately named tables every 15 minutes?

-- tom

[Stan Mathews]

Re: Copy Open Dbf

Won't your approach create new records in the external table each time a change is made to an existing record?

Yep. Didn't think of that.

[Stan Mathews]

Re: Copy Open Dbf

Maybe use the result of the suggested code to add records to an intermediary table from which one would append unique, replace existing to the final table?

[Charles Hoens]

Re: Copy Open Dbf

Thanks guys! With all the coding I am doing it was just odd to run into this. As way of more information, the reason I am copying the selected information was to save time and speed up input. The copied info was placed from dbf1into dbf2 and then dbf2 was FTP'd to my VPS server. Actually I was only copying from dbf1 the records for that particular day. This helps out on the network strain and also on the size of the transmitted FTP file. And, if the FTP transfer fails, it doesn't create problems for dbf1.

But, why does the copy operation need exclusive access? Would an export operation require exclusive access?

I'll try the different solutions and let you know.

Thanks as always. You guys are the best!

Charlie