[development-axapta] Re: List of tables which are Savedataprcompany == false

2008-09-04 Thread steffendenize
--- 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

2008-09-04 Thread jesper.joergensen
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

2008-09-04 Thread Kevin Murray
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

2008-09-04 Thread daniel.grissmann
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

2008-09-04 Thread Raf Uyttenhove
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

2008-09-04 Thread varun
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

2008-09-04 Thread hema_vicky
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