I am attempting to create a comma delimited file from a Paradox 7 table, but whenever I use the following code, I get a General Protection Error:

method pushButton(var eventInfo Event)
var
dt DataTransfer
endVar

dt.setSource("upload_e1.db")
dt.setDest("Upload_e123456.txt", DTAsciiVar)
dt.setDestFieldNamesFromFirst(True)

dt.setDestDelimiter("'")
dt.setDestDelimitedFields(DTDelimJustText)

dt.setDestSeparator(",")

dt.setDestCharSet(DTAnsi)

dt.TransferData()
endMethod

The line that seems to be causing the problem is dt.setDestFieldNamesFromFirst(True), but I am not sure why.

I need to have the column headings in the text file so that it can be uploaded into another program.

Any suggestions would be greatly appreciated.

Thanks,
pbare

If this is a one-time requirement then you can simply export the table without writing any ObjectPAL...

Unfortunately, it is not just a one time thing - the users require the ability to do this feature at least once a week.

pbare

Why dont' you simply create the comma delimited file by yourself?

One scan on a tcursor on the table, containing a for cycle on the fields (or, if the table is always the same one, a field by field write on the text file) should do the trick, without relying on a function that does indeed crash your Paradox...