A tool for easy online testing and sharing of database problems and their solutions.http://sqlfiddle.com/
March 5, 2014 • 12:17 pm 0
October 4, 2013 • 6:47 am 0
September 24, 2013 • 10:31 am 0
Often we need to pass user id and intercompany id to sql stored procedure to do some data selection from custom tables or to maintain the log regarding user activity. This happens with us with one custom window of Dynamics GP, in the beginning our stored procedure didn’t need user id and intercompany id parameters and was working fine but with the client requirement changes at some point we needed to pass these two parameters, adding parameters means creating chunk and deployment to all machines, which was not possible as users were connected and updated was necessary as it was hindering there routine work.
We can get intercompany id easily by using select dB_name() but we also needed to find the Dynamics GP user who is calling the stored procedure. To find that user we use this function inside our stored procedure and in this way avoid updating chunk.
This will returned the login dynamics gp user id when stored procedure will be called from GP.
February 19, 2013 • 10:07 am 1
Good informative article. There are ways of doing things and important is what to use when what is needed. Although it is a little advanced but always workable techniques. There were times when I use to accessed third party tables and what I did is not very different. I usually do this.
1. Create SQL view for the table which I need to access, just take an example of this FA General Information Master (FA00100) table, with some other unique name.
create view V_dynFA00100
select * from FA00100
grant select on V_dynFA00100 to DYNGRP
2.Then create table in dictionary with same view name, and fields (with same data types and dexterity field’s format). The number of keys is my choice but the Primary key will always be same as of FA00100 table.
and now I can use it like any GP table, get/previous and next. range or no range to show data on my form. And I don’t need to bother to create this table V_dynFA00100 from SQL Maintenance window.
October 25, 2012 • 7:33 pm 0
To insert value in DEX_ROW_TS from back end GETUTCDATE() will be used in sql.
October 25, 2012 • 7:28 pm 0
October 16, 2012 • 11:07 am 1
Where COLUMN_NAME =’ITEMNMBR’
and table_name like ‘IV%’
Code, News, Tech & Stuff
How to use MS Dynamics SmartList Builder, Excel Report Builder and other Reporting tools to get the data and analysis you need.