Re: [Axapta-Knowledge-Village] Temporary table

2005-02-18 Thread Ashi Singh





Hi Steeve,
 
Once again i am troubling you. But as a Novice to be in Axapta it is a Normal scenarion.
to be alaways in Fix.
 
friend as i told you earlier mine problem with movement of Cursor of temporary table .
I got a idea from your mail which you have posted.
 
One of your mail response in which you have asked with help of a job that why it's not showing 123123 and showing instead just 123 
Then i was thinking that why i should not use the same method in my case that is 
 
 query_A=new Query(); query_A=element.args().parmObject(); //  objSOA_Ash = element.args().parmObject();    objSOA_Ash=element.args().caller().getclassobj();
    tmpCustTrans=element.args().caller().gettabledata();    tmpCustTrans1.setTmpData(tmpCustTrans);    offCustTrans.setTmpData(tmpcustTrans);
   //tmpCustTrans1=element.args().caller().gettabledata1();//    offCustTrans=element.args().caller().gettabledata2();//  tmpCustTrans=hello.args().record().dataSource();
 
Share your views but outrightly the one thing that i am seeing is that during scrolling like
 
    while select tmpcusttrans index hint AccountDateIdx    where tmpCustTrans.tmpsreDRNo  == SalesTable.SalesId    {    while select tmpcusttrans1 index hint AccountDateIdx    where tmpcusttrans1.tmpRecID==tmpcusttrans.tmpRecID    {    print tmpcusttrans.tmpRecID;    print tmpcusttrans1.tmpRecID;    }    } 
 
may have some problem, enrich me with your views .
 
Loooking ahead for your views.
 
Till then bye.
Steeve Gilbert <[EMAIL PROTECTED]> wrote:





(See job below)
 
I though I would see in the infolog "1,2,3,1,2,3" but that is not he case, I see "1,2,3".  It seems like p1 and p2 use the same cursor for temporary table.  Is it possible to browse the same temporary table with different cursor?
 
Steeve…
 
static void Job1(Args _args){
    TmpSum tmpSum, p1, p2;
    ;
    tmpSum.Key = "1";
    tmpSum.insert();
    tmpSum.Key = "2";
    tmpSum.insert();
    tmpSum.Key = "3";
    tmpSum.insert();
 
    p1 = tmpSum;
    p2 = tmpSum;
 
    select p1;
    select p2;
 
    while (p1) {
    info(p1.Key);
    next p1;
    }
 
    while (p2) {
    info(p2.Key);
    next p2;
    }
 
}
 


Steeve... 
 Sharing the knowledge on Axapta. 
		Do you Yahoo!? 
Yahoo! Search presents - Jib Jab's 'Second Term'


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
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: [Axapta-Knowledge-Village] Temporary table

2005-02-18 Thread Ashi Singh




Hi Steeve,
 
Once again i am troubling you. But as a Novice to be in Axapta it is a Normal scenarion.
to be alaways in Fix.
 
friend as i told you earlier mine problem with movement of Cursor of temporary table .
I got a idea from your mail which you have posted.
 
One of your mail response in which you have asked with help of a job that why it's not showing 123123 and showing instead just 123 
Then i was thinking that why i should not use the same method in my case that is 
 
 query_A=new Query(); query_A=element.args().parmObject(); //  objSOA_Ash = element.args().parmObject();    objSOA_Ash=element.args().caller().getclassobj();
    tmpCustTrans=element.args().caller().gettabledata();    tmpCustTrans1.setTmpData(tmpCustTrans);    offCustTrans.setTmpData(tmpcustTrans);
   //tmpCustTrans1=element.args().caller().gettabledata1();//    offCustTrans=element.args().caller().gettabledata2();//  tmpCustTrans=hello.args().record().dataSource();
 
Share your views but outrightly the one thing that i am seeing is that during scrolling like
 
    while select tmpcusttrans index hint AccountDateIdx    where tmpCustTrans.tmpsreDRNo  == SalesTable.SalesId    {    while select tmpcusttrans1 index hint AccountDateIdx    where tmpcusttrans1.tmpRecID==tmpcusttrans.tmpRecID    {    print tmpcusttrans.tmpRecID;    print tmpcusttrans1.tmpRecID;    }    } 
 
may have some problem, enrich me with your views .
 
Loooking ahead for your views.
 
Till then bye.
Steeve Gilbert <[EMAIL PROTECTED]> wrote:





(See job below)
 
I though I would see in the infolog "1,2,3,1,2,3" but that is not he case, I see "1,2,3".  It seems like p1 and p2 use the same cursor for temporary table.  Is it possible to browse the same temporary table with different cursor?
 
Steeve…
 
