Re: [development-axapta] how to save query in a tmp table
you can you a real already existing table too without storing the results in
database.
For that declare a table variable of the wanted table and set this xRecord
cursor in temp mode using method .setTmp()
Now you have a temporray table with exactly the same layout as the original
in database.
e.g.:
InventTable tmpInventTable;
;
...
...
tmpInventTable.SetTmp(); // that's the important call
If you now issue an select * on that xrecord you'll see that the table is
empty.
Now you can use this table (you always have to use the above variable) to
insert records in it. (maybe looping through your query)
As with real temporary tables (property temporary = YES), this cursor is
cleared (temporary table deletetd) if running out of scope - normally at end
of the method - if it isn't referenced elsewhere.
To overcome this logic you have to pass the variable to another object (e.g.
a reportrun) using a public setmethod SetTmpRef(InventTable tmpRef) on that
report. (don't forget to downcast the reportrun variable to a simple
object - otherwise you'll get an compile error)
Within the called ReportRun (where InventTable is defined within the query
datasources) you have to instruct the report NOT to use the real Inventtable
for the selects but the passed temporary one - using
reportrun.QueryRun().SetCursor(your tmpVar)
Now the report goes to your temporary inventtable
Keep in mind: All triggers of the table (insert, update, delete should be
programmed secure - like if (this.IsTmp()) {} if they are going to modify
/ insert/update/delete records in other real tables) otherwise you'll get
strange data efects.
regards and cu at the restaurant at the end of universe
Douglas
- Original Message -
From: Steeve Gilbert [EMAIL PROTECTED]
To: development-axapta@yahoogroups.com
Sent: Wednesday, July 06, 2005 9:06 PM
Subject: RE : [development-axapta] how to save query in a tmp table
The only way I can see is actually creating the temp table (Property
Temporary = Yes) and filling it by browsing the entire query. From there
you can play with the temp table.
Steeve...
-Message d'origine-
De : development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] De la part de hilda cabrejos
Envoyé : 6 juillet 2005 12:38
À : development-axapta@yahoogroups.com
Objet : [development-axapta] how to save query in a tmp table
Hello everybody
Can anyone tell me how to save a query in a tmp table?
Can I run a quey and save the result in a table so I can work on the result,
for example a report?
Thank you
Hilda Cabrejos
-
Sell on Yahoo! Auctions - No fees. Bid on great items.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
Yahoo! Groups Links
YAHOO! GROUPS LINKS
Visit your group "development-axapta" on the web.
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] connect to AOS
Hello everybody Can anyone tell me what this option is for in the client tab of the configuration? Thank you Hilda - Sell on Yahoo! Auctions - No fees. Bid on great items. [Non-text portions of this message have been removed] YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [development-axapta] Carriage return for imports
hi I think I used alt+enter (provided you are using a spreadsheet for import) regards harry leganchris [EMAIL PROTECTED] wrote: What is the symbol used for putting in a carriage return in Axapta? I am importing in a VendTable and the addresses are 3 lines long. SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange - YAHOO! GROUPS LINKS Visit your group development-axapta on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Sell on Yahoo! Auctions - No fees. Bid on great items. [Non-text portions of this message have been removed] YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [development-axapta] Range criteria on InventTrans
you should realise any trans can only ahve status in either issue or receipt but you are basically telling the report to find trans that has value in both (i.e. criteri are AND together) basically you will need to run the report 2 times I think -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hemant Sent: 07 July 2005 13:33 To: development-axapta@yahoogroups.com Subject: [development-axapta] Range criteria on InventTrans Hi There, I created a Auto Report and I want to select only transaction where the StatusIssue has Issue type of Sold or Deducted and I also want to select transaction where StatusReceipt has Receipt type of Purchased or Received, but when I use these in the Query screen , the report doesn't print, I know because of the criteria, since I tried giving only one criteria each in Status Issue and receipt I am able to see the information on the report. I would appreciate your suggestions. In the Query Status Issue = Sold, Deducted Status Receipt = Purchased, Received Since the condition is getting compunded I think the report is coming out empty. SPONSORED LINKS Computer http://groups.yahoo.com/gads?t=msk=Computer+partw1=Computer+partw2=Progr amming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yLpvc LTIDJ5FTkRJGsO11w part Programming http://groups.yahoo.com/gads?t=msk=Programming+languagesw1=Computer+part w2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.s ig=cuhEClK4dU4wapXFmKisbQ languages Microsoft http://groups.yahoo.com/gads?t=msk=Microsoft+axaptaw1=Computer+partw2=Pr ogramming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yf eG_U6QaLfPOZZIud02Fg axapta Support http://groups.yahoo.com/gads?t=msk=Support+exchangew1=Computer+partw2=Pr ogramming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=hy 8yRGMzrmxdphyITTUeqA exchange _ YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * 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 LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Accessing report functions from query
Hi all, I have trouble when accessing report function from init function of Query of report. For ex, in the init method of query : str reportRange = element.parmRange(); How can i access it? Thanks for now.. Anil Ozay Software Engineer, MBSCP, MCP Anadolu Bilisim A.S. [Non-text portions of this message have been removed] YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Recid
Is there a table in the AOT that controls the assignment of recid throughout all the tables? YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Ant: SV: [development-axapta] how to save query in a tmp table
Hi, why don't you work with a RecordSortedList ? John Dahlsgaard Jan [EMAIL PROTECTED] schrieb: Maybe you can use a view Fra: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] På vegne af hilda cabrejos Sendt: 6. juli 2005 18:38 Til: development-axapta@yahoogroups.com Emne: [development-axapta] how to save query in a tmp table Hello everybody Can anyone tell me how to save a query in a tmp table? Can I run a quey and save the result in a table so I can work on the result, for example a report? Thank you Hilda Cabrejos - Sell on Yahoo! Auctions - No fees. Bid on great items. [Non-text portions of this message have been removed] YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * 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 LINKS Visit your group development-axapta on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - H.W. Bous - Gesendet von Yahoo! Mail - Jetzt mit 1GB kostenlosem Speicher [Non-text portions of this message have been removed] SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] axapta integration to third party document management system
hi out there! Currently I am trying to find a solution for a full integration to a third party document management system: central working point: where to grab print jobs done by axapta users for archivation purpose - even copies. correlation to respective tableheader: to achieve proper archivation - tableheader information is essential for creating keywords What i did so far: 1. I figured out the ReportOutputUser-class: here my intention was to split up one PrintJob in two - but there I could not gather tableheader information. 2. secondly I tried to use the integrated document handling for gathering header information and the binary data storage in printJobPages Table to store the data in a file trying to guess the extention (.tif, .ps, .pdf, ?) but it became desperate. 3.SysReportRun: every printjob passes this class, how can I get the headerinfo of each report an its output? I appreciate gathering a bit of help from someone who has an idea or was already in that matter. Regards, hOObsy YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
