Page 1 of 1

Does CreateFields execute the query?

Posted: Mon 05 Nov 2012 10:03
by upscene
Hi,

When implicitly calling CreateFields on a TMSQuery, does that execute the query?

I need the field information, in order to create a calculated field. This is all runtime and cannot be done at designtime as the query is created during runtime.

With regards,

Martijn Tonies
Upscene Productions

Re: Does CreateFields execute the query?

Posted: Tue 06 Nov 2012 14:45
by AlexP
hello,

Since we need metainformation about fields to create them, the query will be executed to retrieve this information.

Re: Does CreateFields execute the query?

Posted: Tue 06 Nov 2012 16:06
by upscene
Hmm, not exactly what I was hoping to hear.

I'll get back to you about this.

Re: Does CreateFields execute the query?

Posted: Tue 06 Nov 2012 19:23
by upscene
You cannot add a field while the query is open, right?

Re: Does CreateFields execute the query?

Posted: Wed 07 Nov 2012 08:39
by AlexP
hello,

Yes, adding fields is possible only on a closed DataSet