[development-axapta] Re: how to delete a table in AXAPTA?

2006-01-26 Thread wanggaolu0724 




Thanks,steve.
  But now ,because I've deleted the table in sql server ,I need to 
import the table.After I import the table in sql server enterprise 
manager,I found a error in AXAPTA sync utility  .It says the object 
has existed. What should I do?  


--- In development-axapta@yahoogroups.com, "Steve Wright" 
<[EMAIL PROTECTED]> wrote:
>
> 
> You cannot remove the table from the AOT as this would create 
compile
> errors (as the table does not exist).
> 
> If you are not licensed to use this table - you don't have the
> production modules as an example - then the Synchronise facility in
> Axapta will drop the table from SQL.   If you are licensed to use 
the
> table then the sync utility will create the table in SQL.
> 
> Axapta has been designed so that you do all maintenace within 
Axapta,
> you do not need to use SQL Enterprise Manager to create/drop 
tables.
> This is all managed for you by Axapta.
> 
> Regards,
> Steve
> 
>  
> 
> 
> Reply
> 
> -Original Message-
> From: development-axapta@yahoogroups.com
> [mailto:[EMAIL PROTECTED] On Behalf Of 
wanggaolu0724
> Sent: Wednesday, 25 January 2006 11:21 AM
> To: development-axapta@yahoogroups.com
> Subject: [development-axapta] how to delete a table in AXAPTA?
> 
>    I've delete a table (ProdStatusParameters) in SQL by 
mistake ,but in
> AXAPTA AOT I can see the table(Its layer is syp),how to delete it 
in
> axapta? 
>    your help will be appreciated.
> 
> 
> 
> 
> 
>  
> Yahoo! Groups Links
>












  
  
SPONSORED LINKS
  
  
  

Computer part
  
  
Programming languages
  
  
Microsoft axapta
  
  


Support exchange
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Re: SV: SV: [development-axapta] Joining 2 tables gives no result

2006-01-26 Thread Thomas 




Hi John,

I tried to add the following before the select/join statement but it 
does not seem to work:

vba.company("tkv");

Am I doing this wrong?

Thomas

--- In development-axapta@yahoogroups.com, Hans-Walter Bous 
<[EMAIL PROTECTED]> wrote:
>
> Hi,
>   you don't have to change company. Just try it with
>   vba.company().
>   By this you force the join to the selected company.
>   John
> 
> Askeryd Thomas <[EMAIL PROTECTED]> schrieb:
>   An idea is to split the join.
> Making it more like 
> 
> while select xxx from Journal
> {
>  change company to where vba is
>  {
> select vba where vba.yyy == Journal.xx;
> print some stuff;
>   }
> }
> 
> IT will slow down the method but it will do the job.
> Thomas.
> 
> 
> 
> Från: development-axapta@yahoogroups.com genom Thomas
> Skickat: on 2006-01-25 09:18
> Till: development-axapta@yahoogroups.com
> Ämne: Re: SV: [development-axapta] Joining 2 tables gives no result
> 
> 
> Hello Thomas,
> 
> I am pretty new to Axapta and X++. Could you give me a hint about 
> how I should restructure the code?
> 
> Regards
> Thomas (Lund)
> 
> --- In development-axapta@yahoogroups.com, "Askeryd Thomas" 
> <[EMAIL PROTECTED]> wrote:
> >
> > If the table is not part of a shared virtual company the data is 
> not shared between companies. 
> > Due to the join u cant just change the company in the middle of 
> it. I think you might have to reconstruct your code.
> > Thomas.
> > 
> > 
> > 
> > Från: development-axapta@yahoogroups.com genom Thomas
> > Skickat: on 2006-01-25 08:46
> > Till: development-axapta@yahoogroups.com
> > Ämne: [development-axapta] Joining 2 tables gives no result
> > 
> > 
> > Hello,
> > 
> > I am making a report, where 2 tables are joined. I need to print 
a 
> > report containing all lines of a specific Invoice Journal 
> > (ledgerJournalTrans) and also the bank account information for 
> each 
> > selected vendor account (VendBankAccount) The problem is that my 
> > report, which I make with the Report Wizard gives me an empty 
> > report. I tried to select the rows through a simple job:
> > 
> > static void Job108(Args _args)
> > {
> > LedgerJournalTrans lt;
> > VendBankAccount vba;
> > 
> > while select JournalNum, 
> > AccountType,AccountNum,Txt,TransTxtLocal, 
> > CurrencyCode,AmountCurDebit, AmountCurCredit, Due from lt
> > join * from vba
> > where(lt.journalNum=="XXX" && 
vba.Vend==lt.AccountNum)
> > {
> > print lt.Voucher," ",lt.AccountNum;
> > print 
vba.Vend," ",vba.RegistrationNum," ",vba.AccountNum;
> > }
> > print "END";
> > pause;
> > }
> > 
> > When I run this job I also get an empty result. If I run a 
select 
> on 
> > the lt table and only select where lt.journalNum=="XXX" then I 
get 
> > the lines of the entered journal.
> > 
> > If I select * from vba table where vba.vend="YY" then I get the 
> bank 
> > account information for the specific vendor. 
> > 
> > But as soon as I make the join I do not get any result. Why does 
> > this happen. I suspect that the problem could be that the vba 
info 
> > is registered in one company and the Invoice Journal is created 
in 
> > another parameter company. Is this the case? 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > SPONSORED LINKS 
> > Computer part  
t=ms&k=Computer+part&w1=Computer+part&w2=Programming+languages&w3=Mic
> 
rosoft+axapta&w4=Support+exchange&c=4&s=90&.sig=yLpvcLTIDJ5FTkRJGsO11
> w>    Programming languages  
t=ms&k=Programming+languages&w1=Computer+part&w2=Programming+language
> 
s&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=cuhEClK4dU4wa
> pXFmKisbQ>    Microsoft axapta  
t=ms&k=Microsoft+axapta&w1=Computer+part&w2=Programming+languages&w3=
> 
Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=yfeG_U6QaLfPOZZIud
> 02Fg>    
> > Support exchange  
t=ms&k=Support+exchange&w1=Computer+part&w2=Programming+languages&w3=
> 
Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=hy8yRGMzrmxdphyITT
> UeqA>    
> > 
> > 
> > 
> > YAHOO! GROUPS LINKS 
> > 
> > 
> >   
> > *  Visit your group "development-axapta 
>  " on the web.
> > 
> > *  To unsubscribe from this group, send an email to:
> >   [EMAIL PROTECTED] 
> 
> subject=Unsubscribe> 
> > 
> > *  Your use of Yahoo! Groups is subject to the Yahoo! Terms 
of 
> Service  . 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > [Non-text portions of this message have been removed]
> >
> 
> 
> 
> 
> 
> 
> 
> SPONSORED LINKS 
> Computer part

[development-axapta] Concatenate two fields

2006-01-26 Thread manojkumar_asp 




Hi All,
 I want to concatenate two fields in form to third field which is used 
for display.How can i do it. Any help would be of great use.

thanks in advance,

regards,
MK












  
  
SPONSORED LINKS
  
  
  

Computer part
  
  
Programming languages
  
  
Microsoft axapta
  
  


Support exchange
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] mandatorily align the content in report

