AW: [development-axapta] Day - Month field

2005-03-09 Thread Andrae, Tobias 





Hi,
 just create an extended data type of the type "date" and set the property "dateYear" to "year not shown". Use this in your table ;-)
hth Tobias

-Ursprüngliche Nachricht-
Von: gennarociulla [mailto:[EMAIL PROTECTED] 
Gesendet: Mittwoch, 9. März 2005 10:03
An: development-axapta@yahoogroups.com
Betreff: [development-axapta] Day - Month field




Hi, i'm trying to create a field in a table that contains a Day -
Month information. There's a way to do this (eg. an extended data
type?) without split the two informations in a single field for each one?
Thanks!








 
Yahoo! Groups Links



 




-- 
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.0 - Release Date: 08.03.2005
 

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.0 - Release Date: 08.03.2005
 












Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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] Re: Outer join in X++

2005-03-09 Thread Matt Benic 





Thanks, but the problem is that I want to select from custtable and address
if either of the two have been changed, not just if custtable has been
changed, so if I limit the custtable select before doing the join, I cut out
the cases where the address has changed but the custtable has not..

Regards,

Matt Benic
Axapta and .Net Developer
UTi Sun Couriers Division

"The universal aptitude for ineptitude
makes any human accomplishment an incredible miracle."
- Col. John P. Stapp
www.smallfrymobile.com 


-Original Message-
From: nicolaan [mailto:[EMAIL PROTECTED]
Sent: 09 March 2005 05:17 PM
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Re: Outer join in X++





Hi Matt,

I think this should work.

    while SELECT CUSTTABLE
    WHERE (ADDRESS.ADDRTABLEID == 77) &&
    (CUSTTABLE.MODIFIEDDATE > mkdate(1, 3, 2005))
    OUTER JOIN ADDRESS
    where CUSTTABLE.RECID == ADDRESS.ADDRRECID
    ADDRESS.ADDRESSTYPE == 'Invoice'

Axapta works different with joins.
First you define your "where clause" for the main table and after
your join you specify an extra "where" with your join specifications.
So the 2nd where is your "on" keyword.

I searched for "outer join" in classes to get an example from Axapta.

Regards,

Nico

--- In development-axapta@yahoogroups.com, "Matt Benic" <[EMAIL PROTECTED]>
wrote:
>
> Hi all,
> I am trying to design a query in X++ which works in SQL. The SQL
version is:
>
> SELECT ADDRESS.*, CUSTTABLE.*
> FROM CUSTTABLE LEFT OUTER JOIN ADDRESS
> ON CUSTTABLE.RECID = ADDRESS.ADDRRECID
> WHERE (ADDRESS.ADDRTABLEID = 77) AND
>  (CUSTTABLE.MODIFIEDDATE > CONVERT(DATETIME, '2005-
03-01
> 00:00:00', 102)) AND
>  (ADDRESS.ADDRESSTYPE = 'Invoice')
>
> Which returns a single row. I am trying to use the following in X++
and it
> returns every row:
>
> while select custTable outer join address
> where (address.AddrTableId == tableNum(CustTable) &&
> address.AddrRecId == custTable.RecId) &&
>   (address.AddressType == "Invoice") &&
>   (custTable.modifiedDate > sinceDate ||
>    address.modifiedDate > sinceDate)
> { //do stuff with adddress and custTable }
>
> I can't seem to find the equivalent of the 'on' keyword in X++, how
would I
> achieve this? I don't want to manually go through each custTable
record and
> do the check in X++, I would rather let the DB do the work.
>
> Thanks,
>
> Matt Benic
> Axapta and .Net Developer
> UTi Sun Couriers Division
>
> "The universal aptitude for ineptitude
> makes any human accomplishment an incredible miracle."
> - Col. John P. Stapp
> www.smallfrymobile.com









Yahoo! Groups Links




















Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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] Adding new field to inventrans and getting it populated

2005-03-09 Thread James Flavell 





Hi 
 
I would like to know what I need to do to add a new field to the inventrans
and to get this field populated.
 
I have a customer PO number that ends up being many Axapta sales orders and
this PO number is very importnat for the my client to review inventory
movements.
 
I could use the batch number inventory dimension to record this PO number
but dont think this is the best approach so I want to mkae a new field on
the inventtrans and get this field copied from the sales order down to the
inventtrans.  Is this the best/correct way?  If so can I just add the field
(same name as sales order) and put it in one of the field groups and the
system will take care of the rest (me dreaming?) or do I have to change a
lot of code to get inventrans correctly populated?
 
Is my appraoch advised/difficult?
 
Thanks
James
 


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













Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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] Type of selected datagrid fields.

2005-03-09 Thread Hans-Walter Bous 





Sorry,
but of course youe should use df.basType() to get the type of your field.
John

Hans-Walter Bous <[EMAIL PROTECTED]> wrote:

Hi,
try something like this:
DictTable dt = new Dicttable(tableid);
DictField  df = new DictField(dt.id(), fieldId);
;
df.type will return you the type of the field as enum (TYPES).
So enum2Value(df.type()) will give you the text of the type.
Best wishes
John

da_man812000 <[EMAIL PROTECTED]> wrote:


Hi group! I have a problem, can I recognized selected field type from
a datagrid where I only have fieldid and tableid. 
I have already tried to use typeof(anytype object) function, but I
don't have the physical table object and field. Is this right way?   







Yahoo! Groups SponsorADVERTISEMENT


-
Yahoo! Groups Links

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


    
-
Gesendet von Yahoo! Mail - Jetzt mit 250MB kostenlosem Speicher

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





Yahoo! Groups SponsorADVERTISEMENT


-
Yahoo! Groups Links

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


    
-
Gesendet von Yahoo! Mail - Jetzt mit 250MB kostenlosem Speicher

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













Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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] creation of extended data type and base enum

2005-03-09 Thread rozaini comel 






Hi There,

Does anyone knows how to create extended data type and append base enum by using codes? Please help me. Actually i have a problem with filteration, and i really this solution to make it work.

Thank you

Regards,
Rozie



SMILE 



__
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 Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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: Day - Month field

2005-03-09 Thread nicolaan 






Hmm, seems tricky (if possible).
You could use an extended data type and make it an array, but that's 
not so nice for this I think.

A normal date type is not an option? (just ignore the year part)

Maybe a normal date type or an integer type with 2 display or edit 
methods to show only the day and month part.
I assume you know display & edit methods, otherwise I'll be glad to 
explain.

Other then these options I wouldn't know.

Regards,

Nico

--- In development-axapta@yahoogroups.com, "gennarociulla" 
<[EMAIL PROTECTED]> wrote:
> 
> 
> Hi, i'm trying to create a field in a table that contains a Day -
> Month information. There's a way to do this (eg. an extended data
> type?) without split the two informations in a single field for 
each one?
> Thanks!















Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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: Outer join in X++

