Best Practice Issues

BEST Practice errors!

These are self-explanatory!


Comments

Post a Comment

Popular posts from this blog

SysDictField object not initialized. - Views

One of my Colleague had this issue.. I’m using a View (with some calculated fields), as the source for another View (summed fields, so I’m working with “total” records). This 2 nd View continues to have this error message: SysDictField object not initialized. Stack trace (C)\Classes\SysTableBrowser\AddField - line 32 (C)\Classes\SysTableBrowser\showAutoFields - line 95 (C)\Classes\SysTableBrowser\run - line 67 Solution: Go to the Field Groups and delete the fields that are in the Autoreport and delete the fields that are Autoreport and not in the Field List of the View.
Read more

Get the value of Month or YY in SysComputedCOlumns in AX views

Here is the Code: public static server str WFinvoiceDateMM() {     str sDate =         SysComputedColumn::returnfield(             tableStr (WFSyscoInvoicesV),             queryDataSourceStr (WFSyscoInvoicesQ, CustInvoiceJour),             fieldStr (CustInvoiceJour, InvoiceDate)             );     return 'Month(' + SysComputedColumn::fromUtcDateToDate(sDate) + ')' ; }
Read more

Script to Move the temp database from C Drive to D drive

SELECT name as 'File Name', physical_name as 'File Directory' FROM sys.master_files WHERE database_id = DB_ID('tempdb'); GO /* Moves the Temp Database*/ USE master; GO ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'D:\SQLData\tempdb.mdf'); GO ALTER DATABASE  tempdb MODIFY FILE (NAME = templog, FILENAME = 'D:\SQLData\templog.ldf'); GO /* The new path will be used the next time the database is started. The database used is: MASTER. You must restart SQL Server*/ /*Verification of TEMPDB move*/ SELECT name as 'File Name', physical_name as 'File Directory' FROM sys.master_files WHERE database_id = DB_ID('tempdb'); GO
Read more