[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 Administration>Periodic>SQL 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.

RE: [development-axapta] Problem with Int64 and SET

2008-05-16 Thread James Flavell 
Thank you Palle everything is now solved :)
 
I was just wondering is such a check of Types::Integer recommended in any
upgrade documents as it was obvisouly something completely overlooked for
the cusotmer upgrade that was done? 
 
Thanks
James
 

  _  

From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Palle Mølgaard
Sent: Friday, May 16, 2008 4:13 PM
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Problem with Int64 and SET



Create the set as :

xyz = new Set(Types::Int64);

Med venlig hilsen

Palle Mølgaard

Tlf.: 96 31 44 44

[EMAIL PROTECTED]  dk

www.systemate.dk  e.dk> 



From: development- 
[EMAIL PROTECTED] [mailto:development-
 [EMAIL PROTECTED] On
Behalf Of James Flavell
Sent: 16. maj 2008 08:22
To: development- 
[EMAIL PROTECTED]
Subject: [development-axapta] Problem with Int64 and SET

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]

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



 


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

RE: [development-axapta] Problem with Int64 and SET

2008-05-16 Thread Palle Mølgaard 
Create the set as :

 

xyz = new Set(Types::Int64);

 

Med venlig hilsen

 

Palle Mølgaard

 

 

Tlf.: 96 31 44 44

[EMAIL PROTECTED]

www.systemate.dk  

 

 



From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of 
James Flavell
Sent: 16. maj 2008 08:22
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Problem with Int64 and SET

 

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]

 



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

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

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] 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 http://www.as-t.biz/>  
arv