2005-03-09 Thread nicolaan 






Hi Matt,

I think this should work.

    while SELECT CUSTTABLE
    WHERE (ADDRESS.ADDRTABLEID == 77) &&
    (CUSTTABLE.MODIFIEDDATE > mkdate(1, 3, 2005))
    OUTER JOIN ADDRESS
    where CUSTTABLE.RECID == ADDRESS.ADDRRECID
    ADDRESS.ADDRESSTYPE == 'Invoice'

Axapta works different with joins.
First you define your "where clause" for the main table and after 
your join you specify an extra "where" with your join specifications.
So the 2nd where is your "on" keyword.

I searched for "outer join" in classes to get an example from Axapta.

Regards,

Nico

--- In development-axapta@yahoogroups.com, "Matt Benic" <[EMAIL PROTECTED]> 
wrote:
> 
> Hi all,
> I am trying to design a query in X++ which works in SQL. The SQL 
version is:
> 
> SELECT ADDRESS.*, CUSTTABLE.*
> FROM CUSTTABLE LEFT OUTER JOIN ADDRESS
> ON CUSTTABLE.RECID = ADDRESS.ADDRRECID
> WHERE (ADDRESS.ADDRTABLEID = 77) AND
>  (CUSTTABLE.MODIFIEDDATE > CONVERT(DATETIME, '2005-
03-01
> 00:00:00', 102)) AND
>  (ADDRESS.ADDRESSTYPE = 'Invoice')
> 
> Which returns a single row. I am trying to use the following in X++ 
and it
> returns every row:
> 
> while select custTable outer join address
> where (address.AddrTableId == tableNum(CustTable) &&
> address.AddrRecId == custTable.RecId) &&
>   (address.AddressType == "Invoice") &&
>   (custTable.modifiedDate > sinceDate ||
>    address.modifiedDate > sinceDate)
> { //do stuff with adddress and custTable }
> 
> I can't seem to find the equivalent of the 'on' keyword in X++, how 
would I
> achieve this? I don't want to manually go through each custTable 
record and
> do the check in X++, I would rather let the DB do the work.
> 
> Thanks,
> 
> Matt Benic
> Axapta and .Net Developer
> UTi Sun Couriers Division
> 
> "The universal aptitude for ineptitude
> makes any human accomplishment an incredible miracle."
> - Col. John P. Stapp
> www.smallfrymobile.com















Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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] Outer join in X++

2005-03-09 Thread Matt Benic 





Hi all,
I am trying to design a query in X++ which works in SQL. The SQL version is:

SELECT ADDRESS.*, CUSTTABLE.*
FROM CUSTTABLE LEFT OUTER JOIN ADDRESS
ON CUSTTABLE.RECID = ADDRESS.ADDRRECID
WHERE (ADDRESS.ADDRTABLEID = 77) AND
 (CUSTTABLE.MODIFIEDDATE > CONVERT(DATETIME, '2005-03-01
00:00:00', 102)) AND
 (ADDRESS.ADDRESSTYPE = 'Invoice')

Which returns a single row. I am trying to use the following in X++ and it
returns every row:

while select custTable outer join address
    where (address.AddrTableId == tableNum(CustTable) &&
    address.AddrRecId == custTable.RecId) &&
  (address.AddressType == "Invoice") &&
  (custTable.modifiedDate > sinceDate ||
   address.modifiedDate > sinceDate)
    { //do stuff with adddress and custTable }

I can't seem to find the equivalent of the 'on' keyword in X++, how would I
achieve this? I don't want to manually go through each custTable record and
do the check in X++, I would rather let the DB do the work.

Thanks,

Matt Benic
Axapta and .Net Developer
UTi Sun Couriers Division

"The universal aptitude for ineptitude
makes any human accomplishment an incredible miracle."
- Col. John P. Stapp
www.smallfrymobile.com













Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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] Type of selected datagrid fields.

2005-03-09 Thread Hans-Walter Bous 





Sorry,
of course you should then use enum2str(df.basetype()) instead of df.type
John

da_man812000 <[EMAIL PROTECTED]> wrote:


Hi group! I have a problem, can I recognized selected field type from
a datagrid where I only have fieldid and tableid. 
I have already tried to use typeof(anytype object) function, but I
don't have the physical table object and field. Is this right way?   







Yahoo! Groups SponsorADVERTISEMENT


-
Yahoo! Groups Links

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


    
-
Gesendet von Yahoo! Mail - Jetzt mit 250MB kostenlosem Speicher

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













Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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] Type of selected datagrid fields.

2005-03-09 Thread Hans-Walter Bous 





Hi,
try something like this:
DictTable dt = new Dicttable(tableid);
DictField  df = new DictField(dt.id(), fieldId);
;
df.type will return you the type of the field as enum (TYPES).
So enum2Value(df.type()) will give you the text of the type.
Best wishes
John

da_man812000 <[EMAIL PROTECTED]> wrote:


Hi group! I have a problem, can I recognized selected field type from
a datagrid where I only have fieldid and tableid. 
I have already tried to use typeof(anytype object) function, but I
don't have the physical table object and field. Is this right way?   







Yahoo! Groups SponsorADVERTISEMENT


-
Yahoo! Groups Links

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


    
-
Gesendet von Yahoo! Mail - Jetzt mit 250MB kostenlosem Speicher

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













Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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] Re: direct sql problem again

2005-03-09 Thread Arma 





thanks it worked.

onnobid <[EMAIL PROTECTED]> wrote:

Hi,

use a 2nd Statement object for the inner loop as shown below:



> Connection Con = new Connection();
> Statement Stmt = Con.createStatement();

//### STMT2 
> Statement Stmt2 = Con.createStatement();
//### STMT2 

> ResultSet R,R1;
> sql ='SELECT ACCOUNTNUM,ACCOUNTNAME,ACCOUNTPLTYPE,RECID FROM 
> LEDGERTABLE WHERE ACCOUNTNUM <= \'699\'ORDER BY ACCOUNTNUM';
>    R=Stmt.executeQuery(sql);
>    while (R.next())
>   {
> 
> acno1=R.getString(1);
> i = R.getInt(3);
> k= R.getString(4);
> if(strlen(acno1)==3)
> {
> if(i==LedgerAccountType::sum)
> {
> 
> sql = 'SELECT FROMACCOUNT,TOACCOUNT FROM 
> LEDGERTABLEINTERVAL WHERE ACCOUNTTABLEID ='+_tableId+' AND 
> ACCOUNTRECID = '+k+'';

//### STMT2 
> R1 =   Stmt2.executeQuery(sql);
//### STMT2 


> while(R1.next())
> {
> print R1.getString(1),' ',R1.getString(2),' ',k;
> pause;
> }
> 
> }
> else
> {
> //bl.
> }
>    }acno1
> } ledgertable2
> 
> it just takes the first value from the second resultset and then go 
> out of the loop.


Regards,
Onno







Yahoo! Groups SponsorADVERTISEMENT


-
Yahoo! Groups Links

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



    
-
Celebrate Yahoo!'s 10th Birthday! 
 Yahoo! Netrospective: 100 Moments of the Web 

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













Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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] AOS Client Error

2005-03-09 Thread chievaz_regalz 






Hi All,

does everybody have step by step installation server with AOS and 
client configuration to connect AOS ? please i need resolution.

because some time i connect to AOS trough client doesn't connect. i 
dont know why ?

thanks for your attention.

best regards

Chievaz

--- In development-axapta@yahoogroups.com, "Andrae, Tobias" 
<[EMAIL PROTECTED]> wrote:
> 
> use the client's directory as "application directory" for your 
client (e.g. c:\axapta\client)
>  
>  
> hth Tobias
> 
>   -Ursprüngliche Nachricht- 
>   Von: chievaz_regalz [mailto:[EMAIL PROTECTED] 
>   Gesendet: Do 03.03.2005 04:31 
>   An: development-axapta@yahoogroups.com 
>   Cc: 
>   Betreff: *SPAM* [development-axapta] AOS Client Error
>   
>   
> 
> 
> 
> 
>   Hai All,
>   
>   I need help ...
>   
>   I try to connect axapta client with AOS server. but 
everytime login
>   i get error in "illegal directory structure for axapta 
application".
>   then i map axapta application directory from server to server
>   \\servername\axapta application. thats get axapta run well 
with AOS
>   configuration. this mean that configuration same as with 2 
tier
>   configuration, WHY ??.
>   
>   i need connect with 3 tier configuration, so user doesn't 
need to
>   map axapta application directory from server. i need 
resolution ..
>   
>   thanks for your attention.
>   
>   chievaz regalz
>   
>   
>   
>   
>   
>   
>   
>   
>   
>   Yahoo! Groups Links
>   
>   
>   
>   
>   
>   
>   
>   
> 
> 
> 
> [Non-text portions of this message have been removed]















Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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] Type of selected datagrid fields.

2005-03-09 Thread da_man812000 






Hi group! I have a problem, can I recognized selected field type from
a datagrid where I only have fieldid and tableid. 
I have already tried to use typeof(anytype object) function, but I
don't have the physical table object and field. Is this right way?   















Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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 : [development-axapta] Delete enum

2005-03-09 Thread Daniel Redelinghuys 





Thanx,

Used these:

TN = TreeNode::findNode("Data
Dictionary\\Tables\\smmActivities\\Fields\\Status");
TN.AOTdelete();

TN = TreeNode::findNode("Data Dictionary\\Base
Enums\\smmActivityStatusGroup");
TN.AOTdelete();


--


Daniel J. Redelinghuys
Axapta Developer  UTi-Sun Couriers Division
Tel: +27 12 673 2324 Fax: +27 12 673 2344

--




-Original Message-
From: Steeve Gilbert [mailto:[EMAIL PROTECTED]
Sent: 08 March 2005 03:55 PM
To: development-axapta@yahoogroups.com
Subject: RE : [development-axapta] Delete enum




I would use TreeNode.AOTdelete().  Check in the dev help for more info on
TreeNode class.

Regards,

Steeve...


-Message d'origine-
De : Daniel Redelinghuys [mailto:[EMAIL PROTECTED]
Envoyé : 8 mars 2005 08:02
À : development-axapta@yahoogroups.com
Objet : [development-axapta] Delete enum



Hi All,

Can anyone please help with code to delete a enum value (the hole enum) from
the AOT (hole environment). I need to do this in a job after all instances
of that value has been move from the tables.

Thank you,


--

Daniel J. Redelinghuys
Axapta Developer  UTi-Sun Couriers Division
Tel: +27 12 673 2324 Fax: +27 12 673 2344

-


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







Yahoo! Groups Links













Yahoo! Groups Links




















Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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: direct sql problem again

2005-03-09 Thread onnobid 






Hi,

use a 2nd Statement object for the inner loop as shown below:



> Connection Con = new Connection();
> Statement Stmt = Con.createStatement();

//### STMT2 
> Statement Stmt2 = Con.createStatement();
//### STMT2 

> ResultSet R,R1;
> sql ='SELECT ACCOUNTNUM,ACCOUNTNAME,ACCOUNTPLTYPE,RECID FROM 
> LEDGERTABLE WHERE ACCOUNTNUM <= \'699\'ORDER BY ACCOUNTNUM';
>    R=Stmt.executeQuery(sql);
>    while (R.next())
>   {
> 
> acno1=R.getString(1);
> i = R.getInt(3);
> k= R.getString(4);
> if(strlen(acno1)==3)
> {
> if(i==LedgerAccountType::sum)
> {
> 
> sql = 'SELECT FROMACCOUNT,TOACCOUNT FROM 
> LEDGERTABLEINTERVAL WHERE ACCOUNTTABLEID ='+_tableId+' AND 
> ACCOUNTRECID = '+k+'';

//### STMT2 
> R1 =   Stmt2.executeQuery(sql);
//### STMT2 


> while(R1.next())
> {
> print R1.getString(1),' ',R1.getString(2),' ',k;
> pause;
> }
> 
> }
> else
> {
> //bl.
> }
>    }acno1
> } ledgertable2
> 
> it just takes the first value from the second resultset and then go 
> out of the loop.


Regards,
Onno















Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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] Printing Sales invoice

2005-03-09 Thread Michael Niemeyer 





Hi,

you can setup for sorting at:
Sales ledger/Setup/Forms/Formsorting

But that it works you must post the invoice with Print option/ Print == 
After.

Axapta then first post all invoices and insert theme in a 'list', after all 
invoices created they'll printout form this list with your sort order.


Regards Michael

>From: "anettemalmberg" <[EMAIL PROTECTED]>
>Reply-To: development-axapta@yahoogroups.com
>To: development-axapta@yahoogroups.com
>Subject: [development-axapta] Printing Sales invoice
>Date: Mon, 07 Mar 2005 13:59:31 -
>
>
>
>Hi
>
>Multiprinting of Sales invoice is sorting by SalesId. How can I
>modify this sorting so all Invoices will come out sortied by another
>field in SalesTable instead?
>Thanks
>
>
>
>
>
>
>














Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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] direct sql problem again

2005-03-09 Thread Pieter Wijnen 





Don't know about your actual problem but you should always include
dataareaid when querying against Axapta tables
Both to avoid getting data from other companies and to let the SQL
database use a index (if one is defined for your criteria)!
You also have to take into consideration wether string data is left
padded or not.
Generally speaking don't use direct sql against Axapta tabs unless
performance demands it, ie your using unsupported aggregate functions,
stored procedures/functions etc.
 
If your code is "real life", you don't need to use direct sql
 
HTH
Pieter
 

  _  

From: sema_armagan [mailto:[EMAIL PROTECTED] 
Sent: 8. mars 2005 17:00
To: development-axapta@yahoogroups.com
Subject: [development-axapta] direct sql problem again




Hello,

I am developing a report which should be written by using direct sql 
statements. I recognized a problem about direct sql if anybody helps 
me i will be very pleased. The problem is i could not write while 
loops one within the other.For example;

Connection Con = new Connection();
Statement Stmt = Con.createStatement();
ResultSet R,R1;
sql ='SELECT ACCOUNTNUM,ACCOUNTNAME,ACCOUNTPLTYPE,RECID FROM 
LEDGERTABLE WHERE ACCOUNTNUM <= \'699\'ORDER BY ACCOUNTNUM';
   R=Stmt.executeQuery(sql);
   while (R.next())
  {

    acno1=R.getString(1);
    i = R.getInt(3);
    k= R.getString(4);
    if(strlen(acno1)==3)
    {
    if(i==LedgerAccountType::sum)
    {

    sql = 'SELECT FROMACCOUNT,TOACCOUNT FROM 
LEDGERTABLEINTERVAL WHERE ACCOUNTTABLEID ='+_tableId+' AND 
ACCOUNTRECID = '+k+'';
    R1 =   Stmt.executeQuery(sql);
    while(R1.next())
    {
    print R1.getString(1),' ',R1.getString(2),' ',k;
    pause;
    }

    }
    else
    {
//bl.
    }
   }acno1
    } ledgertable2

it just takes the first value from the second resultset and then go 
out of the loop.

best wishes...
  








Yahoo! Groups Sponsor  
ADVERTISEMENT
click here
   
 
   

  _  

Yahoo! Groups Links


*  To visit your group on the web, go to:
  http://groups.yahoo.com/group/development-axapta/
    
*  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]













Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

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

Reporting tools for large number of reccords WAS: [development-axapta] Problem with Axapta 2.5 SP4 on Oracle

2005-03-09 Thread Rudi Hansen 





When we have customers with large number of records, we use a
statistical module we have developed for Axapta.

This module creates summation data from the large tables, ex
LedgerTrans, and then we use these data for reporting in Axapta.



  From: Willem Baelde [mailto:[EMAIL PROTECTED] 
  Sent: 8. marts 2005 14:53
  To: development-axapta@yahoogroups.com
  Subject: Re: [development-axapta] Problem with Axapta 2.5 SP4 on
Oracle
  
  Hello,
  
  I am quiet curious what kind of reporting tool your
  company is using ? We have also Axapta but we have
  each year about 10 mio records in the ledger trans
  table. We are still looking for the right solution.
  
  Kind regards,
  
  Willem
  













Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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] direct sql problem again

2005-03-09 Thread SAS 





Dear Sema ,
I think it's better you create procedure  and put all sql statement on that
procedure , and then you just call the procedure ..

- Original Message - 
From: "sema_armagan" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, March 08, 2005 10:59 PM
Subject: [development-axapta] direct sql problem again


>
>
>
> Hello,
>
> I am developing a report which should be written by using direct sql
> statements. I recognized a problem about direct sql if anybody helps
> me i will be very pleased. The problem is i could not write while
> loops one within the other.For example;
>
> Connection Con = new Connection();
> Statement Stmt = Con.createStatement();
> ResultSet R,R1;
> sql ='SELECT ACCOUNTNUM,ACCOUNTNAME,ACCOUNTPLTYPE,RECID FROM
> LEDGERTABLE WHERE ACCOUNTNUM <= \'699\'ORDER BY ACCOUNTNUM';
>    R=Stmt.executeQuery(sql);
>    while (R.next())
>   {
>
> acno1=R.getString(1);
> i = R.getInt(3);
> k= R.getString(4);
> if(strlen(acno1)==3)
> {
> if(i==LedgerAccountType::sum)
> {
>
> sql = 'SELECT FROMACCOUNT,TOACCOUNT FROM
> LEDGERTABLEINTERVAL WHERE ACCOUNTTABLEID ='+_tableId+' AND
> ACCOUNTRECID = '+k+'';
> R1 =   Stmt.executeQuery(sql);
> while(R1.next())
> {
> print R1.getString(1),' ',R1.getString(2),' ',k;
> pause;
> }
>
> }
> else
> {
> //bl.
> }
>    }acno1
> } ledgertable2
>
> it just takes the first value from the second resultset and then go
> out of the loop.
>
> best wishes...
>
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>














Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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] Day - Month field

2005-03-09 Thread gennarociulla 






Hi, i'm trying to create a field in a table that contains a Day -
Month information. There's a way to do this (eg. an extended data
type?) without split the two informations in a single field for each one?
Thanks!















Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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] Printing Sales invoice

