Click here to
Subscribe to
our Newsletter
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
In a recent support case, I had the rare situation where Dexterity Triggers clashed. Dexterity allows third party developers to create triggers against various events and scripts in a Dexterity application (like Microsoft Dynamics GP).
This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.
I assisted on an eConnect incident today that was quite interesting and I thought I’d share the case and the solution.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I have completed the development project I was working last week and have another Quick Tip that came out of the project. For the previous Quick Tips related to this project have a look at Quick Tip: Passing Variables to SQL Server and Quick Tip: Passing Date and Time Variables to SQL Server.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
As a follow on from yesterday’s post, Quick Tip: Passing Variables to SQL Server, I wanted to discuss the related topic about passing of date and time variables.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Wow, the week is almost over and I am yet to post something.
This week I was working on a small development project using Visual Basic for Applications (VBA) to execute some commands at the SQL Server level after some user interface events. The code to be executed needed to have values from the windows passed through to the Transact-SQL. Now most people just write the code and pass through the value of a string field concatenated before and after with single quotes.
sqlstring = "select * from IV00101 where ITEMNMBR = '" & CStr(ItemNumber) & "'"
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Today I have a post on the solution to a tricky SQL issue.
When working with SQL Server and creating a join that links tables in two databases, all goes well when the two databases have the same collation. However, if the databases have different collations the query it will fail in a writhing blubbery gelatinous slimy mess of confused character mappings, or at least return something similar to the following error:
Msg 468, Level 16, State 9, Line 4
Cannot resolve the collation conflict between “Latin1_General_CI_AS_KS_WS” and “Latin1_General_CI_AS” in the equal to operation.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Here is a neat trick that I just used to copy images from a Microsoft Word 2007/2010 *.docx document.
I was given a Word document of a blog article to be posted on the blog. To get the text into the blog post editor (without extra html) is easy…. Just cut & paste into Notepad.exe and then cut & paste the plain text from Notepad.exe into the editor window. A little editing to add some formatting back and the text is done.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Today, I responded on a post on the Partner Forum asking “Can the DEX_ROW_ID change for a record over time?“. In this case the partner had seen the values for DEX_ROW_ID change on the GL20000 (GL_YTD_TRX_OPEN) and GL30000 (GL_Account_TRX_HIST) tables. This caused problems for an integration to an external system that used the DEX_ROW_ID as a key field.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Now I am sure there are people out there that will be thinking that this is a silly topic for a blog article. Surely everyone knows how to get the number of records from a SQL table using the COUNT(*) function?
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
This quick tip follows on from my previous post: Quick Tip: Updating Dexterity customizations to work with Security Tasks and Security Roles.