AW: [development-axapta] How do I know which field is sorted at, and the sortorder in a grid?

2008-05-16 Thread jesper.joergensen 
Hi Tore,

 

You need to add the menuitem to the form CustTable.

 

 

 

Exportfile for AOT version 1.0 or later

Formatversion: 1

 

***Element: FTM

 

; Microsoft Dynamics MENUITEM : CustSort unloaded

; 


  VERSION 1

  

  MENUITEM #CustSort

Type: 2

PROPERTIES

  Name#CustSort

  ObjectType  #Report

  Object  #CustSort

ENDPROPERTIES



  ENDMENUITEM

  

 

***Element: RG 

 

; Microsoft Dynamics Report: CustSort nicht geladen

; 


VERSION 1

 

REPORT #CustSort

  PROPERTIES

Name#CustSort

  ENDPROPERTIES

  

  METHODS

Version: 3

SOURCE #fetch

  #public boolean fetch()

  #{

  #boolean ret;

  #custTable ct;

  #;

  #ct = fds.getFirst(1);

  #while (ct)

  #{

  #this.send(ct);

  #ct = fds.getNext();

  #ret = true;

  #}

  #

  #return ret;

  #}

ENDSOURCE

SOURCE #init

  #public void init()

  #{

  #FormRun fr;

  #

  #super();

  #fr = element.args().caller();

  #fds = fr.dataSource();

  #}

ENDSOURCE

SOURCE #classDeclaration

  #public class ReportRun extends ObjectRun

  #{

  #FormDataSource  fds;

  #}

ENDSOURCE

  ENDMETHODS

  QUERY #Query

PROPERTIES

  Name#Query

  Version #3

  NextUniqueId#1001

ENDPROPERTIES



METHODS

  Version: 3

  SOURCE #classDeclaration

#public class QueryRun extends ObjectRun

#{

#}

  ENDSOURCE

ENDMETHODS

BLOCKS

  BLOCK #CustTable

PROPERTIES

  Name#CustTable

  Table   #CustTable

  UniqueId#1000

ENDPROPERTIES



FIELDLIST

  PROPERTIES

  ENDPROPERTIES

  

ENDFIELDLIST

SORTING

ENDSORTING

LINES

ENDLINES

BLOCKS

ENDBLOCKS

  ENDBLOCK

ENDBLOCKS

  ENDQUERY

  

  DESIGNS

DESIGN

  PROPERTIES

Name#ReportDesign1

ReportTemplate  #InternalList

  ENDPROPERTIES

  

  AUTOBODIES

PROPERTIES

ENDPROPERTIES



AUTOBODY #CustTable

  PROPERTIES

Name#CustTable_1

  ENDPROPERTIES

  

  STRFIELD

PROPERTIES

  Name#CustTable_AccountNum

  Table   #CustTable

  DataField   #AccountNum

ENDPROPERTIES



  ENDSTRFIELD

  STRFIELD

PROPERTIES

  Name#CustTable_Name

  Table   #CustTable

  DataField   #Name

ENDPROPERTIES



  ENDSTRFIELD

  STRFIELD

PROPERTIES

  Name#CustTable_NameAlias

  Table   #CustTable

  DataField   #NameAlias

ENDPROPERTIES



  ENDSTRFIELD

  STRFIELD

PROPERTIES

  Name#CustTable_Phone

  Table   #CustTable

  DataField   #Phone

ENDPROPERTIES



  ENDSTRFIELD

ENDAUTOBODY

  ENDAUTOBODIES

ENDDESIGN

  ENDDESIGNS

ENDREPORT

 

 

***Element: PRN

 

; Microsoft Dynamics Project : SortFromForm unloaded

; 


  PROJECTVERSION 2

  

  PROJECT #SortFromForm

   SHARED

  PROPERTIES

Name#SortFromForm

  ENDPROPERTIES

  

GROUP #Object1

  PROPERTIES

Name#Object1

ProjectGroupType#All

GroupMask   #

PreventEditProperties #No

  ENDPROPERTIES

  

  BEGINNODE

FILETYPE 0

UTILTYPE 2

UTILOBJECTID 0

NODETYPE 296

NAME #CustSort

  ENDNODE

  ENDGROUP

  

BEGINNODE

  FILETYPE 0

  UTILTYPE 18

  UTILOBJECTID 0

  NODETYPE 202

  NAME #CustSort

ENDNODE

  ENDPROJECT

  

 

***Element: END

,,

 

 

Mit freundlichen Grüßen / Best regards / Med venlig hilsen

Jesper Jørgensen / Abt. NMT-XD
Senior Product Manager

arvato systems | Technologies GmbH 
An der Autobahn 18 
33311 Gütersloh 

[EMAIL PROTECTED] blocked::blocked::blocked::mailto:[EMAIL PROTECTED] 

Phone:   +49 5242 / 40 80 54

Fax:   +49 5242 / 40 80 40

Mobile:  +49 172  / 571 03 34

http://www.as-T.biz

[development-axapta] Problem with Int64 and SET

2008-05-16 Thread James Flavell 
Can anyone help me to fix a problem in AX4.0 realted to Int64 and SETs
 
I have some code that does the following:
 
SET xyz;
SalesLine salines;
;
 
if (!xyz.add(saleslinerecid))
 
 
It gives an error that it was expecting an int and not an Int64
I understand the RecId is now Int64 but do not know how to get a SET object
to accept it...
 
Thanks
James


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

[development-axapta] Cannot execute the required database operation.The SQL database has issued an er

2008-05-16 Thread tkbsmanian 
Hi All,

I'm encountering a problem while synchronizing Tables and the error 
message is as below.

Cannot execute the required database operation.
The SQL database has issued an error.

Cannot execute a data definition language command on  ().
The SQL database has issued an error.

Request for the permission of type 'SqlStatementExecutePermission' 
failed.
(S)\Classes\SqlStatementExecutePermission\demand
(S)\Classes\Statement\executeQuery
(C)\Forms\SysSQLShowRows\Methods\buildListView - line 25
(C)\Forms\SysSQLShowRows\Methods\run - line 8
(S)\Classes\SqlScanMain\checkUniqueRule - line 34
(S)\Classes\SqlScanMain\checkIndexesForTable - line 187
(S)\Classes\SqlScanMain\handleTable - line 46
(S)\Classes\SqlScanMain\run - line 53
(S)\Classes\SysSqlAdminClass\handleSelectedItems - line 125
(C)\Forms\SysSqlAdmin\Methods\runThroughTablesAndIndexes - line 44
(C)\Classes\FormButtonControl\Clicked - line 4
(C)\Classes\FormMenuButtonControl\Clicked


I've done as many ways as i know like...
1. Synchronized the table on AOT.
2. Synchronized through AdministrationPeriodicSQL Administration
 a. All Tables  Table actions  Synchnonize
 b. All Tables  Table actions  Check\Synchronize  Start
 c. All Tables  Table actions  Check\Synchronize  {checked 
Remove unknown indexec}  Start
3. Deleted all *.ali  *.aoi files from application and re-started   
   the AOS.

But, still i'm getting the same problem as i mentioned above.

I'll appreciate, if anybody give me the solution for the same.

Thanks in advance,
Balu.