static void Job1(Args _args){
    TmpSum tmpSum, p1, p2;
    ;
    tmpSum.Key = "1";
    tmpSum.insert();
    tmpSum.Key = "2";
    tmpSum.insert();
    tmpSum.Key = "3";
    tmpSum.insert();
 
    p1 = tmpSum;
    p2 = tmpSum;
 
    select p1;
    select p2;
 
    while (p1) {
    info(p1.Key);
    next p1;
    }
 
    while (p2) {
    info(p2.Key);
    next p2;
    }
 
}
 


Steeve... 
 Sharing the knowledge on Axapta. 
		Do you Yahoo!? 
Yahoo! Search presents - Jib Jab's 'Second Term'


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.










[Axapta-Knowledge-Village] Sales Targets

2005-02-18 Thread vshan12_rao


Hi,
   Is there a facility to set salesman targets in Axapta?

vrao





 Yahoo! Groups Sponsor ~--> 
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 





[Axapta-Knowledge-Village] Re: Connection TImes Out - High Priority

2005-02-18 Thread Ramakrishnan


hi,

Create stored procedure in database with arguments and try this. I 
had tried this and working fine without any problem.

static void CallStoredProcedure(Args _args)
{
LoginProperty   loginproperty = new LoginProperty();
OdbcConnection  sqlcon;
Statement   stmt;
;
loginproperty.setDSN('TESTDSN');
sqlcon = new  OdbcConnection(LoginProperty);
stmt = sqlcon.createStatement();

stmt.executeUpdate('Execute testProc 4');

}

I hope this works out.

Ramki.


--- In Axapta-Knowledge-Village@yahoogroups.com, Subrahmanyam Mamidi 
<[EMAIL PROTECTED]> wrote:
> Hi ,
>  
> We are experienceing the following Problem..
> We are executing a store procedure from within Axapta on the 
Database. The procedure kicks but terminates halve way through (it 
creates halve of the records). We have tested this with various 
database store procedures (simple and complex) and all seems to run 
into the same problem. If executed directly on the Database (not from 
Axapta) the procedures run 100% correct.
> 
>  It seems as if the Axapta connection `times out' after a
few 
seconds.
> 
> // The job Is As Follows.
> 
> static void ***_StoredProc(Args _args)
> {
> Connection  Con;
> Statement   Stmt;
> 
> Con  = new Connection();
> Stmt   = connection.createStatement();
>  
> Stmt.executeUpdate(`Stroed Procedure');
> 
>  Stmt.commit();
> 
> 
> }
> 
> Can someone help me out in this regards?.
> 
> Many Thanks,
> 
> Subbu
> 
> SDBC
> 
> 
>   
> -
> Do you Yahoo!?
>  Yahoo! Search presents - Jib Jab's 'Second Term'





 Yahoo! Groups Sponsor ~--> 
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 





[Axapta-Knowledge-Village] How to join data fetched from temporary table

2005-02-18 Thread compashi


Hai Guys,

I am facing some terrible problem .
Mine problem is that with the help of class i have populated certain 
data on to a Form. Now i am putting some checkboxes that are part of 
my temporary table whose status is important to me for creating a 
report. The report i am calling from from Form Menu Item Button and i 
am able to get the temporary table data in the init method of report
but i have no requirement to use my temporary table data to be used
directly in the report so i have not used it as a DataSource in my 
Report.

Now the problem that i am facing is that because of certain situations
i have to use statement like 

While select tempTable
{
  While select tempTable// some conditions for joining both
  {
  // some processing is done here

   }
}
But as soon as it reaches the end of the second while select{ }
a message appears which says that such a join operation is not 
possible .

Please help me out is there any way around to get rid of this problem 
and i can use my temporary table just a Normal table and is able to 
perform all the desired looping as Normal.


Help me out Guys.

Have a good day Bye
 






 Yahoo! Groups Sponsor ~--> 
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 





Re: [Axapta-Knowledge-Village] Temporary table

2005-02-18 Thread Varden Morris




Hi
 
After populating tmpSum you do the following:
 
p1.setTmpData(tmpSum);
p2.setTmpData(tmpSum);
That should do he trick.
Varden
Steeve Gilbert <[EMAIL PROTECTED]> wrote:





(See job below)
 
I though I would see in the infolog "1,2,3,1,2,3" but that is not he case, I see "1,2,3".  It seems like p1 and p2 use the same cursor for temporary table.  Is it possible to browse the same temporary table with different cursor?
 
Steeve…
 
static void Job1(Args _args){
    TmpSum tmpSum, p1, p2;
    ;
    tmpSum.Key = "1";
    tmpSum.insert();
    tmpSum.Key = "2";
    tmpSum.insert();
    tmpSum.Key = "3";
    tmpSum.insert();
 
    p1 = tmpSum;
    p2 = tmpSum;
 
    select p1;
    select p2;
 
    while (p1) {
    info(p1.Key);
    next p1;
    }
 
    while (p2) {
    info(p2.Key);
    next p2;
    }
 
}
 


