The "Load from" command places a table lock. So you might have to do it using a different command.
I use the following to import my ups tracking data: 1. PROJECT TEMPORARY tablename from upstracking using * where limit = 0 2. GATEWAY IMPORT CSV daily.csv REPLACE tablename 3. append tablename to upstracking upstracking is my destination table. tablename is the temporary table to hold the imported data. You might have to change from CSV to something else depending on what kind of ascii format. You can check R:syntax for details on these commands. Dan Goldberg -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 1:30 PM To: RBASE-L Mailing List Subject: [RBASE-L] - loading ascci files Firts of all, tx for all your answers on my question about locks in R:Base. This question is on the same way, because I read my code with your suggesttions but I think my problem come from another think. Firts I explain my situation: The apx files are compiled in Rbase 6.5 ++ and executed with Rtime unlimited. We are using a NT server/ W2000 and 10 PC's workstations with W98. During the normal work all are good, the problems we have with the "nigth process" this process collect invoices, process orders, stadistics and so on. We collect invoices from our PDA (about 300 PDA #invoices around 5000 per day). The data comes in ascci files and we use instruccions like LOAD &tdv FROM &vout4 to do it, where &tdv is a different temporary table for each sales office (up to 10) we process that using 4 PC's, each PC process one different sales office at time. Like all is using differents tables my only point that I think maybe it's the cause of the message "waiting to access to a required resource 25%" and keeps until I push cancel button is the LOAD instruccion. Maybe there's a limit to simultaneous LOAD (ascii files)? and haw can I solve that? Best regards, Ramon Guardiola fermatic Three system