2006-01-26 Thread wanggaolu0724 




   I've created a report,this report datasource is the table CustTrans.
In AXAPTA report,as you know,the field AmountCur's content is aligned 
in central when its value is positive,in right edge when its value is 
negative.How can I mandatorily align the content in right edge?
  your suggestion will be appreciated.












  
  
SPONSORED LINKS
  
  
  

Computer part
  
  
Programming languages
  
  
Microsoft axapta
  
  


Support exchange
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Re: [development-axapta] Re: Dimension y dialog field

2006-01-26 Thread hilda cabrejos 




hello, worked just fine 
   
  thanks

manekaze <[EMAIL PROTECTED]> wrote:
  Hi,

I think you can create an extended data type called for example 
Dimension4. And you can create a relation to Dimensions table with 
dimensioncode fixed to 4. (take a look at Dimension EDT to see an 
example of the relation)

Then in your dialog field you can ...

Dialog.addfield(TypeId(Dimension4),.)

Maybe there are some other ways to do it (much more elegants than 
this :) but I think it could works :)

Good luck,

Mkz
---
http://www.trucosaxapta.com
An Axapta tricks site in Spanish language :)



--- In development-axapta@yahoogroups.com, hilda cabrejos 
<[EMAIL PROTECTED]> wrote:
>
> Heelo everybody
>    
>   Can anyone tell me how to work with Dimension on a diolog field?
>    
>    DialogfieldOffice    = Dialog.addField(typeid(Dimension));
>  DialogfieldOffice.value(Office);
>    
>   Does not seem to do the trick.  The Dimension wanted is the 
fourth (Dimension[4]).
>    
>   Thank you in advance.
>    
>    
>   Hilda
> 
> __
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
> 
> [Non-text portions of this message have been removed]
>






  SPONSORED LINKS 
    Computer part   Programming languages   Microsoft axapta Support exchange 
    
-
  YAHOO! GROUPS LINKS 

    
    Visit your group "development-axapta" on the web.
    
    To unsubscribe from this group, send an email to:
 [EMAIL PROTECTED]
    
    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 

    
-
  



    
-
Do you Yahoo!?
 With a free 1 GB, there's more in store with Yahoo! Mail.

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









  
  
SPONSORED LINKS
  
  
  

Computer part
  
  
Programming languages
  
  
Microsoft axapta
  
  


Support exchange
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] Can Install Axapta 3.0 With SQL Server 2005??

2006-01-26 Thread Kiran Vijay 




Hi All,
Can I install Axapta as SQL Server 2005 as backend...??

I tried it , At the time of AOS installation, I created a DB, and AOS
installed successfully.

But I'm not able to find that Database in the back end.. MoreOver Axapta is
not working.. It is throwing a SQL Error at the start up of Axapta... Is
this a error due to the incompatibility to SQL Server 2005??

Can any one help me out??

Thanks
Kian


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









  
  
SPONSORED LINKS
  
  
  

