Development Matters Blog

During a table upgrade, we are met with the task of creating and deleting tables on SQL using Dexterity code.

The process of deleting tables requires deleting both the table and its stored procedures, but the process of creating tables does at the same time create a table and its stored procedures on SQL. Also, if we try to create the stored procedures after creating a table, the result will be failed.

The whole process of creating a table is done in one line:

open table TableName;

The following few lines will try to create stored procedures:

l_result = Table_CreateProcedures(ProductID, table CSCIVCatalogNotes);

if l_result <> 0 then

                error “Stored procedures were not successfully created for table CSCIVCatalogNotes.”;

end if;

However, if we try to create stored procedures after we create the table on SQL, we will always get the error message. The main reason is that stored procedures are already created.

The process of deleting a table from SQL requires deleting stored procedures:

local long          status;

status = Table_DropProcedures(ProductID, table NameOfTheTable);

If the value of the variable status is equal to 0, stored procedures are successfully deleted and now we need to delete the table from SQL. We can do it this way:

Local text sCode;

Local long status;

status = SQL_Connect(SQL_connection);

if (status = 0) then

                            sCode = ” use ” + DatabaseName;

                            sCode = sCode + ” drop table PhisicalNameOftheTable “;

                            status = SQL_Execute(SQL_connection, sCode);

                            {— If status is equal to 0 the table is successfully deleted. —}

end if;

status = SQL_Terminate(SQL_connection);

The whole story is important especially for a process of upgrading tables, because if we do not delete stored procedures and just drop and create tables, some of the old stored procedures can stay and mix with the new ones, so real damage can be made.

Continuing our series, The Benefits of Offshore Development and Local Project Management, we would now like to discuss the benefit of access to a diversified team of highly skilled professionals.

When you utilize Merit Solutions Development Services, you have direct access to a highly-skilled team with proven technical, functional and domain expertise. Our 15+ software engineers work under 4 separate Team Leaders (Technical Team Lead, Development Team Lead, QA Team Lead, and SharePoint / CRM Team Lead). Each Belgrade-based Team Lead is managed in a very hands-on way by our US-based Director of Development, a top-notch programmer from Serbia who was instrumental in structuring our development division. In most cases, a project will blend consultants and engineers from the U.S. (analysis) with team members in Belgrade (design, coding, testing). So, our overall costs include a blend of both of these engineering locations. As mentioned before, each software engineer is English fluent, and capable of communicating directly with all of our clients.

This direct access to developers leverages our strong project management expertise, reducing the risks of miscommunication and ensuring the highest possible software development quality.

We are back for our next installment of “The Benefits of Offshore Development and Local Project Management.”

In our previous posts, we have discussed the benefits of our “nearshore location” in Eastern Europe, and the ability to take advantage of our scalable resources. In this article, we will discuss the benefits of our 24/7 virtual operations.

There is a natural time differential of 7 hours between our onshore (Chicago) and offshore (Belgrade) locations. This development model translates into a virtual 24/7 kind of operation for our projects. Leveraging our distributed resources in both locations, we are able to provide clients with maximum visibility into our software development lifecycle. We also ensure that team members, regardless of location, have overlapped work timings for day-to-day communication. We utilize video conferencing, instant messaging, web portals, and other online collaboration tools to maximize internal productivity. This enables fast and efficient client communication.

Last week, we started this series to emphasize the benefits of offshore development combined with local project management. (View the first article for benefits related to our office locations.) We call it a Hybrid Development Model, which allows us to deliver the highest quality development services to our clients at a fraction of the cost by providing the cost benefits of off-shore development services, while affording them the convenience and peace of mind of working directly with a US-based firm.

This week, we have a new benefit: scalable resources.

The Merit Solutions Development Team is composed of English-speaking and University-educated software engineers, so there is no loss in translation that is typical of other offshore development services. Our engineers have multiple skills, which allows us to utilize certain resources only when they are needed. This not only enables us to consistently deliver high quality services for large customizations, but also to effectively perform the smaller projects that often come up in Microsoft Dynamics customers’ environments.  We can scale down because there is very low overhead associated with project management and communication burdens compared to typical outsourced development.