Easy to Create, Easy to Change - Easy to use!


Error when exporting data ot a txt-file


Started by Per Bruvold
Search
You will need to Sign In to be able to add or comment on the forum!

Error when exporting data ot a txt-file

Hi

use De8.2.1700, Windows 7. Get error when exporting to txt-file (Norwegian):

Programnavn med feil: DataEase.exe, versjon: 8.2.0.1700, tidsangivelse: 0x547736fa (feil=error, tidsangivelse=dating))

Modulnavn med feil: deobject.dll, versjon: 8.2.0.1700, tidsangivelse: 0x547736ea (Modulnavn= module name)

Unntakskode: 0xc0000409 (Unntakskode:=exception code)

Feilforskyvning: 0x0007bd3e (Feilforskyvning= error change)

Feil prosess-ID: 0xb40

Feil starttid for program: 0x01d14a1610de94b0

Feil programbane: C:\Program Files (x86)\DataEase\DataEase 8.2\DataEase.exe

Feil modulbane: C:\Program Files (x86)\DataEase\DataEase 8.2\deobject.dll

Rapport-ID: 611b13ce-b609-11e5-bf40-1803734d9566

Written by Per Bruvold 08/01/16 at 13:16:44

Re:Error when exporting data ot a txt-file

Sadly, this doesn't tell us anything as it is GPF and it is WIndows reporting the location.

What did you try to do i.e. what function did you use?

Did you export from a DQL, From a form, did you use ExecDQL or did you use ExportData()?

Generally  - this is not personal ;-) nobody can help without a clear explanation of what one was doing, and even better if one can include a sample that show what went wrong.

"It stopped working" or "It doesn't work" is of course right but it doesn't give any diagnostic  information.

You are of course excused here as this looks like a meaningful error message when in reality it is just gibberish ;-)

Written by DataEase 08/01/16 at 14:31:52

Re:Re:Error when exporting data ot a txt-file

Sorry I didn't explained enough, but here is what I do:

I'm running DQL from a form. It shows up i window (print detail: Text, Report form expansion: Expand layout, Copies: 1, Range: All records, page from 1 to 9999)  When cliking OK I can see all records in the window. From this window i choose file-export-variable length text (Windows ANSI)- give a export file name like: test.txt With include Fields name, file seperator ~ and New line as record seperator. Clicking OK result no error and it seem to work ok, but when I open the txt-file, the records between 161 and 349 is missing missing. I can't find it out (it's really a simpel DQL With export to a texfile...)hmm. Any idea?

Written by Per Bruvold 11/01/16 at 11:40:21

Re:Re:Re:Error when exporting data ot a txt-file

Why this happens is hard to say without seeing the application.

Is it the last records that are missing or is it in the middle?

We tested this (in 8.5 however, but shouldn't really have changed) and it worked fine.

However, there is now a much better way to do this by using ExecDQL.

To test it you can simply paste your DQL as a label into a Form, and then use LabelExecDQL to execute it.

http://www.dataease.com/dg3_HelpView/?PageID=13728...

The default setting for execDQL is to export with ~ and fieldnames in first record.

In later versions (8.5) you can build your own body/format.

This method is much safer, faster and 100% automated.

Written by DataEase 11/01/16 at 13:48:34 Dataease [{8}]FIVE