Hi there,

there is this issue with the export function.

I have a simple procedure:

for TableName ;

list records

field1 ;

field2 ;

field3 .

for RelatedTable named "tRel" with ID = TableName ID ;

list records ;

field4;

field5;

field6.

end

end

export to "c:\export.txt" .

field1~field2~field3~field4~field5~field6

.items tRel
@f[1,1]~@f[1,2]~@f[1,3]~@f[2,1]~@f[2,2]~@f[2,3]
.end

That works IF no field is a derivation. In that case you can have the video output but if you try to export them you will get a crash. So the "solution" is to copy the derivation and put it instead of the field name (e.g. field6 has a derivation "lookup AnotherTable field9" you put "any AnotherTable field9"). This is boring but it works. But in case you have to export a lot of fields and each field has a derivation and the derived fields contains reference to other derivations you go from boring to a huge waste of time. I am in that situation and to me this is not a RAD is something that is something that is slowing me down. Please fix this because is really a problem.

In my previous post I was not completely clear: the bug happens if the fields is a virtual field with a derivation.

No update on this?

This export function is Outdated and will not be fixed.

Hi and thank you for your answer; the function will be replaced by an equivalent one or there will be no way to export data?

Download Sample

Hi again.

I think our reply was a little to generic.

We have just tested export in DQL document and it works fine with Virtual fields.

So why it doesn't work with you is a "Mystery".

Might have to do with open relationships, migration or something like that.

I have included a sample that showcase the linear export the same as yours, and also how you can do it with ExecDQL.

ExecDQL can only export on ONE level, so you need to make sure you start with the lowest level and then simply "lookup" the columns from the higher level. You need to allocate them to temp variables if you want the export column name to be "legible". i.e. if you don't want any Customers Customername as the heading.

Username/Password: is high/high or you can start it directly from Startup.exe