There is indeed a variable ScriptError (further documentation on its codes in the Reference Manual) that you can use in an If conditional in your script:
// Ignore errors and keep executing the next line SET ErrorMode = 0; [...] // Script here STORE Table INTO File.qvd (qvd); // First attempt // If everthing went fine, the following will only iterate 5 taking very few time FOR vAttemptNo = 1 TO 5 // Number of attempts IF ScriptError = 1 THEN SLEEP 10000; // 10 secs EXIT SCRIPT WHEN $(vAttemptNo) => 5; STORE Table INTO File.qvd (qvd); // another attempt ENDIF NEXT
I haven't tested the code, so I have missed something.
Hope that helps.
Hi Stephen, originally that's how it worked and your right with the * wildcard when loading they'll concat simply..... think I'm a bit OCD really and prefer to remedy the problem and keep a single logfile rather than going back to loads (and I have a lot of QVWs and growing). Cheers for the repsonse though. Rich