
Error when exporting data ot a txt-file
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
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 ;-)
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?
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.