Can't you just use a tmp table or a Table control? A table control is a bit hard to work with though but you can display almost anything in it. Even different datatypes in the same row / column. But to make a long explanation short: I don't think you will have much success trying to bypass Axapta's way of fetching records. What Axapta shows in the form is the result of the query of the formdatasource.
The formdatasource contains a query and a queryrun. The query is identical with this.query() because this in the datasource of the form refers to FormBuildDataSource.
Hope that helped a bit.
//Lars
-----Original Message-----
From: smeagul2303 [mailto:[EMAIL PROTECTED]
Sent: 23. juli 2004 11:37
To: [EMAIL PROTECTED]
Subject: [development-axapta] Relations between QueryBuildDatasource and FormDatasource
Hi all,
I don't understand in detail how the values from a FormDatasource are
displayed from the controls.
In a standard form a query (this.query) fetches the values from the
database. In this query I don't have a FormDatasource, I have a
QueryBuildDatasource which is initalized with a tableid.
So my FormDatasource in my form is not identical with the
QueryBuildDatasource. They only point to the same Table.
But there is no object identity!
After "executeQuery" the query is executed and the resultset is
fetched from database and the controls get their values, somehow.
Do they get the values from QueryBuildDatasource ?
And how is the cursor from my FormDatasource set to the right record ?
It must be done from Query or QueryBuildDatasource !
Now I come to the reason, why :
Is there a possibility to manipulate the content from the resultset
from this.query ?
The whole framework with Query and FormDatasource is build for getting
data from database into the form. That's in nearly 99% okay.
I want to display data structured like normal tables but saved in
container to be displayed and manipulate in standard forms.
In this case I have to bypass the framework. Otherwise I can not
display the data, because my data is not in the database tables but in
in container.
The Query get no resultset, I fill the FormDatasource with the content
in the container.
How can I get thew controls to display the content from my
FormDatasources ?
Someone here who knows the framework ?
Regards
Manfred
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=1298r9qua/M=295196.4901138.6071305.3001176/D=groups/S=1705006764:HM/EXP=1090661928/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=845458627>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/ <http://groups.yahoo.com/group/development-axapta/>
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
