[development-axapta] Re: List of tables which are Savedataprcompany == false
--- In development-axapta@yahoogroups.com, steffendenize [EMAIL PROTECTED] wrote: Hi all I need a list of all table which have the property - savedataprcompany to no. What is the easiest way of doing this? I've tried the noob-way: DictTable dictTable; int i; ; for(i = 1; i 500; i++) { dictTable = new Dicttable(i); if(dictTable.dataPrCompany() == noyes::No) { // print tableid2name(i); info(strfmt(%1,tableid2name(i)); } } pause; which fails (the 500 is just for testing). How do I get the result I need. Regards, Steffen Found the solution to my problem: static void Job15(Args _args) { DictTable DictTable; UtilIdElements UtilIdElements; while select UtilIdElements group by id where UtilIdElements.recordType == UtilElementType::Table { DictTable = new DictTable(UtilIdElements.Id); if(DictTable.dataprcompany() == NoYes::No) { info(strfmt(%1 %2, UtilIdElements.Id, tableId2Name(UtilIdElements.Id))); } } // sry for bad formatting
AW: [development-axapta] List of tables which are Savedataprcompany == false
HI You are close to the result. You can't assume, that the counter has the same value as the table id... Try this. I have excluded the maps, views, tmptables, and the system tables as well. static void findGlobalTables(Args _args) { Dictionary Dictionary; sysDictTabledictTable; Counter tableCounter; ; Dictionary = new Dictionary(); for (tableCounter = 1; tableCounter = Dictionary.tableCnt(); tableCounter++) { dictTable = new SysDictTable(Dictionary.tableCnt2Id(tableCounter)); if (dictTable.dataPrCompany() == false !dictTable.isView() !dictTable.isMap() !dictTable.isSystemTable() !dictTable.isTmp()) info(dictTable.name()); } } Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] blocked::blocked::blocked::mailto:[EMAIL PROTECTED] Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.biz blocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von steffendenize Gesendet: Freitag, 29. August 2008 15:09 An: development-axapta@yahoogroups.com Betreff: [development-axapta] List of tables which are Savedataprcompany == false Hi all I need a list of all table which have the property - savedataprcompany to no. What is the easiest way of doing this? I've tried the noob-way: DictTable dictTable; int i; ; for(i = 1; i 500; i++) { dictTable = new Dicttable(i); if(dictTable.dataPrCompany() == noyes::No) { // print tableid2name(i); info(strfmt(%1,tableid2name(i)); } } pause; which fails (the 500 is just for testing). How do I get the result I need. Regards, Steffen [Non-text portions of this message have been removed]
[development-axapta] how to find data refresh date in system
Hello, How can I find the date of last refresh in a particular AX instance? Thanks, K [Non-text portions of this message have been removed]
[development-axapta] error on EP server
Hi, sometimes the ep is not working anymore. The error message from the event log is the following: Ereignistyp:Fehler Ereignisquelle: Dynamics .NET Business Connector 4.0 Ereigniskategorie: Keine Ereigniskennung: 110 Datum:03.09.2008 Zeit: 11:47:16 Benutzer: Nicht zutreffend Computer: PORTAL Beschreibung: Microsoft Dynamics Business Connector Session 61. Thread was being aborted. at ServerNext(Void* , UInt16 , Int32 , Int32 , Int32 , UInt32 , Byte* , UInt32* , Byte** , Byte* , UInt16* , __MIDL_AxaptaRPC_0005* ) at callServerNext(Void* IDL_handle, UInt16 sessionID, Int32 randomID, Int32 remostStack, Int32 extendedFetch, UInt32 cursorSize, Byte* cursorData, UInt32* replySize, Byte** replyData, Byte* ipException, UInt16* levelRLS, __MIDL_AxaptaRPC_0005* psrvinfServerInfo) at Srv_next(cqlCursor* cursor, interpret* ip, Int32 extendedFetch, Int32* cacheAppended) at cqlCursor.__next(cqlCursor* , interpret* ip, Int32 extendedFetch, Int32* cacheAppended) at cqlCursor._next(cqlCursor* , interpret* ip, Int32 extendedFetch, Int32* cacheAppended) at cqlCursor.next(cqlCursor* , interpret* ip) at qeRunClass.kcNext(qeRunClass* , interpret* ) at interpret.doInternalEval(interpret* , Char* inputStr, cqlClass* cinfo, xKernelClass* kernelObject, UInt16 chndl) at interpret.evalFunc(interpret* , Char* src, Byte isKernelClass, Byte runFlags, UInt16 chdl, Byte mode, Byte origmode, cqlClass* cinfo, xRPNList* rl) at interpret.xal_eval_func(interpret* , Byte mode, UInt16 chdl, xRPNList* rl, Char* src) at reportRunKernelClass.kcFetchInternal(reportRunKernelClass* , interpret* ip, cqlClass* runQuery, cqlClass* buildQuery, UInt32* records) at reportRunKernelClass.kcFetch(reportRunKernelClass* , interpret* ) at interpret.doInternalEval(interpret* , Char* inputStr, cqlClass* cinfo, xKernelClass* kernelObject, UInt16 chndl) at interpret.evalFunc(interpret* , Char* src, Byte isKernelClass, Byte runFlags, UInt16 chdl, Byte mode, Byte origmode, cqlClass* cinfo, xRPNList* rl) at interpret.xal_eval_func(interpret* , Byte mode, UInt16 chdl, xRPNList* rl, Char* src) at reportRunKernelClass.kcRun(reportRunKernelClass* , interpret* ) at interpret.doInternalEval(interpret* , Char* inputStr, cqlClass* cinfo, xKernelClass* kernelObject, UInt16 chndl) at interpret.evalFunc(interpret* , Char* src, Byte isKernelClass, Byte runFlags, UInt16 chdl, Byte mode, Byte origmode, cqlClass* cinfo, xRPNList* rl) at interpret.xal_eval_func(interpret* , Byte mode, UInt16 chdl, xRPNList* rl, Char* src) at interpret.xal_eval_id(interpret* ) at interpret.evalloop(interpret* ) at interpret.evalLoop(interpret* ) at interpret.eval(interpret* ) at interpret.CQLEvalProc(interpret* , Byte* rpncs, Int32 noelem, Byte varallocated, Int32 mode, UInt16* fctoff, UInt16 cur_class, Char* modulename, xRPNList* rl) at interpret.doEval(interpret* , Char* inputStr, Byte mode, UInt16* fctoff, cqlClass* cinfo, Byte runFlags, xRPNList* rl) at interpret.evalFunc(interpret* , Char* src, Byte isKernelClass, Byte runFlags, UInt16 chdl, Byte mode, Byte origmode, cqlClass* cinfo, xRPNList* rl) at interpret.xal_eval_func(interpret* , Byte mode, UInt16 chdl, xRPNList* rl, Char* src) at interpret.xal_eval_id(interpret* ) at interpret.evalloop(interpret* ) at interpret.evalLoop(interpret* ) at interpret.eval(interpret* ) at interpret.CQLEvalProc(interpret* , Byte* rpncs, Int32 noelem, Byte varallocated, Int32 mode, UInt16* fctoff, UInt16 cur_class, Char* modulename, xRPNList* rl) at interpret.doEval(interpret* , Char* inputStr, Byte mode, UInt16* fctoff, cqlClass* cinfo, Byte runFlags, xRPNList* rl) at interpret.evalFunc(interpret* , Char* src, Byte isKernelClass, Byte runFlags, UInt16 chdl, Byte mode, Byte origmode, cqlClass* cinfo, xRPNList* rl) at interpret.xal_eval_func(interpret* , Byte mode, UInt16 chdl, xRPNList* rl, Char* src) at interpret.xal_eval_id(interpret* ) at interpret.evalloop(interpret* ) at interpret.evalLoop(interpret* ) at interpret.eval(interpret* ) at interpret.CQLEvalProc(interpret* , Byte* rpncs, Int32 noelem, Byte varallocated, Int32 mode, UInt16* fctoff, UInt16 cur_class, Char* modulename, xRPNList* rl) at interpret.doEval(interpret* , Char* inputStr, Byte mode, UInt16* fctoff, cqlClass* cinfo, Byte runFlags, xRPNList* rl) at interpret.evalFunc(interpret* , Char* src, Byte isKernelClass, Byte runFlags, UInt16 chdl, Byte mode, Byte origmode, cqlClass* cinfo, xRPNList* rl) at interpret.xal_eval_func(interpret* , Byte mode, UInt16 chdl, xRPNList* rl, Char* src) at interpret.xal_eval_id(interpret* ) at interpret.evalloop(interpret* ) at interpret.evalLoop(interpret* ) at interpret.xal_switch_sym(interpret* ) at interpret.evalloop(interpret* ) at interpret.evalLoop(interpret* ) at interpret.eval(interpret* ) at
[development-axapta] Re:List of tables which are Savedataprcompany == false
Hi Steffen, I think you are looking for this: (just paste it in a job) #AOT #Properties TreeNodetable; TreeNodetables = TreeNode::findNode(#TablesPath); TreeNodeIteratoriterator; Str 3 saveDataPerCompany; Counter i; int start, stop; ; start = TimeNow(); //Set the iterator to the tables path iterator = tables.AOTiterator(); //get the first table table = iterator.next(); setprefix('Tables which have set Save Data Per Company to No'); while(table) { //While tables can be found, check their 'SaveDataPerCompany' property saveDataPerCompany = table.AOTgetProperty(#PropertySavedatapercompany); //If it is set to 'No', list it in the infolog if(saveDataPerCompany == 'No') { info(table.AOTname()); i++; } else print table.AOTname(); //Get the next table table = iterator.next(); } stop = TimeNow(); setPrefix('Result:'); info(strfmt(Runtime: %1 , time2str(stop - start, 1, 1))); info(strfmt('Found %1 tables', i)); Kind regards, R. Raf Uyttenhove Quadreon NV - AMCC Technologiepark 1 B-9052 Ghent-Zwijnaarde Phone +32 9 245 96 73 Fax+32 9 220 50 19 [EMAIL PROTECTED] http://www.amcc.be This email and any attached files are confidential and may be legally privileged. If you are not the intended recipient, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited. If you have received this transmission in error please accept our apologies, notify the sender immediately and delete this mail together with all attachments that may have been added. [Non-text portions of this message have been removed]
[development-axapta] Online payment transaction
Hi, We are currently working on an Enterprise Portal Project that will involve online payments using Credit cards. We would like to know the process that goes into using such modes of online payments and any documents on the same, if available. We would also like to know if any of our fellow members have worked on similar projects and how this was incorporated into the portal. Thanks in advance Thanks and Regards Varun Mohan
[development-axapta] Need MB6-508 sample questions
Hi friends, If anyone has sample questions or dump for Ax 4.0 development certification (MB6-508), pls. send me to my mail id. Thank you. Regs, Hema. S