I have simple procedure that works both in Dataease for Dos and DEW 7.2. I have converted a customer database from 7.2 to 8.5 and get the following error.
The procedure reads:
for Subsriptions with Internet ID No. not = blank and any Customer Info E-Mail Address not = blank and Service Code not = "NOFI" ;
list records
Internet ID No. ;
Service Code ;
any Customer Info E-Mail Address .
end
export to "c:\temp\netidx.txt".
.items @f[1,1],@f[1,2],@f[1,3]
.end

When I try to save it I keep getting the following message and 8.5 program crashes EXITING DUE TO EXCEPTION: Access violation Instruction Pointer : 0x005CB492 Stack Pointer : 0x001380DC UI Build 8.50.1750 Windows Version : Unknown Windows Version One further bit of information when I take out the "and any Customer Info E-Mail Address not = blank" statement it seems to work.
All relationships are correct and this same procedure works daily in our DOS version.

Regards, Wim

Dear Wim.

When you get a GPF on something like this the problem is most likely in the underlying table, as this happens when you compile/save the DQL it is most likely in the table structure. Try to open the table in design mode, add a text field and save the table. This will regenerate the table. When you have done this, you can delete the field again and save it again.

The export part of DQL in “traditional” DFW was added as an afterthought when one discovered that the new format wouldn’t export as seamlessly (or at all) like DFD. It was never a very good or natural implementation so it has been fraught with problems. Export for

We will also exploit the occasion to show you some of the news in DE8. ExecDQL and for this occasion LabelExecDQL().

DQL is now a completely integrated part of all parts of DataEase and can be used anywhere and for everything. You can use it to manipulate form objects, data, export etc.

The included sample will use a LabelExecDQL to do the same as your DQL.

Hope this helps.

I have tried as suggested and added a text field in the table but when I try to save it as suggested it returns "Error 503 Adding Field - Missing operator in formula" . I have tried this several time but each time I get the same message. Please help. Thanks Wim

It sounds like the problem is in you exiting table. Is this a migrated or converted table?

If there is a pre-existing problem then it will typically GPF.

If it is a migrated app it can be related to , or . in numbers in derivations etc. These are things that need to sorted before migration, or one need to choose , as decimal separator for the app.

Migration is a minefield as so many different "variation" have been allowed to invade the programming in DataEase.

If the derivation is invalid, the compiled part of it will "work" after migration but it will be illegal and cause a GFP. The fact that you get an error message when you try to change the table is a good sign as that show that the derivation in one or more fields is invalid.

I'm having this same issue with error 503. I'm working in DE8.5 with a new build. ie not a migration or conversion. The table i'm working with was just created a few days ago.

Has anyone else run into this issue?

Kevin