buttersoft
Programmer
In Oracle as example you can do:-
SPOOL c:\sqldata\output.txt
SELECT * FROM ftse100 ORDER BY EPIC
;
SELECT * FROM FTSE250 ORDER BY EPIC
;
SPOOL OFF
With this you will get everything from both files into the same text file.
; is the key, that lets you run several small scripts one after the other but only ever run the one .sql file.
Can you do this in Paradox?
[sig][/sig]
SPOOL c:\sqldata\output.txt
SELECT * FROM ftse100 ORDER BY EPIC
;
SELECT * FROM FTSE250 ORDER BY EPIC
;
SPOOL OFF
With this you will get everything from both files into the same text file.
; is the key, that lets you run several small scripts one after the other but only ever run the one .sql file.
Can you do this in Paradox?
[sig][/sig]