Re: [development-axapta] Join datasource with 2 fields

2005-08-23 Thread Paulius Cerniauskas 




Join datasources with "OR" operator Directly is
impossible, but see ProjTable'e method
lookupProj_Web()for example. I am not sure it what you
need, but there query conditions are  formed in a bit
different way.

--- kamchung322 <[EMAIL PROTECTED]> wrote:

> Hi All, 
> 
> I want to join 2 datasources with 2 fields. 
> Following is the code : 
> 
> QueryBuildDataSource  qb;
> qb = this.query().dataSourceNo(2;
> qb.addLink(FieldNum(Table1, Field1),
> FieldNum(Table2, Field1));
> qb.addLink(FieldNum(Table1, Field2),
> FieldNUm(Table2, Field2));
> 
> the above code will join the datasources with Field1
> AND Field2 but I
> want to join it with Field1 OR Field2.  Is it
> possible to do it ? 
> 
> Regards.
> 
> Kenneth. 
> 
> 
> 
> 
> 
> 
> 


Paulius Cerniauskas
Phone: +37062049339
ICQ: 280959446


    

Start your day with Yahoo! - make it your home page 
http://www.yahoo.com/r/hs 
 









  
  
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] Re: where and when generate the RecId in Axapta

2005-08-23 Thread martin_weicn 




Thank you all for your help. 

I find most of system function are driven by kernel.
But, how to understand the difference of by kernel and by 
application? As we know application includes all the system programs.

Develop guide: Because most of the methods are called from the 
kernel, and because standard functionality is provided which is 
implemented closely together with the kernel functions, you will 
rarely need to use the Application class.

So, i am confused for that.