Steeve... 
 Sharing the knowledge on Axapta. 
		Do you Yahoo!? 
Yahoo! Search presents - Jib Jab's 'Second Term'


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.










[Axapta-Knowledge-Village] Finding Ledger Accounts on Purchase Lines

2005-02-18 Thread frodnew57


We are trying to generate a report for our users that provides 
details on the vendor invoice detail behind the charges to their 
ledger accounts.  But we are finding that many of the lines on the 
vendor invoice trans table and purchase line table do not have ledger 
accounts.  Apparently when the system pulls the ledger account from 
the item group table it does not populate the above files with that 
ledger information.  Is there another place where this information 
resides??

Any suggestions?

Bruce





 Yahoo! Groups Sponsor ~--> 
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 





[Axapta-Knowledge-Village] Temporary table

2005-02-18 Thread Steeve Gilbert











(See job below)

 

I though I would see in the infolog "1,2,3,1,2,3"
but that is not he case, I see "1,2,3".  It seems like p1 and p2
use the same cursor for temporary table.  Is it possible to browse the
same temporary table with different cursor?

 

Steeve…

 

static void Job1(Args _args){

    TmpSum tmpSum, p1, p2;

    ;

    tmpSum.Key = "1";

    tmpSum.insert();

    tmpSum.Key = "2";

    tmpSum.insert();

    tmpSum.Key =
"3";

    tmpSum.insert();

 

    p1 = tmpSum;

    p2 = tmpSum;

 

    select p1;

    select p2;

 

    while (p1) {

    info(p1.Key);

    next p1;

    }

 

    while (p2) {

    info(p2.Key);

    next p2;

    }

 

}

 





Steeve...






 






Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
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: RE : [Axapta-Knowledge-Village] Re: Negative recid

2005-02-18 Thread Jim Jo




I guess we had the same hot discussion topic some time back on dev axapta group or this group itself ?? !!! 
 
 ... at that point where the recid saturates , some table relations that use recid as key may start working wierd !!!  end result of it is .. some reports and forms will not show the correct data that it supposed to show !!
 
 anyways thats not a big issue as there is always a solution for every problem !! 
 
 you can always delete a lot of processed orders and delete some historical transactions that  
 are not relevent !. or back up historical data, delete the data from axapta and free up a bunch of recid's !! 
I guess MBS should also be aware of this issue and must come over it in the next release !!
 
I always wondered why Axapta does not come with a periodic job with which we could back up 
processed transactions by period .. I really expected this tool with every release .. but never came out !! may be with the next release :-) .. hope so ... I would really like to have a periodic function with which I could archive all processed transactions with a period option !  This will really solve recid problem also .. i have seen these options in BAAN expecially .I guess all good ERP packages have this ...but Axapta must have this atleast in the next release !!!  
jus my thoughts ook ...
 may be buddies around here would comeup with better ideas or may be someone might already have a job to do this !!! 
 
Chrs !
 
