On Sat, 17 Dec 2005 at 11:36:03, Timothy Swenson wrote:
(ref: <[EMAIL PROTECTED]>)
>On Sat, 17 Dec 2005 16:08:02 +0100, Marcel Kilgus
><[EMAIL PROTECTED]> wrote:
>
>> Question 2:
>> | How to retrieve data (from Archive for instance) to convert from QL to
>> | textfile under WinXP
>
>Like it was said earlier, use the export command for Abacus. I think
>Archive has an export command too. If it does not, then put use print
>statements to get the data out in a format like this:
It does:
export 'filename' as 'filename'
produces a quote delimited file.
First line is field names, and subsequent are data.
You can also list fields to be exported.
The major snag with this is that archive allows double quote in data.
This will produce invalid export files.
I always convert " to ' when entering data.
One must write a procedure to change all double quotes to single quotes.
Tony
--
QBBS (QL fido BBS 2:252/67) +44(0)1442-828255
tony@<surname>.co.uk http://firshman.co.uk
Voice: +44(0)1442-828254 Fax: +44(0)1442-828255 Skype: tonyfirshman
TF Services, 29 Longfield Road, TRING, Herts, HP23 4DG
_______________________________________________
QL-Users Mailing List
http://www.q-v-d.demon.co.uk/smsqe.htm