--- In development-axapta@yahoogroups.com, "mbsaxapta" 
<[EMAIL PROTECTED]> wrote:
> Hi
> As I know -  Axapta gets the next RecId  from SystemSequences 
table,  column
> is NextVal.
> RecId is unique per company.
> 
> tomas
> 
> -Original Message-
> From: development-axapta@yahoogroups.com
> [mailto:[EMAIL PROTECTED] Behalf Of Nitesh
> Sent: Tuesday, August 23, 2005 11:55 AM
> To: development-axapta@yahoogroups.com
> Subject: Re: [development-axapta] where and when generate the RecId 
in
> Axapta
> 
> 
> Hi martin ,
>   The Recid is generated by kernel,when a record is
> inserted into atable.The refrence of the previous recid is stored 
in "
> Dataarea" table..
> 
> Nitesh
> 
> 
> On 8/23/05, martin_weicn <[EMAIL PROTECTED]> wrote:
> > Hi All,
> >
> > I am wonder where and when the system generate the RecId in Axapta
> > by kernel or by application or in Database, and in client or 
server
> > application? Thanks a lot.
> >
> > Martin Wei
> >
> >
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> 
> 
> 
> 
> 
> 
> Yahoo! Groups Links
> 
> 
> 
> 
> 
> 
> 
> 
> __ Informace od NOD32 1.1199 (20050822) __
> 
> Tato zprava byla proverena antivirovym systemem NOD32.
> http://www.nod32.cz










  
  
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.

RE: [development-axapta] reading sysdatabase log outside axapta

2005-08-23 Thread Lars Mikkelsen 




Yes. It is a serialized container of containers. You can see how it is
serialized in method SysDataBaseLog.SetData and deserialized in method
SysDataBaseLog.GetDataAsList.

 

It is probably difficult to figure out the format of a serialized container,
so it will be difficult to create an external algorithm for doing this,
unless someone else has done this and is willing to publish the code.

 

You have a couple of other options.

 

Make a call through the COM connector and let a method in Axapta return the
information in a format you can use.

 

Overwrite Insert/update methods of SysDataBaseLog and store the information
in a format that is easy for you to read and interpret.

This could be in another table or in a new field in SysDataBaseLog in
whatever format you may choose.

 

 

 

 

  _  

From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Andres Janno
Sent: Tuesday, August 23, 2005 2:49 AM
To: development-axapta@yahoogroups.com
Subject: Re: [development-axapta] reading sysdatabase log outside axapta

 

No, I mean that sysdatabaselog data field is somehow crypted or 
something. It is container type of field.
Is there any outside algorithm to decode this data field?

Regards,
Andres

Erik Hansen wrote:

> You might need to install a ODBC driver on the computer, but otherwise
> use the ODBCConnection in Axapta.
>
>
>
> Best regard
>
> Erik
>
>
>
> 
>
> From: development-axapta@yahoogroups.com
> [mailto:[EMAIL PROTECTED] On Behalf Of Andres Janno
> Sent: 23. august 2005 10:30
> To: development-axapta@yahoogroups.com
> Subject: [development-axapta] reading sysdatabase log outside axapta
>
>
>
> Hello!
>
> Is there any possibilities to read sysdatabaselog data container outside
>
> axapta?
> >From sql query analyzer directly for example?
>
> Regards,
> Andres
>
>
>
>
>
> 
>
> YAHOO! GROUPS LINKS
>
>
>
> *  Visit your group "development-axapta
>  " on the web.
>    
> *  To unsubscribe from this group, send an email to:
>   [EMAIL PROTECTED]
> 
> be>
>    
> *  Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service  .
>
>
>
> 
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> SPONSORED LINKS
> Computer part 
> 
&k=Computer+part&w1=Computer+part&w2=Programming+languages&w3=Microsoft+axap
ta&w4=Support+exchange&c=4&s=90&.sig=yLpvcLTIDJ5FTkRJGsO11w> 
>   Programming languages 
> 
&k=Programming+languages&w1=Computer+part&w2=Programming+languages&w3=Micros
oft+axapta&w4=Support+exchange&c=4&s=90&.sig=cuhEClK4dU4wapXFmKisbQ> 
>   Microsoft axapta 
> 
&k=Microsoft+axapta&w1=Computer+part&w2=Programming+languages&w3=Microsoft+a
xapta&w4=Support+exchange&c=4&s=90&.sig=yfeG_U6QaLfPOZZIud02Fg> 
>
> Support exchange 
> 
&k=Support+exchange&w1=Computer+part&w2=Programming+languages&w3=Microsoft+a
xapta&w4=Support+exchange&c=4&s=90&.sig=hy8yRGMzrmxdphyITTUeqA> 
>
>
>
> 
> 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 .
>
>
> 
>






SPONSORED LINKS 


Computer
  part 

Programming
  languages 

Microsoft

RE: [development-axapta] From Axapta 2.5 to 4.0

2005-08-23 Thread James Flavell 




mmm I am confused what is SP2.5???!!
 
Anyway if you are going from version 2.5 to version 3.0 from what I can
recall you need to install the last 2.5 SP and then upgrade to v3.0 SP0
after which you can then install the latest v.30 SP (i.e SP4) because
service pack are accumualtive (i.e. SP4 contains all the things in SP1,2 and
3).
 
If you upgrade say a 2.5 SP1 straight to v3.0 SP0 then I think you will have
problems if my memory serves me correct.
 
All the best 
James
 
 

-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of hilda cabrejos
Sent: 23 August 2005 21:47
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] From Axapta 2.5 to 4.0


Hello

Sorry if there was a misunderstanding de upgrade was from version 3 SP2.5 to
version 3 SP4, as you say version 4 is not out yet.  I do not recommend
going from V3 SP2.5 to V3 SP3 and then V3 SP4...we did it and lost about 1
month on the try, it all failed.

Hilda

mudit mittal <[EMAIL PROTECTED]> wrote:
Hi 

First i dont think so 4.0 is out in market , and other thing is if you have
to do a upgrade from 2.5 to 4.0 , best way is to do in steps , do it from
2.5 to 3.0 and then from 3.0 to 4.0.

Regards
Mudit

yuvika sharma <[EMAIL PROTECTED]> wrote:
Hi,
I need to know about the requirements to upgrade from version 2.5 to version
4.0.For that do we need to install SP4 client on every client ?
Regards








Tom Kim <[EMAIL PROTECTED]> wrote:
Do you mean you just upgraded from 2.5 to 2.5 with SP4, or to version 4.0?
Thanks --Tom

Tom Kim
Microsoft Business Solutions Certified Professional
Advanced Systems Integration, Inc.
26449 Rancho Parkway South
Lake Forest, CA 92630
949-597-2170
949-597-0720 (Fax)
[EMAIL PROTECTED]
www.advancedsystemsintegration.com

-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of hilda cabrejos
Sent: Friday, August 19, 2005 6:11 AM
To: development-axapta@yahoogroups.com
Subject: Re: [development-axapta] From Axapta 2.5 to 4.0




Hello
We just upgraded from 2.5 to 4.0, what I recommend is to make a good backup
checking that the owner is bmssa, backup of axaptaapplication 2.5 directory,
and backup of axaptaclient 2.5 directory if you have to go back (we had to),
do the upgrade in another server different from the one you have axapta 2.5
first, if everything works ok do it on the real one, the process depending
on the size of your DB (150M took about 6 hours), if you work with
SALESLINETABLE check for lines that have no unit, after the upgrade these
will appear with a unit called AX.  Do this process on a weekend.  You must
install SP4 client on every client so rename the actual AOT so there is no
chance on somebody entering with another version of SP. Can´t think of
anything else.

yuvika sharma <[EMAIL PROTECTED]> wrote:
Hi all,
can any one list the requirements and precautions needed to upgrade the code
from version 2.5 to 4.0 ???
Thanks

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[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. 


-



__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[Non-text portions of this message have been removed]







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. 


-



    
-
Start your day with Yahoo! - make it your home page 

[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. 


-



    
-
Start your day with Yahoo! - make it your home page 

[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

[development-axapta] Win2000 + SP4 + (Axapta 3.0 SP3)

2005-08-23 Thread Roberto Pineda 




Hello to all...

We just applied MS win2000 server service pack 4 in
our server & started to experiment a lot of problems
related to Axapta's response time and the system
hangs up with some options (for example when trying to
eliminate transactions from a consolidation entity).

Has someone applied this service pack? 
Is there a hotfix or patch to solve this?

Any advice will be helpful.
Thanks

Roberto

__
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis! 
Regístrate ya - http://correo.espanol.yahoo.com/ 








  
  
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.

RE: [development-axapta] How to move sql axapta database to another server?

2005-08-23 Thread Roberto Pineda 





Ok.
I should supposed that... thanks for your help.

Roberto. 

 --- mbsaxapta <[EMAIL PROTECTED]> escribió:

> hello Roberto,
> you can use database tasks as usually. Axapta
> database is not something
> special:-))
> Dettach your database via Enterprise manager and
> simply copy your database
> files on other server.Than you must attach it on
> this new one.
> Or create backup file, and restore it into database
> on your new server.
> 
> tomas
> 
> -Original Message-
> From: development-axapta@yahoogroups.com
> [mailto:[EMAIL PROTECTED] Behalf
> Of Roberto Pineda
> Sent: Monday, August 22, 2005 9:21 PM
> To: development-axapta@yahoogroups.com
> Subject: [development-axapta] How to move sql axapta
> database to another
> server?
> 
> 
> Hello to All...
> 
> We will be moving our SQL Axapta database to a new
> server.
> Is there a Best Practices list we can follow?
> Any advice or suggestions.
> 
> Thanks a lot.
> 
> Roberto
> 
> __
> Correo Yahoo!
> Espacio para todos tus mensajes, antivirus y
> antispam ¡gratis!
> Regístrate ya - http://correo.espanol.yahoo.com/
> 
> 
> 
> 
> 
> 
> Yahoo! Groups Links
> 
> 
> 
> 
> 
> 
> 
> __ Informace od NOD32 1.1199 (20050822)
> __
> 
> Tato zprava byla proverena antivirovym systemem
> NOD32.
> http://www.nod32.cz
> 
> 
> 
> 
> 
> 




__
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis! 
Regístrate ya - http://correo.espanol.yahoo.com/ 





  




  
  
  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] Modifying report query

2005-08-23 Thread redaj27 




I have a Sales History report with a query linking the CustTable, 
CustInvoiceJour, CustInvoiceTrans and InventTable tables.

InventTable is last table as the report is ultimately sorted by 
InventTable.ItemId.

On occasions I need to limit the customers, to ones that exist in a 
Pricing table (Customer codes can be duplicated in this table).

Has anyone got any suggestions of how I can modify the report's query 
(preferably at run-time) to incorporate this extra table?

If I add this table as another datasource linked to the CustTable,
with 
an Exists join, the report starts to take ages.

I can add Ranges to CustTable.AccountNum but I may need to match with 
up to 3,000 accounts from the Pricing table. 











  
  
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] Generating print archive documents

2005-08-23 Thread Edine Le Roux 




Hi All,

We are experiencing problems generating print archive documents.

The standard Axapta code in RestorePrinting - setPrintJobTables (used to
insert values into the PrintJobPages table) is executed, but an SQL database
error occurs stating that a record in the PrintJobPages table could not be
inserted (duplicate record error).

We have tried deleting the values in the PrintJobHeader and PrintJobPages
tables, but the error keeps occurring (usually after 2 print archive
documents have been created successfully).

Does anyone know about this problem and/or a possible fix?

Regards,
Edine le Roux


[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.

RE: [development-axapta] From Axapta 2.5 to 4.0

2005-08-23 Thread hilda cabrejos 




Hello
 
Sorry if there was a misunderstanding de upgrade was from version 3 SP2.5 to version 3 SP4, as you say version 4 is not out yet.  I do not recommend going from V3 SP2.5 to V3 SP3 and then V3 SP4...we did it and lost about 1 month on the try, it all failed.
 
Hilda

mudit mittal <[EMAIL PROTECTED]> wrote:
Hi 

First i dont think so 4.0 is out in market , and other thing is if you have to do a upgrade from 2.5 to 4.0 , best way is to do in steps , do it from 2.5 to 3.0 and then from 3.0 to 4.0.

Regards
Mudit

yuvika sharma <[EMAIL PROTECTED]> wrote:
Hi,
I need to know about the requirements to upgrade from version 2.5 to version 4.0.For that do we need to install SP4 client on every client ?
Regards








Tom Kim <[EMAIL PROTECTED]> wrote:
Do you mean you just upgraded from 2.5 to 2.5 with SP4, or to version 4.0?
Thanks --Tom

Tom Kim
Microsoft Business Solutions Certified Professional
Advanced Systems Integration, Inc.
26449 Rancho Parkway South
Lake Forest, CA 92630
949-597-2170
949-597-0720 (Fax)
[EMAIL PROTECTED]
www.advancedsystemsintegration.com

-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of hilda cabrejos
Sent: Friday, August 19, 2005 6:11 AM
To: development-axapta@yahoogroups.com
Subject: Re: [development-axapta] From Axapta 2.5 to 4.0




Hello
We just upgraded from 2.5 to 4.0, what I recommend is to make a good backup
checking that the owner is bmssa, backup of axaptaapplication 2.5 directory,
and backup of axaptaclient 2.5 directory if you have to go back (we had to),
do the upgrade in another server different from the one you have axapta 2.5
first, if everything works ok do it on the real one, the process depending
on the size of your DB (150M took about 6 hours), if you work with
SALESLINETABLE check for lines that have no unit, after the upgrade these
will appear with a unit called AX.  Do this process on a weekend.  You must
install SP4 client on every client so rename the actual AOT so there is no
chance on somebody entering with another version of SP. Can´t think of
anything else.

yuvika sharma <[EMAIL PROTECTED]> wrote:
Hi all,
can any one list the requirements and precautions needed to upgrade the code
from version 2.5 to 4.0 ???
Thanks

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[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. 


-



__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[Non-text portions of this message have been removed]







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. 


-



    
-
Start your day with Yahoo! - make it your home page 

[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. 


-



    
-
Start your day with Yahoo! - make it your home page 

[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. 


-



__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[Non-text portions of this message have been removed]










  
  
SPONSORED LINKS
  
  
  

Computer part
  
  
Programming languages
  
  
Microsoft axapta
  
  


Support exchange

RE: [development-axapta] From Axapta 2.5 to 4.0

2005-08-23 Thread hilda cabrejos 




Hello
 
>From version 3 SP2.5 to Version 3 SP4 you need to install SP4 in every client, you must be careful with this, no one should enter with another version of client.
 
Hilda Cabrejos

yuvika sharma <[EMAIL PROTECTED]> wrote:
Hi,
I need to know about the requirements to upgrade from version 2.5 to version 4.0.For that do we need to install SP4 client on every client ?
Regards








Tom Kim <[EMAIL PROTECTED]> wrote:
Do you mean you just upgraded from 2.5 to 2.5 with SP4, or to version 4.0?
Thanks --Tom

Tom Kim
Microsoft Business Solutions Certified Professional
Advanced Systems Integration, Inc.
26449 Rancho Parkway South
Lake Forest, CA 92630
949-597-2170
949-597-0720 (Fax)
[EMAIL PROTECTED]
www.advancedsystemsintegration.com

-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of hilda cabrejos
Sent: Friday, August 19, 2005 6:11 AM
To: development-axapta@yahoogroups.com
Subject: Re: [development-axapta] From Axapta 2.5 to 4.0




Hello
We just upgraded from 2.5 to 4.0, what I recommend is to make a good backup
checking that the owner is bmssa, backup of axaptaapplication 2.5 directory,
and backup of axaptaclient 2.5 directory if you have to go back (we had to),
do the upgrade in another server different from the one you have axapta 2.5
first, if everything works ok do it on the real one, the process depending
on the size of your DB (150M took about 6 hours), if you work with
SALESLINETABLE check for lines that have no unit, after the upgrade these
will appear with a unit called AX.  Do this process on a weekend.  You must
install SP4 client on every client so rename the actual AOT so there is no
chance on somebody entering with another version of SP. Can´t think of
anything else.

yuvika sharma <[EMAIL PROTECTED]> wrote:
Hi all,
can any one list the requirements and precautions needed to upgrade the code
from version 2.5 to 4.0 ???
Thanks

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[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. 


-



__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[Non-text portions of this message have been removed]







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. 


-



    
-
Start your day with Yahoo! - make it your home page 

[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. 


-



    
-
 Start your day with Yahoo! - make it your home page 

[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.

RE: [development-axapta] From Axapta 2.5 to 4.0

2005-08-23 Thread hilda cabrejos 




Hello
>From version 3 SP2 to version 3 SP4.
 
Hilda Cabrejos

Tom Kim <[EMAIL PROTECTED]> wrote:
Do you mean you just upgraded from 2.5 to 2.5 with SP4, or to version 4.0?
Thanks --Tom

Tom Kim
Microsoft Business Solutions Certified Professional
Advanced Systems Integration, Inc.
26449 Rancho Parkway South
Lake Forest, CA 92630
949-597-2170
949-597-0720 (Fax)
[EMAIL PROTECTED]
www.advancedsystemsintegration.com

-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of hilda cabrejos
Sent: Friday, August 19, 2005 6:11 AM
To: development-axapta@yahoogroups.com
Subject: Re: [development-axapta] From Axapta 2.5 to 4.0




Hello
We just upgraded from 2.5 to 4.0, what I recommend is to make a good backup
checking that the owner is bmssa, backup of axaptaapplication 2.5 directory,
and backup of axaptaclient 2.5 directory if you have to go back (we had to),
do the upgrade in another server different from the one you have axapta 2.5
first, if everything works ok do it on the real one, the process depending
on the size of your DB (150M took about 6 hours), if you work with
SALESLINETABLE check for lines that have no unit, after the upgrade these
will appear with a unit called AX.  Do this process on a weekend.  You must
install SP4 client on every client so rename the actual AOT so there is no
chance on somebody entering with another version of SP. Can´t think of
anything else.

yuvika sharma <[EMAIL PROTECTED]> wrote:
Hi all,
can any one list the requirements and precautions needed to upgrade the code
from version 2.5 to 4.0 ???
Thanks

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[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. 


-



__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[Non-text portions of this message have been removed]







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. 


-



__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[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] where and when generate the RecId in Axapta

2005-08-23 Thread mbsaxapta 




Hi
As I know -  Axapta gets the next RecId  from SystemSequences table,  column
is NextVal.
RecId is unique per company.

tomas

-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] Behalf Of Nitesh
Sent: Tuesday, August 23, 2005 11:55 AM
To: development-axapta@yahoogroups.com
Subject: Re: [development-axapta] where and when generate the RecId in
Axapta


Hi martin ,
  The Recid is generated by kernel,when a record is
inserted into atable.The refrence of the previous recid is stored in "
Dataarea" table..

Nitesh


On 8/23/05, martin_weicn <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I am wonder where and when the system generate the RecId in Axapta
> by kernel or by application or in Database, and in client or server
> application? Thanks a lot.
>
> Martin Wei
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>






Yahoo! Groups Links








__ Informace od NOD32 1.1199 (20050822) __

Tato zprava byla proverena antivirovym systemem NOD32.
http://www.nod32.cz










  
  
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.

Re: [development-axapta] where and when generate the RecId in Axapta

2005-08-23 Thread Nitesh 




Hi martin ,
  The Recid is generated by kernel,when a record is
inserted into atable.The refrence of the previous recid is stored in "
Dataarea" table..

Nitesh 


On 8/23/05, martin_weicn <[EMAIL PROTECTED]> wrote:
> Hi All,
> 
> I am wonder where and when the system generate the RecId in Axapta
> by kernel or by application or in Database, and in client or server
> application? Thanks a lot.
> 
> Martin Wei
> 
> 
> 
> 
> 
> 
> 
> 
> 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.

Re: [development-axapta] reading sysdatabase log outside axapta

2005-08-23 Thread Andres Janno 




No, I mean that sysdatabaselog data field is somehow crypted or 
something. It is container type of field.
Is there any outside algorithm to decode this data field?

Regards,
Andres

Erik Hansen wrote:

> You might need to install a ODBC driver on the computer, but otherwise
> use the ODBCConnection in Axapta.
>
>
>
> Best regard
>
> Erik
>
>
>
> 
>
> From: development-axapta@yahoogroups.com
> [mailto:[EMAIL PROTECTED] On Behalf Of Andres Janno
> Sent: 23. august 2005 10:30
> To: development-axapta@yahoogroups.com
> Subject: [development-axapta] reading sysdatabase log outside axapta
>
>
>
> Hello!
>
> Is there any possibilities to read sysdatabaselog data container outside
>
> axapta?
> >From sql query analyzer directly for example?
>
> Regards,
> Andres
>
>
>
>
>
> 
>
> YAHOO! GROUPS LINKS
>
>
>
> *  Visit your group "development-axapta
>  " on the web.
>    
> *  To unsubscribe from this group, send an email to:
>   [EMAIL PROTECTED]
> 
> be>
>    
> *  Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service  .
>
>
>
> 
>
>
>
> [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 .
>
>
> 
>









  
  
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.

Re: [development-axapta] where and when generate the RecId in Axapta

2005-08-23 Thread yuvika sharma 




Hi Martin,
Recid'sare generated by Kernel while saving the particular record.


martin_weicn <[EMAIL PROTECTED]> wrote:
Hi All,

I am wonder where and when the system generate the RecId in Axapta
by kernel or by application or in Database, and in client or server 
application? Thanks a lot.

Martin Wei






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. 


-



__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[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] where and when generate the RecId in Axapta

2005-08-23 Thread martin_weicn 




Hi All,

I am wonder where and when the system generate the RecId in Axapta
by kernel or by application or in Database, and in client or server 
application? Thanks a lot.

Martin Wei










  
  
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.

RE: [development-axapta] reading sysdatabase log outside axapta

2005-08-23 Thread Erik Hansen 




You might need to install a ODBC driver on the computer, but otherwise
use the ODBCConnection in Axapta.

 

Best regard 

Erik

 



From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Andres Janno
Sent: 23. august 2005 10:30
To: development-axapta@yahoogroups.com
Subject: [development-axapta] reading sysdatabase log outside axapta

 

Hello!

Is there any possibilities to read sysdatabaselog data container outside

axapta?
>From sql query analyzer directly for example?

Regards,
Andres







YAHOO! GROUPS LINKS 

 

*   Visit your group "development-axapta
 " on the web.
    
*   To unsubscribe from this group, send an email to:
   [EMAIL PROTECTED]

be> 
    
*   Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service  . 

 





[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] reading sysdatabase log outside axapta

2005-08-23 Thread Andres Janno 




Hello!

Is there any possibilities to read sysdatabaselog data container outside 
axapta?
 From sql query analyzer directly for example?

Regards,
Andres








  
  
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.

Re: [development-axapta] FormTreeDatasource

2005-08-23 Thread Sonny Wibawa Adi 




Hi Andre Klopper,


The standard FormTreeDatasource doesn't implement
filtered datasource into it. If you want to implement,
modify subTreeQueryRun function in FormTreeDataSource
class. Call mergeRanges method to merge the ranges
into a new query object:

QueryRun subTreeQueryRun(AnyType _ParentValue)
{
    Query query = new Query();
    QueryBuildDataSource queryBuildDataSource =
query.addDataSource(formDataSource.table());
    QueryBuildRange criteriaParentId =
queryBuildDataSource.addRange(parentId);
    ;
    queryBuildDataSource.addSortField(txt);

   
SysQuery::mergeRanges(query,formDataSource.query());
//this is the additional code

    if (_ParentValue)
    criteriaParentId.value(_ParentValue);
    else
   
criteriaParentId.value(strFmt('"%1"',queryValue(_ParentValue)));
    return new QueryRun(query);
}


This is to filter the CustTable datasource, init
method on tutorial_Form_Treedatasource form:
void init()
{
    super();

    SysQuery::findOrCreateRange(
    CustTable_q.dataSourceNo(1),
   
fieldNum(CustTable,CustGroup)).value(queryValue('20'));

    treeDatasource = new
FormTreeDatasource(this,element.control(control::Tree),
   
fieldnum(CustTable,accountNum),
   
fieldnum(CustTable,invoiceAccount),
   
fieldnum(CustTable,name)
    );

   
treeDatasource.initRoot(CompanyInfo::find().name,'');
}

If there are another requirements, then modify the
class if needed.

Good luck.


Best regards,


Sonny Wibawa Adi, MBSCP, MCSD.NET, MCAD.NET

--- Andre Klopper <[EMAIL PROTECTED]>
wrote:

> 
> Ok,
> 
> So I worked through the
> tutorial_Form_TreeDatasource. I get this to work but
> would like to take it one step futher... I want do
> create the tree on the
> data in a filtered datasource. How do I assign the
> filtered datasource to
> the FormTreeDatasource?
> 
> Regards
> Andre
> 
> 
> 
> 
> 



    
__ 
Yahoo! Mail for Mobile 
Take Yahoo! Mail with you! Check email on your mobile phone. 
http://mobile.yahoo.com/learn/mail 








  
  
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.

RE: [development-axapta] From Axapta 2.5 to 4.0

2005-08-23 Thread mudit mittal 




Hi 
 
First i dont think so 4.0 is out in market , and other thing is if you have to do a upgrade from 2.5 to 4.0 , best way is to do in steps , do it from 2.5 to 3.0 and then from 3.0 to 4.0.
 
Regards
Mudit

yuvika sharma <[EMAIL PROTECTED]> wrote:
Hi,
I need to know about the requirements to upgrade from version 2.5 to version 4.0.For that do we need to install SP4 client on every client ?
Regards








Tom Kim <[EMAIL PROTECTED]> wrote:
Do you mean you just upgraded from 2.5 to 2.5 with SP4, or to version 4.0?
Thanks --Tom

Tom Kim
Microsoft Business Solutions Certified Professional
Advanced Systems Integration, Inc.
26449 Rancho Parkway South
Lake Forest, CA 92630
949-597-2170
949-597-0720 (Fax)
[EMAIL PROTECTED]
www.advancedsystemsintegration.com

-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of hilda cabrejos
Sent: Friday, August 19, 2005 6:11 AM
To: development-axapta@yahoogroups.com
Subject: Re: [development-axapta] From Axapta 2.5 to 4.0




Hello
We just upgraded from 2.5 to 4.0, what I recommend is to make a good backup
checking that the owner is bmssa, backup of axaptaapplication 2.5 directory,
and backup of axaptaclient 2.5 directory if you have to go back (we had to),
do the upgrade in another server different from the one you have axapta 2.5
first, if everything works ok do it on the real one, the process depending
on the size of your DB (150M took about 6 hours), if you work with
SALESLINETABLE check for lines that have no unit, after the upgrade these
will appear with a unit called AX.  Do this process on a weekend.  You must
install SP4 client on every client so rename the actual AOT so there is no
chance on somebody entering with another version of SP. Can´t think of
anything else.

yuvika sharma <[EMAIL PROTECTED]> wrote:
Hi all,
can any one list the requirements and precautions needed to upgrade the code
from version 2.5 to 4.0 ???
Thanks

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[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. 


-



__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[Non-text portions of this message have been removed]







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. 


-



    
-
Start your day with Yahoo! - make it your home page 

[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. 


-



    
-
 Start your day with Yahoo! - make it your home page 

[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.