RE: Re[2]: [development-axapta] Visual Source Safe + Axapta Projects

[Don Price]

Hi Max,

  Is that presentation on PartnerSource? Or ?

Thanks,
Don

-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Max Belugin
Sent: Monday, April 18, 2005 1:07 AM
To: Don Price
Subject: Re[2]: [development-axapta] Visual Source Safe + Axapta
Projects




Hello Don Price,

воскресенье, 17 апреля 2005 г., you wrote:
DP> What have you seen for Axapta 4?
DP> have seen nothing for VC.

The presentation contains words about version control and unit testing
in Ax4

-- 
Best regards,
 Max

http://belugin.info ICQ:9406811






 
Yahoo! Groups Links



 








 
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:
http://docs.yahoo.com/info/terms/
 

RE: [development-axapta] Visual Source Safe + Axapta Projects

[Don Price]

What have you seen for Axapta 4?  I'd be very intrested as thus far I
have seen nothing for VC.

Thanks,
Don

-Original Message-
From: Matt Benic [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 14, 2005 1:36 AM
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Visual Source Safe + Axapta Projects




Hi Brandon,
The closest we have been able to get to that is exporting entire
projects and adding those to source control (the XPO files are just
plain text), but that obviously does not preserve the state of all other
objects. Source control in Axapta dev is actually sorely lacking, and
your best bet is to regularly back up your entire object repository.
Axapta 4 will apparently include better source control (possibly
integration with VSS).

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: Brandon George [mailto:[EMAIL PROTECTED]
Sent: 13 April 2005 08:38 PM
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Visual Source Safe + Axapta Projects





Hello All,

 I know I am full of questions today! Anyway, has anyone ever used
Axapta Projects / Code with Visual Source Safe. We use VSS for all of
our ASP.Net / C# projects, and we would love to be able to continue to
use VSS for version control / backups, etc.

Anyway any help in that Dept. would be great!

Thanks,
Brandon







Yahoo! Groups Links













 
Yahoo! Groups Links



 















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] XP SP2

[Don Price]

Thanks  Matt and Jens - 


I upgraded to SP2 and checked a few things and everything seems well.

Thanks much.  - Just needed a push :)

Don