Computer part
  
  
Programming languages
  
  
Microsoft axapta
  
  


Support exchange
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] date lookup

2006-01-26 Thread byteway_so 




Hi,

It's easy to add a (tableless) date field to a form.
But how can I make use of the calendar lookup functionality?
It is possible to call the calender itself (in a testjob):

static void selectDateJob(Args _args)
{
// Testjob: otherwise override the lookup method of the date field
    Args    args = new Args();
    FormRun formRun;
    Date myDate;
    ;
    args.name(formstr(sysDateLookUp));
    formRun = classFactory.formRunClass(args);
    formRun.init();
    formRun.run();
    formRun.wait();
    //myDate = formRun.DateValue(); // ???
}

But how can I retrieve the value of this calendar?
And how can I make this calendar stick to the date field?

Thanks,
/b










  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] Compare accounts placed in different companies/dataareaid?

2006-01-26 Thread mark.henriksen 




Hi all!

Does any of you know a way to compare one account from one company 
with, an account from another company?

Best regards
MH.












  
  
SPONSORED LINKS
  
  
  

Computer part
  
  
Programming languages
  
  
Microsoft axapta
  
  


Support exchange
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [development-axapta] Re: Resorting a table buffer

2006-01-26 Thread Christoph Malherbe 




Hi Gonzalo,

Thank you for responding.

What I'm after is a function/statement which will change the sort order of
the data in the table buffer after the table buffer was populated with data.

Regards,

Christoph.

-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of gonzalo_edo
Sent: 26 January 2006 02:27 AM
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Re: Resorting a table buffer

You should consider a cluster index to keep your records sorted as 
you want, you perfectly could change the order of the records in the 
Ct buffer, but you need an index, otherwise the query will take so 
long because the database motor will create a temporary index to 
handle the query.

Regards Gonzalo.



--- In development-axapta@yahoogroups.com, "Christoph Malherbe" 
<[EMAIL PROTECTED]> wrote:
>
> Hi all, 
> 
>  
> 
> Please consider the following:
> 
>  
> 
> static void ProcessCustomers(CustTable ct)
> 
> {
> 
> while (ct)
> 
> {
> 
> print ct.AccountNum;
> 
> next ct;
> 
> }
> 
>  
> 
> pause;
> 
> }
> 
>  
> 
> This is a hypothetical scenario where the method receives a table 
buffer as
> parameter. The table buffer is sorted by "AccountNum desc". Before
> processing the table buffer with the "while" statement, I'd like 
to change
> the sort order to "Name asc". Is this something that can be done 
without
> having to re-execute the select that populated the table buffer in 
the first
> place?
> 
> Regards,
> 
> Christoph Malherbe
> 
>  
> 
> 
> 
> [Non-text portions of this message have been removed]
>






 
Yahoo! Groups Links



 









  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [development-axapta] Can Install Axapta 3.0 With SQL Server 2005??

2006-01-26 Thread Malcolm Burtt 




Hi Kian
 
The new Kernel Roll Up 1, released last week, provides SQL Server 2005
compatibility.
 
Regards
 
Malcolm Burtt 
Touchstone 
Our Trusted Solutions - Your Optimised Business



  _  

From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Kiran Vijay
Sent: 26 January 2006 08:04
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Can Install Axapta 3.0 With SQL Server
2005??


Hi All,
Can I install Axapta as SQL Server 2005 as backend...??

I tried it , At the time of AOS installation, I created a DB, and AOS
installed successfully.

But I'm not able to find that Database in the back end.. MoreOver Axapta
is
not working.. It is throwing a SQL Error at the start up of Axapta... Is
this a error due to the incompatibility to SQL Server 2005??

Can any one help me out??

Thanks
Kian


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






SPONSORED LINKS 
Computer part
    Programming languages
    Microsoft axapta
    
Support exchange
    

  _  

YAHOO! GROUPS LINKS 


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

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



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] Axapta Product Builder Question

2006-01-26 Thread stanfvaninger 




Our company is just in the process of setting up, populating tables, 
and doing training on Axapta. It will be several months before we go 
live.The two consultants that are working with us do not have very 
much knowledge of the Axapta Products Builder.

We are a manufacturing company and would like to use the Product 
Builder to do estimates and quotes on new products. An important 
requirement is that we be able to save the results of a user session 
of the Product Builder to a table so that it can be edited in the 
future. 

Our estimaters have to gather a lot of data and frequently begin 
working on an estimate before all the data has been accumulated. They 
need the ability to save a user session and return to it at any time 
to enter additional data and/or edit existing information. They will 
normally not need to generate the BOM and Route until all the data 
has been entered and verified. I anticipate that they will need the 
ability to copy an existing configuration to a new configuration and 
then make some changes to the new configuration in order that the 
costs of the two can be compared.

I am not talking about the product models; I understand that these 
are permanently saved (until they are deliberately deleted). What we 
will need is the ability to keep the results of running the 
configuration user dialog for one of the products models and be able 
to edit the data previously entered.

Is this possible with the Axapta Product Builder?

Thanks very much in advance.









  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.