the views dissappeared (they were there yesterday) and how about half of the
views in Axapta cannot be sync'd to the SQL (as mentioned i deleted all the
views in SQL and did sync of all views in AOT but only about 4 were created
in SQL).
Anyone had any similiar experiences with views and any clues as to why?
THanks
James
-----Original Message-----
From: Pascal Dutour Geerling
[mailto:[EMAIL PROTECTED]
Sent: Thursday, June 17, 2004 10:15 PM
To: [EMAIL PROTECTED]
Subject: Re: [development-axapta] SQL VIEWS missing and cannot be synced
Hi James,
If this view doesn't exist, try to run this script in the SQL Query
Analyzer:
---
setuser N'sa'
GO
CREATE VIEW LEDGERBALANCESDIM AS SELECT SUM(A.DEBITMST) AS
DEBITMST,SUM(A.CREDITMST) AS CREDITMST,SUM(A.DEBITOPRMST) AS
DEBITOPRMST,SUM(A.CREDITOPRMST) AS CREDITOPRMST,SUM(A.DEBITTAXMST) AS
DEBITTAXMST,SUM(A.CREDITTAXMST) AS CREDITTAXMST,SUM(A.DEBITMSTSECOND) AS
DEBITMSTSECOND,SUM(A.CREDITMSTSECOND) AS
CREDITMSTSECOND,SUM(A.DEBITOPRMSTSECOND) AS
DEBITOPRMSTSECOND,SUM(A.CREDITOPRMSTSECOND) AS
CREDITOPRMSTSECOND,SUM(A.DEBITTAXMSTSECOND) AS
DEBITTAXMSTSECOND,SUM(A.CREDITTAXMSTSECOND) AS
CREDITTAXMSTSECOND,SUM(A.QTY) AS QTY,A.ACCOUNTNUM AS
ACCOUNTNUM,A.DIMENSION
AS DIMENSION,A.DIMENSION2_ AS DIMENSION2_,A.DIMENSION3_ AS
DIMENSION3_,A.TRANSDATE AS TRANSDATE,A.PERIODCODE AS
PERIODCODE,A.SYSTEMGENERATEDULTIMO AS SYSTEMGENERATEDULTIMO,A.DATAAREAID
AS
DATAAREAID,1010 AS RECID FROM LEDGERBALANCESDIMTRANS A(NOLOCK) GROUP BY
A.ACCOUNTNUM,A.DIMENSION,A.DIMENSION2_,A.DIMENSION3_,A.TRANSDATE,A.PERIODCOD
E,A.SYSTEMGENERATEDULTIMO,A.DATAAREAID
GO
setuser
GO
---
Good luck.
Regards,
Pascal
"James Flavell"
<[EMAIL PROTECTED]
.com> To
<[EMAIL PROTECTED]
17-06-2004 09:55 >
cc
Please respond to Subject
development-axapt [development-axapta] SQL VIEWS
[EMAIL PROTECTED] missing and cannot be synced
Has anyone had the problem that views such as LEDBALANCESDIM does not
exist
in SQL server and when sync in AOT nothing is created?
I have checked and find that some of the views can sync but others
cannot!!!
I have checked the MASTER db and the views in that have INFORMATION_SCHEMA
as the owner...I dont know what or where else to try....
Thanks
James
[Non-text portions of this message have been removed]
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 Sponsor | |
|
|
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.