-Original Message-
From: Jens Strandberg [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 03, 2004 9:55 AM
To: [EMAIL PROTECTED]
Subject: SV: [development-axapta] XP SP2



Hello there,

I have had no problems with Axapta 3.0 SP3 on XP SP2...

/Jens
  -Oprindelig meddelelse-
  Fra: Don Price [mailto:[EMAIL PROTECTED]
  Sendt: 3. december 2004 14:49
  Til: [EMAIL PROTECTED]
  Emne: [development-axapta] XP SP2



  Hi,

    Does anyone know off-hand if XP SP2 crashes/breaks any versions of
  Axapta? Like 2.5 and 3.0 specifically.

    I'd like to put on my machine, but I can't take a risk of breaking
my
  various copies of Axapta.

  Thanks,
  Don


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





    Yahoo! Groups Sponsor
  ADVERTISEMENT







--
  Yahoo! Groups Links

    a.. To visit your group on the web, go to:
    http://groups.yahoo.com/group/development-axapta/

    b.. To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

    c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.



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







 
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] XP SP2

[Don Price]

Hi,
 
  Does anyone know off-hand if XP SP2 crashes/breaks any versions of
Axapta? Like 2.5 and 3.0 specifically.
 
  I'd like to put on my machine, but I can't take a risk of breaking my
various copies of Axapta. 
 
Thanks,
Don


[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] Wierd Excel COM behavior

[Don Price]

Hi Matt,

  Why are you passing in the variant? I took a quick look at one of our
classes and we just call the add with no parms. Maybe Office 2003
requires your parm?  

Don

-Original Message-
From: Matt Benic [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 04, 2004 9:27 AM
To: Axapta Dev
Subject: [development-axapta] Wierd Excel COM behavior



Hi there,
We have a report that is explicitly written to an excel file (rather
than
using the query engine). This report has been running fine until we made
some changes last week. Now it works on our dev and test systems, but
crashes on our live system. It fails on addition of a workbook to a
workbooks object:

in class CreateCreditNoteCustTransExcel that extends
SysExcelApplication_2000:

    //Get workbooks object from the app
    workbooks = application.workbooks();

    //Add a new workbook
    variant.int(-4167);
    workbook = workbooks.add(variant); <-- crashes here

Any idea why this would happen? The crash is so bad that the client
crashes,
but does not happen if the client is connecting to our dev or test
system. I
cannot debug into this line and there is no useful output (just the
error
message below):
"Your Navision Axapta session cannot continue due to a fatal error
condition. An Unrecoverable error occurred while the Object Server tried
to
process the last request. Please start again and retry the operation. If
the
problem persists please notify your Navision Axapta administrator."
There is nothing in the log folder or in the app or sys event logs.


Regards,

Matt Benic
Axapta Developer
UTi Sun Couriers Division

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







 
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.

RE: [development-axapta] Axapta Source control

[Don Price]

As Koen said I'm beta testing a solution currently with integration to
SourceGear's Vault. 
http://home.comcast.net/~axaptacoder/ddpVault/ddp_vault.htm

with discussions on axaptalink.com.

Thanks,
Don





-Original Message-
From: Steve Wright [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 29, 2004 6:24 AM
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] Axapta Source control


Take a look at www.keyzonesolutions.com
 
 
http://www.keyzonesolutions.com/Solutions/Product%20announcements/Axapta
%20V
ersion%20Control.aspx
 
 
 
This source code control is a full commercial product for Axapta,
integrating into VSS. 
 
S

  _  

From: govaersk [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 29 September 2004 5:54 PM
To: [EMAIL PROTECTED]
Subject: Re:[development-axapta] Axapta Source control


preview fell off

http://home.comcast.net/~axaptacoder/ddpVault/ddp_vault.htm
 

--- In [EMAIL PROTECTED], "govaersk" 
<[EMAIL PROTECTED]> wrote:
> ddpsoft is currently beta testing On Axapta Source Control
> 
> the preview: [development-axapta] Axapta Source control
> the discussion www.axaptalink.com Forums ddpVault
> 
> Greetings
> 
> Koen




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 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] Project Traverse

[Don Price]

Does anybody have an example of how to traverse a project? 
 
Thanks,
Don


[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] Locks - Icons and properties - Update?

[Don Price]

Hi,
 
  When I insert a record lock via utilLocks, the record shows up
immediately in the table, but the object icon and property lock by does
not update immediately. I know there is a User Option setting to
refresh, but don't seem to work. It seems like there is a slow thread
that updates these.  The lock / unlock from the context menu does update
these immediate, but these seem to be kernel code.  
 
Besides shutting down Axapta, does anyone know to update these? 
 
My application would be much more effective with this working correctly.
 
Thanks,
Don


[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] Terminal Services and printing to a file

[Don Price]

Afaik, just ts.

-Original Message-
From: Andrew Vranjes [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 22, 2004 7:41 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: [development-axapta] Terminal Services and printing to a
file

Hello,

 

Does this utility work with Citrix??

 

 

 

Andrew Vranjes 
IT Support Officer 
Metric Australia Pty Ltd 

  _  

From: Don Price [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 23 September 2004 1:20 AM
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] Terminal Services and printing to a
file

 

Yes we do, we use a free utility called TSDropCopy
http://www.analogx.com/contents/download/system.htm


-Original Message-
From: missylovestexas [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 22, 2004 11:38 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] Terminal Services and printing to a file

Does anyone access Axapta through Terminal Services?  If so how to 
you take care of saving a file to your local computer?  

Thanks, 
Michelle






Yahoo! Groups Links











Yahoo! Groups Sponsor



ADVERTISEMENT
 
<http://us.ard.yahoo.com/SIG=1292ij643/M=295196.4901138.6071305.3001176/
D=gr
oups/S=1705006764:HM/EXP=1095965684/A=2128215/R=0/SIG=10se96mf6/*http:/c
ompa
nion.yahoo.com> click here


 
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=
:HM/A=2128215/rand=570017273> 

 

  _  

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!
<http://docs.yahoo.com/info/terms/>  Terms of Service. 



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





 
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.

RE: [development-axapta] Terminal Services and printing to a file

[Don Price]

Actually I should clarify this, its just a file utility. You can't use
it in an app. But if you are moving xpos, documents or whatever its
great little utility.  You run the utility on the ts connection and on
your machine. You set the ip address to the ts connection address and
set a directory and then you can just drag n drop. 

-Original Message-
From: Michelle Thompson [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 22, 2004 3:22 PM
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] Terminal Services and printing to a
file

Does this also work when you are using a published application?
 
Thanks so much!

Don Price <[EMAIL PROTECTED]> wrote:

Yes we do, we use a free utility called TSDropCopy
http://www.analogx.com/contents/download/system.htm


-Original Message-
From: missylovestexas [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 22, 2004 11:38 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] Terminal Services and printing to a file

Does anyone access Axapta through Terminal Services? If so how to 
you take care of saving a file to your local computer? 

Thanks, 
Michelle






Yahoo! Groups Links










Yahoo! Groups Links









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





 
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.

RE: [development-axapta] Terminal Services and printing to a file

[Don Price]

Yes we do, we use a free utility called TSDropCopy
http://www.analogx.com/contents/download/system.htm


-Original Message-
From: missylovestexas [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 22, 2004 11:38 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] Terminal Services and printing to a file

Does anyone access Axapta through Terminal Services?  If so how to 
you take care of saving a file to your local computer?  

Thanks, 
Michelle





 
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.

RE: [development-axapta] Re: SQL vs Query engine

[Don Price]

Hey cool learned something today. Thanks!

-Original Message-
From: bmp_thydatacenter_dk [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 22, 2004 12:31 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] Re: SQL vs Query engine

You can set up this range in a query.

The rule is that if a range value start with a "(" the contents of 
the range is an _expression_ in X++ syntax. You can make a range on 
the custTrans datasource on a random field and set the value to:

(AmountMST != SettleAmountMST)

Best regards,
Bjørn Møller Pedersen
Thy Data Center Development A/S

--- In [EMAIL PROTECTED], "Don Price" 
<[EMAIL PROTECTED]> wrote:
> >.custTrans.AmountMst != custTrans.SettleAmountMST)
> Are you sure you have this set via a range in the report?
> 
> The rest of those ranges you could setup in the query without 
code, but
> Not this one.
> 
> Don
> 
> -Original Message-
> From: bmp_thydatacenter_dk [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, September 21, 2004 2:23 PM
> To: [EMAIL PROTECTED]
> Subject: [development-axapta] Re: SQL vs Query engine
> 
> I can't figure out why your approach is not working from you 
> description.
> 
> But an approach I have used many times is to use a temporary table 
> as a middle tier between feching the data from the database and 
> sending the data to the design. This gives the oppertunity to 
focus 
> on the database communication regardless of the wanted sequence of 
> data in the design of the report.
> 
> Best regards,
> Bjørn Møller Pedersen
> Thy Data Center Development A/S
> 
> --- In [EMAIL PROTECTED], "Matt Benic" 
> <[EMAIL PROTECTED]> wrote:
> > Hi all,
> > I'm going nuts trying to get a report to work. My requirement is 
> to return a
> > summary of all unsettled credit notes and payments per customer, 
> grouped by
> > credit controller (dimension[5]).
> > 
> > Seems easy enough, set up a report using custtable and custtrans 
> joined on
> > the customer number, use a variable to sum up the total 
> outstanding amount,
> > and use a programmable section to display it all. Except it 
doesnt.
> > I have set up such a report, using ranges on the amountMST, 
> transdate and
> > dimension[5], but when I compare the values with those obtained 
by 
> using the
> > SQL below in the table browser, the totals of the resulting 
> transactions
> > dont even come close to matching. Any suggestions?
> > 
> > SELECT * FROM CustTrans
> > where (custtrans.accountnum == "003556") &&
> > (custtrans.amountMst < 0) &&
> > (custTrans.AmountMst != custTrans.SettleAmountMST) &&
> > (custtrans.transdate < 31\10\2004)
> > 
> > (I have omitted the dimension[5] part of the where clause since 
it 
> does not
> > affect the returned values.. each customer is managed by a 
single 
> credit
> > controller)
> > 
> > Regards,
> > 
> > Matt Benic
> > Axapta Developer
> > UTi Sun Couriers Division
> > 
> > "The universal aptitude for ineptitude
> > makes any human accomplishment an incredible miracle."
> > - Col. John P. Stapp
> 
> 
> 
> 
>  
> 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.

RE: [development-axapta] Re: SQL vs Query engine

[Don Price]

>.custTrans.AmountMst != custTrans.SettleAmountMST)
Are you sure you have this set via a range in the report?

The rest of those ranges you could setup in the query without code, but
Not this one.

Don

-Original Message-
From: bmp_thydatacenter_dk [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 21, 2004 2:23 PM
To: [EMAIL PROTECTED]
Subject: [development-axapta] Re: SQL vs Query engine

I can't figure out why your approach is not working from you 
description.

But an approach I have used many times is to use a temporary table 
as a middle tier between feching the data from the database and 
sending the data to the design. This gives the oppertunity to focus 
on the database communication regardless of the wanted sequence of 
data in the design of the report.

Best regards,
Bjørn Møller Pedersen
Thy Data Center Development A/S

--- In [EMAIL PROTECTED], "Matt Benic" 
<[EMAIL PROTECTED]> wrote:
> Hi all,
> I'm going nuts trying to get a report to work. My requirement is 
to return a
> summary of all unsettled credit notes and payments per customer, 
grouped by
> credit controller (dimension[5]).
> 
> Seems easy enough, set up a report using custtable and custtrans 
joined on
> the customer number, use a variable to sum up the total 
outstanding amount,
> and use a programmable section to display it all. Except it doesnt.
> I have set up such a report, using ranges on the amountMST, 
transdate and
> dimension[5], but when I compare the values with those obtained by 
using the
> SQL below in the table browser, the totals of the resulting 
transactions
> dont even come close to matching. Any suggestions?
> 
> SELECT * FROM CustTrans
> where (custtrans.accountnum == "003556") &&
> (custtrans.amountMst < 0) &&
> (custTrans.AmountMst != custTrans.SettleAmountMST) &&
> (custtrans.transdate < 31\10\2004)
> 
> (I have omitted the dimension[5] part of the where clause since it 
does not
> affect the returned values.. each customer is managed by a single 
credit
> controller)
> 
> Regards,
> 
> Matt Benic
> Axapta Developer
> UTi Sun Couriers Division
> 
> "The universal aptitude for ineptitude
> makes any human accomplishment an incredible miracle."
> - Col. John P. Stapp




 
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.

RE: [development-axapta] Documentation of classes and tables

[Don Price]

I think this a very good idea. If we wait on MBS, it will be whatever
project Green ends up being called or I'll be retired ;)

I would be willing to contribute.

Not really the same as you're talking about but in that general
direction, I started a newbie tutorial at: 
http://home.comcast.net/~axaptacoder/AxTutor/axapta_development.htm

Thanks,
Don

-Original Message-
From: mca_prog [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 14, 2004 7:04 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] Documentation of classes and tables

Hi,

90% of the classes and tables in Axapta aren't documented. Here i 
mean that there is no "developers documentation". That doesn't make 
the axapta-life easier!!

So I was wondering if there are peaople who want to setup a project 
of some kind to get the documentation as complete as possible. Maybe 
some of you have already some classes/tables documented. Others 
could split up the work so that we have a better documented Axapta 
environment in the end. It's maybe impossible to document 
everything, but even 50% documentation is much much better then the 
current situation.

Does somebody have ideas or suggestions about this? Are there enough 
people willing to cooperate?

Please let me know what you all think about this.

Regards,
Mca





 
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.

RE: [development-axapta] Re: selectForUpdate SelectLocked

[Don Price]

Hi Karsten,

 Thanks for the information, but that has me a little confused, when you
say: You should only use this method when unconsistent data can be 
tolerated.

This method is being called in the static SalesTable::Find method, I
would expect you wouldn't want inconsistent data here. 

What happens when two users call this method
Ie
 user A reads record 1.
 User B reads record 1.
 User A updates field 1,3 and calls update
 User B updates field 1,2 and calls update
  
I would suspect field 3 update is lost?



Thanks,
Don

-Original Message-
From: kwc_thydev [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 09, 2004 4:29 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] Re: selectForUpdate SelectLocked

Hi,

This method is only active on MS-SQL where it can be used to switch 
to uncommitted read mode which will not be blocked by other users 
having locks on the desired data. Default is that reads are blocked 
by other users having update locks on the desired data. 

You should only use this method when unconsistent data can be 
tolerated.

On MS-SQL writer blocks reader - meaning that any uncomitted writes  
will block the reader in case of eg. a table scan.

Best regards,

Karsten Wollesen Clausen
Thy Data Center Development A/S

--- In [EMAIL PROTECTED], "Don Price" 
<[EMAIL PROTECTED]> wrote:
>    If you at the salesTable method Find, there is a new function 
called
> selectLocked, has anybody used this before. I typically use
> selectforupdate. If you look at the context help for the 
parameters it
> appears to be different lock types, one exclusive one shared. 
Don't know
> why you would put on two different lock types?
>  
> salesTable.selectForUpdate(_forUpdate);
> salesTable.selectLocked(    (_forUpdate);
>  
> Interesting enough InventTable and Custtable finds do not do the
> selectLocked.
>  
> Can anybody set me straight on this? 
>  
> Thanks,
> Don
> 
> 
> [Non-text portions of this message have been removed]




 
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] selectForUpdate SelectLocked

[Don Price]

   If you at the salesTable method Find, there is a new function called
selectLocked, has anybody used this before. I typically use
selectforupdate. If you look at the context help for the parameters it
appears to be different lock types, one exclusive one shared. Don't know
why you would put on two different lock types?
 
salesTable.selectForUpdate(_forUpdate);
    salesTable.selectLocked(    (_forUpdate);
 
Interesting enough InventTable and Custtable finds do not do the
selectLocked.
 
Can anybody set me straight on this? 
 
Thanks,
Don


[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] EDI in Axapta

[Don Price]

Hi Tomasz,

Not sure what country you're in, but in the US the EDI/ABRA is now in
the DIS layer available from MBS.  You will need to get the license
codes from them and it handles several types of documents, ie 850,810
etc. You will need to do some formatting of various edi classes to get
the outputs to match your edi specs.

Don Price


-Original Message-
From: Tomasz Dudek [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 19, 2004 8:08 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] EDI in Axapta


Hello
Our customer asks us for EDI features in Axapta. I found
"EDIFACTsegments_AT" class with EDI segments definitions, but no any
other.
Has Axapta any features for EDI document exchange? Any license codes or
feature keys or configuration key have to be enabled? Perhaps should I
import additional code?

Has Anybody experience with implementing EDI in Axapta? I will glad for
any
suggestions.

Thanks.

Tomasz Dudek
[EMAIL PROTECTED]






 
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.

RE: [development-axapta] Lock of TreeNode

[Don Price]

Thanks Lars,
 
 I am now able to get the treenode to lock, but as you point out it
doesn't update the aot icon or locked by.  It will eventually refresh
this, using the auto-refresh under user-options, I guess, but it seems
very sporadic on when it does this.  The kernel must explicitly refresh
this when you lock/unlock via normal menu.  I tried various(current and
parent) aotRefresh but no luck to get this to update sooner. I even
tried the aod refresh.


Don

 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 12, 2004 6:57 AM
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] Lock of TreeNode

Hi Don,
 
 
It seems as the AOT element is still displayed as locked in the AOT when
it is deleted in the UtilLocks table (found here: menu Tools, Dev.
tools, Appl. objects, Locked appl. objects). But if you restart Axapta,
the AOT is updated with the correct information. The job below sets the
first table as locked. You can change the treenode path (or use your own
tree node) to change the locked element.
 
static void LockAOTElement(Args _args)
{
    UtilElements    utilElements;
    UtilLocks   utilLocks;
    #AOT
    ;
 
    utilElements    =
xUtilElements::findTreeNode(infolog.findNode(#TablesPath + "
 \\").AOTfirstChild());
    utilLocks   = utilElements ?
xUtilElements::utilLocks(utilElements) : utilLocks;
 
    if (!utilLocks)
    {
    utilLocks.initValue();
    utilLocks.Name  = utilELements.Name;
    utilLocks.recordType    = utilElements.recordType;
    utilLocks.parentId  = utilElements.parentId;
    utilLocks.lockedBy  = curUserId();
    utilLocks.insert();
    }
}
 
//Lars
 

-Original Message-
From: Don Price [mailto:[EMAIL PROTECTED]
Sent: 12. august 2004 13:05
To: [EMAIL PROTECTED]
Subject: [development-axapta] Lock of TreeNode


Hi,

  Does anybody know how to lock a treeNode object?  What I want to do is
the same functionality if you were to lock/unlock an object from the
aod, but I can't find it.

Thanks,
Don


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



Yahoo! Groups Sponsor  

ADVERTISEMENT
 
<http://us.ard.yahoo.com/SIG=129i135cm/M=298184.5285298.6392945.3001176/
D=groups/S=1705006764:HM/EXP=1092396346/A=2164330/R=0/SIG=11eamf8g4/*htt
p://www.netflix.com/Default?mqso=60183350> click here  
 
<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=group
s/S=:HM/A=2164330/rand=914636614>   


  _  

Yahoo! Groups Links


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




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




 
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] Lock of TreeNode

[Don Price]

Hi,
 
  Does anybody know how to lock a treeNode object?  What I want to do is
the same functionality if you were to lock/unlock an object from the
aod, but I can't find it.
 
Thanks,
Don


[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] QueryRange expressions

[Don Price]

You could write an x++ select using like to extract all the recids that
matched your select and then set a queryrange on the recids. If you go
more than 255 I think? You would just add a second range on recid again
keeping adding recids.  You might want to set some sort of max recs.  



-Original Message-
From: wohegro [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 07, 2004 6:19 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] QueryRange expressions

hi all,

does anybody have a solution for the following problem:
I want to build a query (on runtime) with several rangefields.
all rangesfields are text-fields (!).
I want to OR all the ranges as described in technet

http://technet.navision.com/default.asp?
MenuFunctionName=EISNewsArticle&MenuFunctionType=Output&NEWSID=351

all works well if the value for the ranges are defined like
 ((MyField1 == "Rin") || (MyField2 == "Tin") || (MyField3 
== "Tin"))

BUT I can't make it run when using wildcards ("*" and "?") like
 ((MyField1 == "R*") || (MyField2 == "T*") || (MyField3 == "T*"))

any ideas...?

thank's in advance!
wolfgang




 
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.

RE: [development-axapta] TS versus Citrix

[Don Price]

Well not that I'm expert but TS came from Citrix(MS bought the
technology from Citrix), so the technology should be the same. I thought
Citrix Metaframe was just an enhanced client/management. 

Don

-Original Message-
From: James Flavell [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 30, 2004 5:27 PM
To: [EMAIL PROTECTED]
Subject: [development-axapta] TS versus Citrix

Can someone just put me on the right path as to the main differences
with
just a Terminal Server client and a Cytrix client... I have been told TS
requires higher bandwidth per client but have not found anywhere that
explains when TS is enough and when Citrix should be used etc...

Thanks

  -Original Message-
  From: Don Price [mailto:[EMAIL PROTECTED]
  Sent: Thursday, July 01, 2004 1:25 AM
  To: [EMAIL PROTECTED]
  Subject: RE: [development-axapta] Remote connection: AOS versus Citrix


  You should only use the AOS if you have low lats. Anything above 40ms
  will be noticed, even though I think somewhere in the docs say 100ms.
  Citrix doesn't care about lats, but you need good bandwidth. We have
  clients that are having issues with remote clients that connect to via
  aos where the pings are over 40ms but still under the advertised
100ms.
  3.0 especially, wasn't quite as bad on 2.5.

  -Original Message-
  From: Morten Aasheim [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, June 29, 2004 10:01 AM
  To: [EMAIL PROTECTED]
  Subject: RE: [development-axapta] Remote connection: AOS versus Citrix

  All I can say that Citrix is possibly faster than AOS, but you should
  use
  AOS and thin-clients on the Citrix-server, otherwise you would
overload
  the
  server easily.

  Morten

  -Original Message-
  From: icydeepbluebacardy [mailto:[EMAIL PROTECTED]
  Sent: 29. juni 2004 11:57
  To: [EMAIL PROTECTED]
  Subject: [development-axapta] Remote connection: AOS versus Citrix

  Hi there,

  Need advise from anyone who has experience in implementing remote
  connection for Axapta.

  Looking at AOS versus Citrix with 64Kbps bandwidth, which one is
  faster in performance?

  Regards,
  Frenky






  Yahoo! Groups Links













  Yahoo! Groups Links







    Yahoo! Groups Sponsor
  ADVERTISEMENT







--
  Yahoo! Groups Links

    a.. To visit your group on the web, go to:
    http://groups.yahoo.com/group/development-axapta/

    b.. To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

    c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.



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





 
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.

RE: [development-axapta] Remote connection: AOS versus Citrix

[Don Price]

You should only use the AOS if you have low lats. Anything above 40ms
will be noticed, even though I think somewhere in the docs say 100ms.
Citrix doesn't care about lats, but you need good bandwidth. We have
clients that are having issues with remote clients that connect to via
aos where the pings are over 40ms but still under the advertised 100ms.
3.0 especially, wasn't quite as bad on 2.5.

-Original Message-
From: Morten Aasheim [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 29, 2004 10:01 AM
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] Remote connection: AOS versus Citrix

All I can say that Citrix is possibly faster than AOS, but you should
use
AOS and thin-clients on the Citrix-server, otherwise you would overload
the
server easily.

Morten

-Original Message-
From: icydeepbluebacardy [mailto:[EMAIL PROTECTED] 
Sent: 29. juni 2004 11:57
To: [EMAIL PROTECTED]
Subject: [development-axapta] Remote connection: AOS versus Citrix

Hi there,

Need advise from anyone who has experience in implementing remote 
connection for Axapta.

Looking at AOS versus Citrix with 64Kbps bandwidth, which one is 
faster in performance?

Regards,
Frenky





 
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.

RE: [development-axapta] Integrating Ax with another system

[Don Price]

Hi Baran,

  I use to work at aggregate company that did this very thing. The scale
head had connected to the pc via serial port and provided a continuous
stream just like yours.  What I did was write a c program (dll), that
basically opened the port continuously reading the data. Then I would
align based the data structure pulling out the weight everytime I could
align properly. Then I provided a function that the internal system
(not-Axapta) that would call thru a button click method to get the
weight. 

Don

-Original Message-
From: Baran Sasmaz [mailto:[EMAIL PROTECTED] 
Sent: Monday, June 14, 2004 7:27 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] Integrating Ax with another system

Hi,
 
I have to integrate my axapta with another system. This system is a
"weighing machine" system. 
 
The weigh-bridge calculates the truck's weight continuously. We must get
the empty and full weight of the truck by a button click or another way.

 
Do u know or did u before work in this area. I have to do somewhat like
getting a value (in a button click) from an emulation program or  a
barcode program and finally insert it in a grid area in  my Axapta Form.
 
Thanks in advance for your advices and shared experiences. 

    
-
Do you Yahoo!?
Friends.  Fun. Try the all-new Yahoo! Messenger

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




 
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.

RE: [development-axapta] label printing

[Don Price]

Hi Akash,

>> But its giving me compilation error at this line
>>"comBTFormats.Open(LocationLabel.text(),true,"");"  

This code assumes your calling from a form with a string control named
LocationLabel. If you're calling from someplace else, ie a class then
you replace with the locationLabel.text() with a variable name that is
storing your label filename in a string or hard code it(Eek). 

If you're getting a compilation error in Axapta, then it's a syntax
thing.
An actual issue with Bartender will give you a runtime activex error,
like if you call a bad method or pass bad args etc. 

Hope this helps, otherwise tell me where you're trying to put this code
in and maybe I can clarify further.  

Thanks,
 
Don Price

-Original Message-
From: akash malohatra [mailto:[EMAIL PROTECTED] 
Sent: Monday, June 14, 2004 6:37 AM
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] label printing

Hi Don,

Thanks for the specimen code.
I tried to write the same code , with my required
fields in the label for the existing report location
Label in Inventory management Module ->reports. (Ax3.0
sp1)

Before this i created one .btw file in Bartender
application named "location label.btw" and put that in
the code u provided.

But its giving me compilation error at this line
"comBTFormats.Open(LocationLabel.text(),true,"");" 

just not getting any idea...is i am missing anything?

i alreday registered the COM.

your suggestion...will be a great help for me..

waiting for a reply

thanks in advance
Akash
 --- Don Price <[EMAIL PROTECTED]> wrote: >
Remove the #'s as I ripped this from one of my xpos.
>  In the label we
> have controls that match the names below like
> STCompany. Hope this
> helps.
> 
> 
> #void clicked()
> #{
> #
> #    Com comBTApp;
> #    Com comBTFormat;
> #    Com comBTFormats;
> #    com comBTSubString;
> #    int i;
> 
>   // Start the Bar Tender application
> #    comBTApp = new
> Com("BarTender.Application");
> #    comBTFormats =
> comBTApp.Formats();
> #    //Open the Demo.btw format file
> #    comBTFormat =
> comBTFormats.Open(FileName.text(),true,"");
> #    comBTSubString =
> comBTFormat.NamedSubStrings("STCompany");
> #   
> comBTSubString.value(STCompany.text());
> #    comBTSubString =
> comBTFormat.NamedSubStrings("STAddr1");
> #   
> comBTSubString.value(STAddr1.text());
> #    comBTSubString =
> comBTFormat.NamedSubStrings("STAddr2");
> #   
> comBTSubString.value(STAddr2.text());
> #    comBTSubString =
> comBTFormat.NamedSubStrings("STCity");
> #   
> comBTSubString.value(STCity.text());
> #    comBTSubString =
> comBTFormat.NamedSubStrings("STState");
> #   
> comBTSubString.value(STState.text());
> #    comBTSubString =
> comBTFormat.NamedSubStrings("STZip");
> #   
> comBTSubString.value(STZip.text());
> #
> #    comBTSubString =
> comBTFormat.NamedSubStrings("Supplier");
> #   
> comBTSubString.value(Supplier.text());
> #    comBTSubString =
> comBTFormat.NamedSubStrings("CustPO");
> #   
> comBTSubString.value(CustPo.text());
> #    comBTSubString =
> comBTFormat.NamedSubStrings("Release");
> #   
> comBTSubString.value(Release.text());
> #    comBTSubString =
> comBTFormat.NamedSubStrings("RevLevel");
> #   
> comBTSubString.value(RevLevel.text());
> #
> #    comBTSubString =
> comBTFormat.NamedSubStrings("PartNbr");
> #   
> comBTSubString.value(PartNbr.text());
> #    comBTSubString =
> comBTFormat.NamedSubStrings("PartDesc");
> #   
> comBTSubString.value(PartDesc.text());
> #    comBTSubString =
> comBTFormat.NamedSubStrings("Quantity");
> #
>
comBTSubString.value(int2str(str2int(Quantity.text(;
> #    comBTSubString =
> comBTFormat.NamedSubStrings("PkgId");
> #   
> comBTSubString.value(PkgId.text());
> #    comBTSubString =
> comBTFormat.NamedSubStrings("CustPartNbr");
> 

RE: [development-axapta] label printing

[Don Price]

Remove the #'s as I ripped this from one of my xpos.  In the label we
have controls that match the names below like STCompany. Hope this
helps.


#void clicked()
    #{
    #
    #    Com comBTApp;
    #    Com comBTFormat;
    #    Com comBTFormats;
    #    com comBTSubString;
    #    int i;

  // Start the Bar Tender application
    #    comBTApp = new Com("BarTender.Application");
    #    comBTFormats = comBTApp.Formats();
    #    //Open the Demo.btw format file
    #    comBTFormat =
comBTFormats.Open(FileName.text(),true,"");
    #    comBTSubString =
comBTFormat.NamedSubStrings("STCompany");
    #    comBTSubString.value(STCompany.text());
    #    comBTSubString =
comBTFormat.NamedSubStrings("STAddr1");
    #    comBTSubString.value(STAddr1.text());
    #    comBTSubString =
comBTFormat.NamedSubStrings("STAddr2");
    #    comBTSubString.value(STAddr2.text());
    #    comBTSubString =
comBTFormat.NamedSubStrings("STCity");
    #    comBTSubString.value(STCity.text());
    #    comBTSubString =
comBTFormat.NamedSubStrings("STState");
    #    comBTSubString.value(STState.text());
    #    comBTSubString =
comBTFormat.NamedSubStrings("STZip");
    #    comBTSubString.value(STZip.text());
    #
    #    comBTSubString =
comBTFormat.NamedSubStrings("Supplier");
    #    comBTSubString.value(Supplier.text());
    #    comBTSubString =
comBTFormat.NamedSubStrings("CustPO");
    #    comBTSubString.value(CustPo.text());
    #    comBTSubString =
comBTFormat.NamedSubStrings("Release");
    #    comBTSubString.value(Release.text());
    #    comBTSubString =
comBTFormat.NamedSubStrings("RevLevel");
    #    comBTSubString.value(RevLevel.text());
    #
    #    comBTSubString =
comBTFormat.NamedSubStrings("PartNbr");
    #    comBTSubString.value(PartNbr.text());
    #    comBTSubString =
comBTFormat.NamedSubStrings("PartDesc");
    #    comBTSubString.value(PartDesc.text());
    #    comBTSubString =
comBTFormat.NamedSubStrings("Quantity");
    #
comBTSubString.value(int2str(str2int(Quantity.text(;
    #    comBTSubString =
comBTFormat.NamedSubStrings("PkgId");
    #    comBTSubString.value(PkgId.text());
    #    comBTSubString =
comBTFormat.NamedSubStrings("CustPartNbr");
    #    comBTSubString.value(CustPartNbr.text());
    #
    #
    # //'Print the label
    # for(i=1;i<=NumLabels.value(); i++)
    # comBTFormat.PrintOut(false,false);
    #
    #
    #
    # comBTApp.Quit(1);   // Quit, Don't save changes
    #
    #
    #}
-Original Message-
From: akash malohatra [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 08, 2004 1:30 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] label printing

Hi all,

Is there anyone used Bartender software for label
printing. 

Can this will be integrated to Axapta through COM..

I will appriciate for any Info/examples.. on this...

thanks in Advance
Akash


  
  
    

Yahoo! Messenger - Communicate instantly..."Ping" 
your friends today! Download Messenger Now 
http://uk.messenger.yahoo.com/download/index.html




 
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.

RE: [development-axapta] Really important

[Don Price]

Have a look at formletter class as it the base class for salesformletter
and purchformletter.  Salesformletter is basis of all sales order
processing and purchformletter is the basis of all purchase order
processing.  Each of these classes overload specific methods from the
formletter class as needed. You should be able to put a break point any
of these classes and look at the call stack to determine what class is
executing. 

-Original Message-
From: Amit Jain [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 08, 2004 5:19 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] Really important


 

Hello Guys,

I have raised this query once before also but failed to get any
responses. I am repeating that as it is very important.

I want to know if there any place where i can find which class is
getting executed.

In more detailed manner i am looking for the type of posting that is in
the process. 

Suppose somebody is performing sales invoice and other user is running
puchase invoice on other hand then i should be able to catch both tasks
at a single place. 

If query is not clear then pls do not hesitate to ask.

 

Regards

Amit Jain



    
-
Do you Yahoo!?
Friends.  Fun. Try the all-new Yahoo! Messenger

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




 
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.

RE: [development-axapta] kernel32 return values

[Don Price]

I'm sure that's just returning the value from the windows dll. You can
get more info on the return values for a particular windows api function
call at msdn.microsoft.com just look at the exact function the winapi
wraps and do a search on that on msdn. 

Don 


-Original Message-
From: dgaethofs [mailto:[EMAIL PROTECTED] 
Sent: Saturday, April 24, 2004 6:41 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] kernel32 return values

Hello,

Can someone tell me where I can find information on the values 
returned by kernel32.dll.

I am trying to set the currentdirectory using winapi and i get a 
error number 2 back from the system. 

Due to this I have been searching for meaning of the values returned 
by the dll, which I could not find.

WinAPI::getLastError returns a value 2.
the error is coming from DLL::lastDLLError() whereas the DLL is 
kernel32.


regards,
Danny Gaethofs






 
Yahoo! Groups Links



 










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] Query with ORDER BY and GROUP BY

[Don Price]

One additional thing don’t
forget to set the company when going external, here is  select statement I did on a memo
field

 

sqlSTR = strFmt("select
recID from AAA_Tracker
where notes like '\%%1\%' AND dataAreaId =
'%2'", Part2, datAreaId);

 

you can’t
do that in Axapta either. 

 

Don

 

-Original Message-
From: Werner Briedl
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, April 22, 2004 4:02 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta]
Query with ORDER BY and GROUP BY

 



Hi
there!





 





Can
i use the ORDER BY and the GROUP BY Clause in one SQL Statement?





 





In
SQL92 it would look like this:





 





  
SELECT SUM(QTY) AS Qty, SUM(LINEAMOUNT) AS Amount,
ITEMID
   FROM
CUSTINVOICETRANS
   WHERE (INVOICEDATE = CONVERT(DATETIME,
'2004-01-07 00:00:00',
102))
   GROUP BY ITEMID
   ORDER BY SUM(LINEAMOUNT) DESC





 





So i
tried it in Axapta:





 





   
while select sum(Qty), sum(LineAmount) from custInvoiceTrans group by ItemId
order by sum(LineAmount) desc
  
where custInvoiceTrans.InvoiceDate == str2date('20040107', 321)
    {
    print custInvoiceTrans.itemId, ', ',
custInvoiceTrans.Qty, ', ', custInvoiceTrans.LineAmount;
    }





 





 





 





But
the compiler raises a Syntax Error :-(





 





Has
anybody an idea?





 





Regards,





Werner.



 










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] Query with ORDER BY and GROUP BY

[Don Price]

You can always go external right to
sql using

 

  Connection    con = new Connection();

   Statement sqlStmt
= Con.createStatement();

   ResultSet sqlTable;

  Str
     sqlStr;

 

 sqlStr
= 

  sqlTable
= sqlStmt.executeQuery(sqlSTR);

    while
(sqlTable.next()){


set1.add(sqlTable.getInt(1));   //or whatever you need

    }

 

Don

-Original Message-
From: Werner Briedl
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, April 22, 2004 4:02 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta]
Query with ORDER BY and GROUP BY

 



Hi
there!





 





Can
i use the ORDER BY and the GROUP BY Clause in one SQL Statement?





 





In
SQL92 it would look like this:





 





  
SELECT SUM(QTY) AS Qty, SUM(LINEAMOUNT) AS Amount,
ITEMID
   FROM
CUSTINVOICETRANS
   WHERE (INVOICEDATE = CONVERT(DATETIME,
'2004-01-07 00:00:00',
102))
   GROUP BY ITEMID
   ORDER BY SUM(LINEAMOUNT) DESC





 





So i
tried it in Axapta:





 





   
while select sum(Qty), sum(LineAmount) from custInvoiceTrans group by ItemId
order by sum(LineAmount) desc
  
where custInvoiceTrans.InvoiceDate == str2date('20040107', 321)
    {
    print custInvoiceTrans.itemId, ', ',
custInvoiceTrans.Qty, ', ', custInvoiceTrans.LineAmount;
    }





 





 





 





But
the compiler raises a Syntax Error :-(





 





Has
anybody an idea?





 





Regards,





Werner.



 










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: COM Excel.Application

[Don Price]

   xlApp   = new Com('Excel.Application');

   xlApp.visible(true);

    AppVersion  = xlApp.version();

    xlBook  = xlApp.Workbooks();

    wb = xlBook.Open(filename);  

    xlSheets    = xlApp.Worksheets();

 

 

Don

-Original Message-
From: Ing. Gonzalo Bastos S.
[mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 21, 2004 3:38 PM
To: [EMAIL PROTECTED]
Subject: Re: [development-axapta]
Re: COM Excel.Application

 



That's a good example, but you don´t
have code for open and working with an existing excel worksheet ??





 





Regards







- Original Message - 





From: k_otickashka






To: [EMAIL PROTECTED]






Sent: Wednesday, April 21, 2004 2:24 PM





Subject:
[development-axapta] Re: COM Excel.Application





 



    Custtable ct;
    int row = 1;
    COM excelApp, workbooks,
excelCell, excelWorkSheet, workbook;

    ;
   
excelApp = new COM("Excel.Application");

    if
(excelApp)
    {
   
workbooks = excelApp.Workbooks();
   
workbooks.add();
   
excelWorkSheet = excelApp.ActiveSheet();

   
while select ct
   
{
   
excelCell = excelWorkSheet.Range(StrFmt("A%1", row));
   
excelCell.value(StrFmt("%1",ct.AccountNum));
   
excelCell = excelWorkSheet.Range(StrFmt("B%1", row));
   
excelCell.value(ct.Name);
   
row++;
   
}

    }

   
workbook = excelApp.ActiveWorkbook();
   
workbook.SaveAs("c:\\temp\\test.xls");
   
workbooks.close();



--- In [EMAIL PROTECTED],
"gonzalo_edo" <[EMAIL PROTECTED]> 
wrote:
> Does anybody know where can I find any
documentation about using 
> Excel.Application COM
> 
> Or anybody has an example to connect Excel
with Axapta
> 
> Regards













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] Debugger

[Don Price]

FYI, we had a firewall issue of the ax32
not talking to the debugger.  This
applies to 2tier as well as the they talk via tcp/udp. 



 

Don 

 



-Original Message-
From: Don Price
[mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 14, 2004 4:34 PM
To: [EMAIL PROTECTED]
Subject: [development-axapta]
Debugger

 

Hi,

 

  Axapta 3.0 SP1 2-tier – Error
connecting to Debugger – Does anybody have any idea what might be
wrong?  I set a breakpoint and the
debugger comes up, but there is nothing in the source window gives the above
error message. You can close the debugger and it just returns to the app.  

 

Thanks,

Don

 










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] Can't open Licence file

[Don Price]

Hey Erik,

 

 
Are you sure the cclicens.lic is in the
share\include folder?  I got this when
copied our application to different directory manually and I missed this file. 

 

Don

 

 

-Original Message-
From: Erik Hansen
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, April 15, 2004 5:02 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] Can't open Licence file

 

Hi,

 

I'm trying to upgrade an axapta 2.5 SP4 to
a 3.0 SP2. 

 

I have moved the data from oracle 8.1 to
oracle 9.2, when I’m trying to start axapta (2.5 SP4) i get the
logon screen, but after the logon screen i get an error "Can't open
licence file.

 

Erik

 

 

 










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] Debugger

[Don Price]

Hi,

 

  Axapta 3.0 SP1
2-tier – Error connecting to Debugger – Does anybody have any idea
what might be wrong?  I set a breakpoint
and the debugger comes up, but there is nothing in the source window gives the
above error message. You can close the debugger and it just returns to the
app.  

 

Thanks,

Don











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] Debugger

[Don Price]

Hi,

 

  Axapta 3.0 SP1
2-tier – Error connecting to Debugger – Does anybody have any idea
what might be wrong?  I set a breakpoint
and the debugger comes up, but there is nothing in the source window gives the
above error message. You can close the debugger and it just returns to the
app.  

 

Thanks,

Don

 











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] Rename the field...

[Don Price]

Sounds like what you want to do is not rename the field but change the
label, right? Find the field in the form design and change the property
label. Labels are inherited in this order type(extended data type/enum),
Table/Field then form. 

So if you apply to form its just the form, change it at the type and its
global.  Ie.  Change the extended daty type Dimension label property
(department) to Division and it will be global throughout the system as
long as a table or field hasn't directly set it.

Don

-Original Message-
From: Boris Gartner [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 22, 2004 7:54 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] Rename the field...

Hi All!
How can I rename the field at any form?
E.g. I want to rename: Accounts receivable -> Sales Order -> Dimensions
-> Department --->>> into Division ???
Or Accounts receivable -> Sales Order -> Dimensions -> Color --->>>
textile ???

Boris

 


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:
 http://docs.yahoo.com/info/terms/ 











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] Filtering on a memo field

[Don Price]

Thanks to everyone who replied.  I did get it working by looping thru the recordset building a container and then using that
container to assign to a querybuildRange.  Preston I
forgot about the connection/execute to go directly to SQL that should be better
performance-wise then my method, so I’ll probably update my code to
reflect. Jacob, you brought up something I thought about, but didn’t know
the limit on.   So I’ll build multiple ranges on
the recid. 


 

Again thanks for everyone’s response,

Don

 

-Original Message-
From: Jacob Hjelmer Nielsen
[mailto:[EMAIL PROTECTED] 
Sent: Friday, January 23, 2004 1:13 AM
To:
[EMAIL PROTECTED]
Subject: Re: [development-axapta]
Re: Filtering on a memo field

 



Bear in mind that the length of
queryranges is not unlimited!.And will cause a runtime Sql-error if it goes
beyond approx. 255. Hence You should either decompose the queryrangevaluestring
into substrings of 255 and insert info a new range. Or accumulate them i a set,
and afterwards use the following metod.:





 





query ConvertSet2query()
    {
   
QueryBuildRange
QueryBuildRange;
   
str
        QueryString;
   
QueryBuildDataSource    QueryBuildDataSource    =
query.addDataSource(this.tableid());
   
SetIterator
It 
= new SetIterator(this.set());
    ;
   
QueryBuildRange =
QueryBuildDataSource.AddRange(this.fieldid());

    if
(this.set().empty())
    {
   
Querystring = Sysquery::valuenotemptystring;
    }
    else
    {
   
while (it.more())
   
{
   
Querystring += it.value()+',';
   
if(strlen(Querystring) > 240) // then we are safe





   
{
   
QueryBuildRange = QueryBuildDataSource.AddRange(this.fieldid());
   
QueryBuildRange.value(QueryString);
   
QueryString = '';
   
}
   
it.next();
   
}
    }
   
QueryBuildRange =
QueryBuildDataSource.AddRange(this.fieldid());
   
QueryBuildRange.value(QueryString);
    return  query;
    }





BTW I do not think it is not
nessecary to resrtict the search on dataareaid.





 





:-J





Jacob







- Original Message - 





From: Preston A. Larimer






To: [EMAIL PROTECTED]






Sent: Friday, January 23, 2004 1:23 AM





Subject: RE:
[development-axapta] Re: Filtering on a memo field





 



I forgot to keep in mind the dataAreaID, I figure you’d catch
it Don, but incase anyone else is looking. 


 

BTW you’ll notice searching memo fields in the where clause
is not a SQL shortcoming, but an Axapta one.

 

-Preston

 

static void pl_scratch(Args _args)

{

   
docuRef
dr;

   
Connection  
   con
= new Connection();

   
Statement  
sqlStmt = Con.createStatement();

   
ResultSet  
sqlTable;

    notes  
sqlStr;

    str
searchWord;

    str     rangeList;

    str
dataareaID;

    ;

 

    dataareaID
= curExt();

 

    searchWord
= "Remark";

 

 

    sqlSTR =
strFmt("select recID from docuref where notes like '\%%1\%' AND
refCompanyID = '%2'", searchWord, dataareaID);

 

   
info(sqlStr);

 

    sqlTable =
sqlStmt.executeQuery(sqlSTR);

 


while (sqlTable.next()){

 

 
//build recidList to use in other query

 
rangeList = rangeList + (rangeList ? ", " +
int2STR(sqlTable.getInt(1)) : int2STR(sqlTable.getInt(1)));

 

 }

   
info(rangeList);

 

} 

 







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. 

 















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. 









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] Filtering on a memo field

[Don Price]

Hi All,

 

  Has anybody
ever been able to come up with a solution to filter on a memo field?  Currently if you try to set a range on
this type of field it will throw an exception. The only possible solution I’ve
thought of is searching the table myself in a loop and building a range of recids to pass on to the query.  So that’s probably not good for
performance. I would appreciate any hint or solution.

 

Thanks

Don








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] Problem adding extra fields to BankAccountTrans form

[Don Price]

Hi,

Trying setting Autodatagroup to no on the grid.

Don

-Original Message-
From: carolkilduff [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 11, 2003 5:23 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] Problem adding extra fields to BankAccountTrans form

Hi

I'm trying to add 2 extra fields to the BankAccountTrans form to 
display the debit and credit amounts seperately.  I have written 
display methods on the BankAccountTrans table e.g

display AmountCur amountCurDebitWSA()
{
   ; 
   if (this.AmountCur < 0)
   return this.AmountCur;
   else
   return 0;
}

I have created the new fields in the Overview grid, set the 
DataSource to be BankAccountTrans and the DataMethod to be as above 
but when I open the form I cannot see my new fields.  I have already 
got this working for the CustTrans and VendTrans table.  Is there 
something different about this form?  Is it something to do with the 
DataGroup property?  How can I get this working?

Thanks for any advice.
Carol.


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

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