2005-03-09 Thread James Flavell 





Hi all,

Posted next is the Dx Harry and I had sometime ago on teh other group about
this form sort (take care it only works for 'After' setting...read on).
Hope it helps and of course if not then post back :)



Dx from sometiem ago:

Hey thanks alot Harry,

That is why I could not get it to work! At least now I can get the sort to
work rather than wonder whether it was some nice idea by some programmer
that never quite got off the ground ;)

'After' I believe is strictly just the printout so your thoughts about a
problem after a few have been processed, I don't think anything is done.
>From my understanding 'After' is more for batch update over night but you
dont wnat to send it to the printer as if the print jams or low toner etc
there is noone there to check and so you could come back in the morning and
find that you just wasted sheets and sheets of paper etc...

Thanks alot for your time and input, really appreciate it (I dont think I
would have got around to testing the 'after' ...more likely to have given
up!!!)

Thanks
James

-Original Message-
From: Harry Deshpande [mailto:[EMAIL PROTECTED]
Sent: Monday, August 09, 2004 7:50 AM
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Form sort used for what?


Hi James



First of all... if you want to apply a different sort order then you
have to finger around with newJournalList method of class
salesFormLetter_PickingList. 



Now to your question as to why this is not working for you...



To be very honest, I did not try this out. However, I have a feeling as
to why this is not working out for you.



Axapta as two methods of printing the picking lists.



First method is print pickinglist one by one as soon as they are
processed. Represented by Printout=current on salesEditLinesForm.



Second method is print pickinglists after they are processed.
Represented by Printout = after on salesEditLinesForm.



Obviously the sort will not work if Printout = current, since picking
lists are being printed as soon as they are processed.



I do not think you cannot change the value of printout manually. This
can be changed in the update method of class salesformletter



    this.initParameters(salesParmUpdate,

    PrintOut::Current);  // Printout



I have not made a study of why this has been set as current in standard
Axapta and the implications of setting printout to "after". (for eg. If
the picking list operations fails after processing 5 picking lists then
whether the previous picking lists are reversed and if they are not
reversed and there is a system failure then picking lists will not be
printed etc etc.)



However,in order for the formSort to work this value will have to be set
to "after".



Another option which you may want to look at will be to change the order
in which picking list are processed.



Hope this helps



Regards



harry







  _  

From: James Flavell [mailto:[EMAIL PROTECTED] 
Sent: Saturday, 7 August 2004 11:28 a.m.
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Form sort used for what?



Thanks very much Harry,

Your example situation is a very good one and one that had not really
crossed my mind :)  my situation is very similar in that I want to make
sure
the warehouse pick priority customer stock first and therefore want the
picking instructions to appear in customer prioirty order.  I would
refer
the pick instruction number to be assigned in this order as it is more
full
proof but if it cannot then the print out in that order is the next best
thing.

Can you tell me exactly what you set to get it to work and what you did
to
test it worked?  Like I said I have v3.0 SP2 and have set a sort but
dont
seem to get the printouts in that order (did you print to screen or
printer...although I believe I should still be able to see the effect on
the
screen...)

Thank you
James


-Original Message-
From: Harry Deshpande [mailto:[EMAIL PROTECTED]
Sent: Friday, August 06, 2004 6:03 AM
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Form sort used for what?


Hi



The questions still unanswered are:
1) Is the sort applied before or after the invoice number is assigned?
i.e.
can this sort influence the number assigned to a journal or does it only
come into effect after each journal has been created (strictly the
prinout)



** The sort cannot influence the number assigned to the journal and the
sort is applied after the invoice number is assigned.



can actually get it to work and maybe who actually uses this in a real
life
situation and if so can you add your input please :)




** Ummm, I do not know anyone who has used it but I can guess of a
scenario...

accounts department prints all the invoices during the night and the
clerk files the invoices in the morning. Now if the invoices are being
filed in alphabetical order (customer code or name) then you would sort
them on that field. If the invoices are being file