Belajar Komputer & Gadget

AUTO INCREMENT Field Auto-increment allows a unique number to be generated automatically when a new record is inserted into a table. Often this is the primary key field that we would like to be created automatically every time a new record is inserted. Syntax for MySQL CREATE   TABLE  Persons (       ID int  NOT   NULL  AUTO_INCREMENT,     LastName varchar( 255 )  NOT   NULL ,     FirstName varchar( 255 ),     Age int,      PRIMARY   KEY  (ID) ); Syntax for SQL Server CREATE   TABLE  Persons (       ID int  IDENTITY ( 1 , 1 )  PRIMARY   KEY ,     LastName varchar( 255 )  NOT   NULL ,     FirstName varchar( 255 ),     Age int ); for Select Query SQL SERVER SELECT ROW_NUMBER () OVER ( ORDER BY FirstName, La...

Hi, To get the Current Logged In Company you can Use the  curExt()  function in AX. for current User Id use   curUserId() function for date use  SystemDateGet() function static void curExtExample(Args _arg) { str CompanyId, UserId; date CurrentDate; ; CompanyId     =  curExt(); UserId             =  curUserId(); CurrentDate     =  SystemDateGet(); Info(StrFmt("%1 %2 %3", CompayId, UserId, CurrentDate) } You would also get the same result with below code as well. static void curExtExample(Args _arg) { str CompanyId; ; CompanyId =  CompanyInfo::Find().DataAreaId ; Info(CompanyId); }

SSRS error: Domain role with multiplicity 0..1 or 1 can hold at most 1 link I got the following error when I duplicate a SSRS report in Visual Studio: Domain role with multiplicity 0..1 or 1 can hold at most 1 link: DataSetParameter of Microsoft.Dynamics.Framework.Design.Model.Reports.DataSetParameterRefersToParameter. To resolve it do the following on the report datasets: Change the datasource type to Query. Delete the whole query text in the "Query" field. Save, rebuild and change the values on the datasource back to the ones intended I also noticed the above actions can help resolve other problems, like inconsistency in the report parameters (can occur if you change the contract parameters).

OPTION 1:   public static Name storeOperatingUnitName(RecID _storeRecId) {     RetailChannelTable      retailChannelTable;     DirPartyTable           dirPartyTable;     OMOperatingUnit         operatingUnit;     ;     select firstOnly recId from retailChannelTable         where retailChannelTable.RecId == _storeRecId         join recId from operatingUnit             where operatingUnit.RecId               == retailChannelTable.OMOperatingUnitID                && operatingUnit.OMOperatingUnitType == OMOperatingUnitType::Retail...

Cara Cek Nomor Menggunakan menu bantuan indosat Langkah yang pertama adalah dengan menggunakan menu bantuan indosat ooredoo. Dimana ini adalah cara yang paling mudah untuk mengetahui nomor im3 ataupun mentari. Karena anda tinggal mengetikan *123*30# lalu panggil. Setelah itu maka akan ada pemberitahuan mengenai nomor anda sendiri. Selain nomor di atas masih ada nomor lainya yaitu *123*7*2*1#.  Cara Cek Nomor Menggunakan aplikasi mycare Dengan mendaftar mycare indosat maka anda akan mengetahui beberapa layanan indosat mulai dari sisa kuota, paket yang digunakan hingga masa aktif. Yang jelas pada mycare indosat ooredoo anda bisa melihat nomor anda sendiri beserta informasi penting lainnya Cara Cek Nomor Terbaru Selain cara di atas masih ada cara lainya yaitu juga menggunakan menu bantuan  akan tetapi bukan *123# yaitu menu *888#. Dimana cara untuk mengecek nomor indosat ooredoo sendiri adalah dengan mengetik *888*1*1#. Selain mengetahui nomor sendiri pada m...

1. Common mistakes Often, developers call 2 of the mentioned methods in the following order: formDataSource.refresh() formDataSource.research() or formDataSource.reread() formDataSource.research() or formDataSource.research() formDataSource.executeQuery() or formDataSource.research() formDataSource.refresh() / formDataSource.reread() All of these are wrong, or at least partially redundant. 2. Refresh This method basically refreshes the data displayed in the form controls with whatever is stored in the form cache for that particular datasource record. Calling  refresh()  method will  NOT  reread the record from the database. So if changes happened to the record in another process, these will not be shown after executing  refresh() . refreshEx Does a redraw of the grid rows, depending on the optional argment for specifying the number of the record to refresh (and this means the actual row number in the gr...

Tools we need to instal : Visual Studio for development tools. Dev Express License ( Optional  for better touch GUI) Retail SDK (POS Source Code) You can found Retail SDK on Dynamics AX Installation. After installation finished you can found the source code  on document folder. For very first time lets  focus at the two folder on the POS Plug-ins, there is  Services  and  Triggers  because almost all POS function source code is on that folder. Services : Services are actually .Net assemblies. POS implements many of the features as services using interfaces and can be modified using Visual Studio. POS loads these services at run time by calling the interfaces. So whenever you modify or extend the standard service keep the assembly name same as original so that POS can recognize it and call it at run time. Triggers : Triggers are called before and after the operations. There are two types of triggers, Pre-triggers and Po...