ABIN.Steeve Gilbert <[EMAIL PROTECTED]> wrote:
I'm really curious about that one...Steeve... -Message d'origine-De : anilsinha1968 [mailto:[EMAIL PROTECTED] Envoyé : 18 février 2005 08:10À : Axapta-Knowledge-Village@yahoogroups.comObjet : [Axapta-Knowledge-Village] Re: Negative recidHiI am curious. What will happen once it reach max negative Int?RegardsAnil Sinha--- In Axapta-Knowledge-Village@yahoogroups.com, Raul Llorente Peña/OPENSOLUTIONS <[EMAIL PROTECTED]> wrote:> Sharing the knowledge on Axapta. Yahoo! Groups LinksSharing the knowledge on Axapta. __Do You Yahoo!?Tired of spam?  Yahoo! Mail has the best spam protection around http://mail.yahoo.com 


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
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: Re: RE: [Axapta-Knowledge-Village] High Importance!!!! Syntax error after a Int declaration.

2005-02-18 Thread Raul Llorente Peña/OPENSOLUTIONS





Girish, I agree you. At last but not least, is the customer who pays for the maintenance... more hard, more money... (usually ;-P) Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.













[Axapta-Knowledge-Village] RE: Negative recid

2005-02-18 Thread Jesper Kehlet






Yes, they are in fact not really negative, but the signed 
representation of unsigned integers.  SQL does not have unsigned 
integers.


From: Cenk Ince [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 18, 2005 2:59 AMTo: 
Axapta-Knowledge-Village@yahoogroups.comSubject: Negative 
recid

Hi all;
I see some negative recids in my database. Is it normal?
Thanks.
 


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.










[Axapta-Knowledge-Village] Connection TImes Out - High Priority

2005-02-18 Thread Subrahmanyam Mamidi




Hi ,
 
We are experienceing the following Problem..
We are executing a store procedure from within Axapta on the Database. The procedure kicks but terminates halve way through (it creates halve of the records). We have tested this with various database store procedures (simple and complex) and all seems to run into the same problem. If executed directly on the Database (not from Axapta) the procedures run 100% correct.
 It seems as if the Axapta connection ‘times out’ after a few seconds.
// The job Is As Follows.
static void ***_StoredProc(Args _args){Connection  Con;Statement   Stmt;Con  = new Connection();Stmt   = connection.createStatement(); Stmt.executeUpdate(‘Stroed Procedure’);
 Stmt.commit();
    }
Can someone help me out in this regards?.
Many Thanks,
Subbu
SDBC
		Do you Yahoo!? 
Yahoo! Search presents - Jib Jab's 'Second Term'


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
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: [Axapta-Knowledge-Village] Sending Fax From Axapta

2005-02-18 Thread DIEGO MARIANO GAGLIANO








Hi MJ
You can try to use WinFax Pro Version 10, to send the Fax from Axapta. This program is called by DLL in Axapta. It is working find, but never I try using with OCX for the Excell. The normal I print the report to send by fax. This are standard Axapta Report.
My best
Diego




 
		Do you Yahoo!? 
Yahoo! Search presents - Jib Jab's 'Second Term'


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.










[Axapta-Knowledge-Village] Error when calling WINGDI method..

2005-02-18 Thread abdulabsi


Hi guys,

I am facing a probelm in calling one of the Axapta WINGDI class 
methods called setBKMode(int i).

I am call it from a testing job:-

static void Job5(Args _args)
{
WINGDI Absi;
;
Absi=new WINGDI(1);

   Absi.setBKMode(1);
}

When I run this job I got "DLL funtion was not found,Can not creat 
DLL function" Error.

Any advises..!

Regards,
Absi






 Yahoo! Groups Sponsor ~--> 
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 





VS: [Axapta-Knowledge-Village] High Importance!!!! Syntax error after a Int declaration.

2005-02-18 Thread Bjørn Gudbrand Idstad
Title: Message






Hi!
 
Try selecting the superclass InventDimCtrl, then 
right-click the node and select Add-ins | Compile 
forward.
This may do the trick.
 
Regards Bjørn
 



Fra: Myrl Stadnick 
[mailto:[EMAIL PROTECTED] Sendt: 16. februar 2005 
21:51Til: Axapta-Knowledge-Village@yahoogroups.comEmne: 
[Axapta-Knowledge-Village] High Importance Syntax error after a Int 
declaration.


 
I have a problem 
with a Integer declaration in Axapta 2.5.
 
After a system 
restart Monday morning (No Mods all weekend) all was fine on Friday. 

 
I now have a 
situation where An Integer call in class InventDimCtl_frm_onHand\modifyQuery 
will not complie the 
 
"Int h,x,y;"statement.
 
But will 
compile.
 
Int  
h;
Int  
x;
Int  
y;
 
The system is full 
of the first Statment and it will fail all through out the 
system.
 
Has anyone come 
across this?  How Do I fix it?
 
Myrl
 
 Sharing the 
knowledge on Axapta. Sharing the knowledge on 
Axapta. 


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.










SV: [Axapta-Knowledge-Village] High Importance!!!! Syntax error after a Int declaration.

2005-02-18 Thread Bjørn Gudbrand Idstad
Title: Message






Hi!
 
Try selecting the superclass InventDimCtrl, then 
right-click the node and select Add-ins | Compile 
forward.
This may do the trick.
 
Regards Bjørn
 



Fra: Myrl Stadnick 
[mailto:[EMAIL PROTECTED] Sendt: 16. februar 2005 
21:51Til: Axapta-Knowledge-Village@yahoogroups.comEmne: 
[Axapta-Knowledge-Village] High Importance Syntax error after a Int 
declaration.


 
I have a problem 
with a Integer declaration in Axapta 2.5.
 
After a system 
restart Monday morning (No Mods all weekend) all was fine on Friday. 

 
I now have a 
situation where An Integer call in class InventDimCtl_frm_onHand\modifyQuery 
will not complie the 
 
"Int h,x,y;"statement.
 
But will 
compile.
 
Int  
h;
Int  
x;
Int  
y;
 
The system is full 
of the first Statment and it will fail all through out the 
system.
 
Has anyone come 
across this?  How Do I fix it?
 
Myrl
 
 Sharing the 
knowledge on Axapta. 


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.










[Axapta-Knowledge-Village] Sending Fax From Axapta

2005-02-18 Thread Michael Jackson







 Hi All,
 
 I want to send a report or especially; excel 
sheet (for example; using with ActiveX contol (Microsoft Office Spreadsheet 
v.11) and then adding button (for sending fax from this ActiveX control 
window)). Is it possible in Axapta ?
 
 Thank you for all suggestions.
 
 MJ


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
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: [Axapta-Knowledge-Village] Re: High Importance!!!! Syntax error after a Int declaration.

2005-02-18 Thread Myrl Stadnick

The answer to my question is this.

A new class was created in a lower layer by the name of X.  What happens
when this class is created it now becomes an object and not a variable.
Since X ia an object now it cannot be used as a variable. Then you will get
an syntax error anywhere it is declared as Int h,x,y;


Myrl
Thanks all for responding.

P.S.

Looks to me that the axapta standard when using naming conventions is to use
a 3 letter sufix to signify what module you are working with. 

ex. smm, BAS, BM, CAC, HRM etc..

For us when different consultants work on our system and create new objects
I ask them to always use the first 3 letters of the company they work for.
Just for accountability.


-Original Message-
From: Cliff Dols [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 18, 2005 12:47 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: High Importance Syntax error
after a Int declaration.



Myrl,

I think it has to with the order in which you call the integers. You first
have to call the integer that is declared first and so on...

Maybe you have thought of this already, but it could solve your problem

Grtz, Cliff




Sharing the knowledge on Axapta. 
Yahoo! Groups Links



 







 Yahoo! Groups Sponsor ~--> 
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 





Re: RE: [Axapta-Knowledge-Village] High Importance!!!! Syntax error after a Int declaration.

2005-02-18 Thread Girish Bhatkal

Hi Raul,

yes it should always be partner's initialls and not
customers. 

 But suppose if you are directly working for an
end client then you could have their Initial. This is
to identify what's standard and what's new.

If your firm has got some outsource work then the
client (which would be an MBS parnter) would always
suggest to have their intials.

When i was working for my ex-employer we used to get
many developement work outsourced by some solution
centres in the US and other countries. They always
wanted us to use their initials (in fact this was one
of their requirement).So this would mean that these
organisation would have a unique initials , no matter
if it was outsourced or work was done inhouse.

   this we did  since way back when we used to work on
version 2.1. This was the requirement of most of the
Solution centres. In this way i cultivated the habit
of adding the prefix as a rule for naming.

  Guys, I am not saying adding suffix or not adding
any identification is wrong. Every one is RIGHT in
what they follow. This is not any individual's
decision. This rule is always decided on
Organisational level, whether if we need any
prefix/sufix added as a rule for naming conventions
and all the developers , within the organisation, have
to follow this rule. 
 As a technical consultant all i could do was give
advise to our clients and it was upto the client to
decide.

But i felt this was a very good discussion and i
am sure we all will be benifited from all the views.  

   Have a nice day

cheers,
Girish


 --- Raul Llorente Peña/OPENSOLUTIONS
<[EMAIL PROTECTED]> wrote: 

-
The problem of prefixes comes when you want to copy
funcionality from a customer to other, and have a
maintenance plan on them...
customer 1: PelbetPrefix: PLB_
customer 2: Ibmosher Prefix: IBM_
 
Object: PLB_Class1, PLB_CustReport, etc...
Export them, import in Ibmosher... objects called IMB_
with others PLB_ make no much sense... rename them
before importing, or after exporting... ok, now
objects have the right prefix... Pelbet suddenly
complaints about a bug, or want to add funcionality...
Shall I rename every corrected object in every
customer with that funcionality? Urgh, that
doesn't sound clear for me.
 
An intermediate solution could be to prefix objects
with the Partner initials, instead. I don't use to
prefix objects with company names (customer's nor
mine).
 
Raúl Llorente Peña 

Análisis, Desarrollo e Implementación en 
Microsoft Bussiness Solutions-Axapta
OPEN SOLUTIONS


-Paulius Cerniauskas <[EMAIL PROTECTED]>
escribió: -

Para: Axapta-Knowledge-Village@yahoogroups.com
De: Paulius Cerniauskas <[EMAIL PROTECTED]>
Fecha: 18/02/2005 09:43
Asunto: RE: [Axapta-Knowledge-Village] High
Importance Syntax error after a Int declaration.

You can find both advantages and disadvantages of
using prefixes. In my practice prefixes is good for
version control and client based object grouping.
Sufixes is good to trace inheritance, e.g. class or
EDT inheritance. As always it depends on your coding
style...
And try to get used to shortcuts F2, F11, Shift+F2
etc. I have found it very usefull...

regards




> 
>  
> 
> Hmmm... are u a systems administrator by any chance?
> 
>  
> 
> Your reasoning is perfectly logical if one is
> thinking from system
> administrator's point of view.
> 
>  
> 
> For me as a programmer, it's the ease of reading the
> code and ease of
> upgrade that is more important. As said earlier,
> while reading the code,
> I don't want the prefix to interfere in my thinking
> and if I extend an
> Axapta table (new table to hold relevant
> information) or create an
> inheritance of a class then I want the new objects
> listed in relevance.
> (for e.g. I have extended InventMov_Purch class and
> given it the name
> InventMov_Purch_ShipmentMMS, this will make sure
> that my class is
> grouped together correctly.
> 
>  
> 
> Adding tables to data import export groups has a
> very limited advantage,
> how many times does anyone do that? And I never use
> the F2 (lookup)
> functionality for coding.
> 
>  
> 
> I was using a prefix in 2001 and have been using a
> suffix since then and
> I can confidently tell you that suffix will improve
> the coding speed in
> the long term. In fact all the solution centres that
> I have worked for
> have gone for the suffix. I would say try it for a
> week and see the
> results.*s*
> 
>  
> 
> Regards
> 
>  
> 
> harry
> 
>  
> 
>  
> 
>   _  
> 
> From: Girish Bhatkal
> [mailto:[EMAIL PROTECTED] 
> Sent: Friday, 18 February 2005 12:41 p.m.
> To: Axapta-Knowledge-Village@yahoogroups.com
> Subject: RE: [Axapta-Knowledge-Village] High
> Importance Syntax error
> after a Int declaration.
> 
>  
> 
> Hi Harry,
> from my experience i feel there is always an
> advantage of naming with identifier as a prefix. i.e
> if your client's name is ABCDE then you could pick
> the
> first 3 digits and then write "AB

RE : [Axapta-Knowledge-Village] Re: Negative recid

2005-02-18 Thread Steeve Gilbert

I'm really curious about that one...

Steeve... 


-Message d'origine-
De : anilsinha1968 [mailto:[EMAIL PROTECTED] 
Envoyé : 18 février 2005 08:10
À : Axapta-Knowledge-Village@yahoogroups.com
Objet : [Axapta-Knowledge-Village] Re: Negative recid



Hi

I am curious. What will happen once it reach max negative Int?

Regards
Anil Sinha

--- In Axapta-Knowledge-Village@yahoogroups.com, Raul Llorente 
Peña/OPENSOLUTIONS <[EMAIL PROTECTED]> wrote:
> 






Sharing the knowledge on Axapta. 
Yahoo! Groups Links



 





 Yahoo! Groups Sponsor ~--> 
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 





[Axapta-Knowledge-Village] Re: Negative recid

2005-02-18 Thread anilsinha1968


Hi

I am curious. What will happen once it reach max negative Int?

Regards
Anil Sinha

--- In Axapta-Knowledge-Village@yahoogroups.com, Raul Llorente 
Peña/OPENSOLUTIONS <[EMAIL PROTECTED]> wrote:
> 





 Yahoo! Groups Sponsor ~--> 
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 





Re: [Axapta-Knowledge-Village] Negative recid

2005-02-18 Thread Raul Llorente Peña/OPENSOLUTIONS





Don't worry about that. RecId have reached the maximum positive Int, so it begins now from the maximum negative Int.Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
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: RE: [Axapta-Knowledge-Village] High Importance!!!! Syntax error after a Int declaration.

2005-02-18 Thread Raul Llorente Peña/OPENSOLUTIONS





The problem of prefixes comes when you want to copy funcionality from a customer to other, and have a maintenance plan on them...customer 1: Pelbet    Prefix: PLB_customer 2: Ibmosher Prefix: IBM_ Object: PLB_Class1, PLB_CustReport, etc...Export them, import in Ibmosher... objects called IMB_ with others PLB_ make no much sense... rename them before importing, or after exporting... ok, now objects have the right prefix... Pelbet suddenly complaints about a bug, or want to add funcionality... Shall I rename every corrected object in every customer with that funcionality? Urgh, that doesn't sound clear for me. An intermediate solution could be to prefix objects with the Partner initials, instead. I don't use to prefix objects with company names (customer's nor mine). Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS-Paulius Cerniauskas <[EMAIL PROTECTED]> escribió: -Para: Axapta-Knowledge-Village@yahoogroups.comDe: Paulius Cerniauskas <[EMAIL PROTECTED]>Fecha: 18/02/2005 09:43Asunto: RE: [Axapta-Knowledge-Village] High Importance Syntax error after a Int declaration.You can find both advantages and disadvantages ofusing prefixes. In my practice prefixes is good forversion control and client based object grouping.Sufixes is good to trace inheritance, e.g. class orEDT inheritance. As always it depends on your codingstyle...And try to get used to shortcuts F2, F11, Shift+F2etc. I have found it very usefull...regards> >  > > Hmmm... are u a systems administrator by any chance?> >  > > Your reasoning is perfectly logical if one is> thinking from system> administrator's point of view.> >  > > For me as a programmer, it's the ease of reading the> code and ease of> upgrade that is more important. As said earlier,> while reading the code,> I don't want the prefix to interfere in my thinking> and if I extend an> Axapta table (new table to hold relevant> information) or create an> inheritance of a class then I want the new objects> listed in relevance.> (for e.g. I have extended InventMov_Purch class and> given it the name> InventMov_Purch_ShipmentMMS, this will make sure> that my class is> grouped together correctly.> >  > > Adding tables to data import export groups has a> very limited advantage,> how many times does anyone do that? And I never use> the F2 (lookup)> functionality for coding.> >  > > I was using a prefix in 2001 and have been using a> suffix since then and> I can confidently tell you that suffix will improve> the coding speed in> the long term. In fact all the solution centres that> I have worked for> have gone for the suffix. I would say try it for a> week and see the> results.*s*> >  > > Regards> >  > > harry> >  > >  > >   _  > > From: Girish Bhatkal> [mailto:[EMAIL PROTECTED]] > Sent: Friday, 18 February 2005 12:41 p.m.> To: Axapta-Knowledge-Village@yahoogroups.com> Subject: RE: [Axapta-Knowledge-Village] High> Importance Syntax error> after a Int declaration.> >  > > Hi Harry,>     from my experience i feel there is always an> advantage of naming with identifier as a prefix. i.e> if your client's name is ABCDE then you could pick> the> first 3 digits and then write "ABC_TableName1". some> of the advantages are:> > 1. if you want to include the new tables created in> the defination group (to import/export the data)> then> its easier to understand which tables to pick.> > 2. if you press F2 and want to pick up the new table> created its easier to identify the tables as they> all> are listed one after the other. similarly when> selecting EDT and enums from the short cut.> >         There are so many other instances where> adding> the identification as a prefix would help a lot. It> might be possible to even identifing by adding> suffix> but prefix makes things easier, atleast for me.>      By adding the identification as a suffix we can> maintain the other naming convention rule where in> we> add the prefix to identify the business area. But we> could add the identifier then underscore and then> the> busniess area of the element. > > cheers,> Girish> > > --- Harry Deshpande <[EMAIL PROTECTED]>> wrote:> > > Hi Girish> > > >  > > > > "It is> > always better we add some prefix so that it will> > never> > affect the standard functionality..."> > > >  > > > > Or may be use a suffix *s*> > > >  > > > > Regards> > > >  > > > > harsh> > > >  > > > >   _  > > > > From: Girish B [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, 17 February 2005 11:45 p.m.> > To: Axapta-Knowledge-Village@yahoogroups.com> > Subject: RE: [Axapta-Knowledge-Village] High> > Importance Syntax error> > after a Int declaration.> > > >  > > > > Guys,     > >      This problem is one of the instance where the> > naming convention what we follow affect the> standard> > functionality aswell.> >    When ever we create/modify in standard axapta> we> > should be carefull of what name we are giving. It> is> > always better we add some prefix so

Re: RE: [Axapta-Knowledge-Village] High Importance!!!! Syntax error after a Int declaration.

2005-02-18 Thread Raul Llorente Peña/OPENSOLUTIONS





This happened to me in a Customer's environment... I spent a week until I found what caused that error...A programmer had created a EDT called 'Target', and a Base Enum called 'Type'... no comment. Resetting DDBB, recompiling Application once and once again, and... etc. When compiling application, Axapta crashed when showing dialogs, forms... horrible... terrific. Regards to everybody!!!Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.













[Axapta-Knowledge-Village] conflict of sorting to the equal to-Operation

2005-02-18 Thread Stefan Heidkamp


Hi all,

lately we get different errors of conflict of sorting to the equal to-
operation. 

We assume that is an result of the changes of tables. Is that true? 
But why changes the sortings? 

Many thanks in advance!
Stefan Heidkamp

 





 Yahoo! Groups Sponsor ~--> 
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 





[Axapta-Knowledge-Village] RE: Negative recid

2005-02-18 Thread Karina Normann Jakobsen






It is normal
 
Med venlig hilsen/Best 
regards/Mit freundlichen Grüßen 
Karina 
Normann JakobsenProgram Manager, Supply Chain 
Management 
 


From: Cenk Ince [mailto:[EMAIL PROTECTED] 
Sent: 18. februar 2005 09:59To: 
Axapta-Knowledge-Village@yahoogroups.comSubject: Negative 
recid

Hi all;
I see some negative recids in my database. Is it normal?
Thanks.
 


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.










[Axapta-Knowledge-Village] Invoicing through EP

2005-02-18 Thread Nitesh

Hi ,
 Please tell me what is the limitation of Enterprise Portal.Is it
possoble to do invoicing through EP?

Regards
Nitesh



 Yahoo! Groups Sponsor ~--> 
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 





[Axapta-Knowledge-Village] Negative recid

2005-02-18 Thread Cenk Ince
Hi all;

I see some negative recids in my database. Is it normal?

Thanks.

 



 Yahoo! Groups Sponsor ~--> 
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 
<>

RE: [Axapta-Knowledge-Village] High Importance!!!! Syntax error after a Int declaration.

2005-02-18 Thread Paulius Cerniauskas

You can find both advantages and disadvantages of
using prefixes. In my practice prefixes is good for
version control and client based object grouping.
Sufixes is good to trace inheritance, e.g. class or
EDT inheritance. As always it depends on your coding
style...
And try to get used to shortcuts F2, F11, Shift+F2
etc. I have found it very usefull...

regards




> 
>  
> 
> Hmmm... are u a systems administrator by any chance?
> 
>  
> 
> Your reasoning is perfectly logical if one is
> thinking from system
> administrator's point of view.
> 
>  
> 
> For me as a programmer, it's the ease of reading the
> code and ease of
> upgrade that is more important. As said earlier,
> while reading the code,
> I don't want the prefix to interfere in my thinking
> and if I extend an
> Axapta table (new table to hold relevant
> information) or create an
> inheritance of a class then I want the new objects
> listed in relevance.
> (for e.g. I have extended InventMov_Purch class and
> given it the name
> InventMov_Purch_ShipmentMMS, this will make sure
> that my class is
> grouped together correctly.
> 
>  
> 
> Adding tables to data import export groups has a
> very limited advantage,
> how many times does anyone do that? And I never use
> the F2 (lookup)
> functionality for coding.
> 
>  
> 
> I was using a prefix in 2001 and have been using a
> suffix since then and
> I can confidently tell you that suffix will improve
> the coding speed in
> the long term. In fact all the solution centres that
> I have worked for
> have gone for the suffix. I would say try it for a
> week and see the
> results.*s*
> 
>  
> 
> Regards
> 
>  
> 
> harry
> 
>  
> 
>  
> 
>   _  
> 
> From: Girish Bhatkal
> [mailto:[EMAIL PROTECTED] 
> Sent: Friday, 18 February 2005 12:41 p.m.
> To: Axapta-Knowledge-Village@yahoogroups.com
> Subject: RE: [Axapta-Knowledge-Village] High
> Importance Syntax error
> after a Int declaration.
> 
>  
> 
> Hi Harry,
> from my experience i feel there is always an
> advantage of naming with identifier as a prefix. i.e
> if your client's name is ABCDE then you could pick
> the
> first 3 digits and then write "ABC_TableName1". some
> of the advantages are:
> 
> 1. if you want to include the new tables created in
> the defination group (to import/export the data)
> then
> its easier to understand which tables to pick.
> 
> 2. if you press F2 and want to pick up the new table
> created its easier to identify the tables as they
> all
> are listed one after the other. similarly when
> selecting EDT and enums from the short cut.
> 
> There are so many other instances where
> adding
> the identification as a prefix would help a lot. It
> might be possible to even identifing by adding
> suffix
> but prefix makes things easier, atleast for me.
>  By adding the identification as a suffix we can
> maintain the other naming convention rule where in
> we
> add the prefix to identify the business area. But we
> could add the identifier then underscore and then
> the
> busniess area of the element. 
> 
> cheers,
> Girish
> 
> 
> --- Harry Deshpande <[EMAIL PROTECTED]>
> wrote:
> 
> > Hi Girish
> > 
> >  
> > 
> > "It is
> > always better we add some prefix so that it will
> > never
> > affect the standard functionality..."
> > 
> >  
> > 
> > Or may be use a suffix *s*
> > 
> >  
> > 
> > Regards
> > 
> >  
> > 
> > harsh
> > 
> >  
> > 
> >   _  
> > 
> > From: Girish B [mailto:[EMAIL PROTECTED] 
> > Sent: Thursday, 17 February 2005 11:45 p.m.
> > To: Axapta-Knowledge-Village@yahoogroups.com
> > Subject: RE: [Axapta-Knowledge-Village] High
> > Importance Syntax error
> > after a Int declaration.
> > 
> >  
> > 
> > Guys, 
> >  This problem is one of the instance where the
> > naming convention what we follow affect the
> standard
> > functionality aswell.
> >When ever we create/modify in standard axapta
> we
> > should be carefull of what name we are giving. It
> is
> > always better we add some prefix so that it will
> > never
> > affect the standard functionality...
> > In this example we all know that at many places
> > x,y,z
> > and a,b,c would be used so we should avoid using
> > these
> > for naming the new EDT. If you do want to display
> > x,y,z etc.. then you could label the elements with
> > these but the element name should be given a
> prefix.
> > It is very important for new axapta developers
> > to
> > start using some standard naming conventions
> because
> > you will get used to this standard practice, else
> to
> > change in the later stage becomes a bit difficult,
> > but
> > still posssible.
> > 
> >  Enjoy coding!!!
> > 
> > cheers,
> > Girish
> > 
> > 
> > --- Padmaja Iyingar <[EMAIL PROTECTED]>
> wrote:
> > 
> > > Hi Preston,
> > >  
> > > Its perfect. Your assumption is right. I tried
> to
> > > change  to 
> > >  
> > > real _quantity, _price from  real quantity,
> > price..
> > >  
> > > ha ha ha ha..It wroks now.
> > >  
> > > Thanks Preston