Dexterity was designed as multiplatform technology (primarily Btrieve, Ctree, SQL Server, potentially Oracle). Dexterity data retrieving mechanism is based on Range start, Range End, Get First and Get Next clauses. It is in fact similar, however a little bit slower to cursors in Transact SQL. Long ranges in Dexterity are good candidates for replacement by SQL stored procedures with update clause.
For example, consider to replace following Dexterity code:
Range clear SOP_HDR_WORK.
Clear 'SOP Type' of table SOP_HDR_WORK.
Clear 'SOP Number' of table SOP_HDR_WORK.
Range start table SOP_HDR_WORK.
Get first table SOP_HDR_WORK.
While errEOF do
If 'Salesperson ID' of table SOP_HDR_WORK = "ERIC" then
Edit table SOP_HDR_WORK.
Set 'Salesperson ID' of table SOP_HDR_WORK to "BILL".
Save table SOP_HDR_WORK.
End if.
Get next table SOP_HDR_WORK.
End while.
With the following SQL code
Update SOP10100 set SLPRSNID="BILL" where SLPRSNID="ERIC"
Bringing new data into a table in Dexterity is based on change/edit table clauses, in SQL they are equivalent (by performance) to inserting one record at the time.
When having long cycle of change/edit table in Dexterity, consider replacement by SQL stored procedure with Insert Into clause.
The easy way to call Crystal Report from your VBA code from your modified form:
Const RPT = "D:ClientsTheClientInvoice Status.rpt"
Public crwApplication As CRPEAuto.Application
Public crwReport As CRPEAuto.Report
Private Sub Print_BeforeUserChanged(KeepFocus As Boolean, CancelLogic As Boolean)
If SalesTransactionInquiryZoo.Type = "Invoice" Then
If crwApplication Is Nothing Then
Set crwApplication = CreateObject("Crystal.CRPE.Application")
End If
Set crwReport = crwApplication.OpenReport(RPT)
crwReport.ParameterFields(1).SetCurrentValue (DocumentNo)
crwReport.Preview
End If
3. Use Direct .Net Web Publishing from Great Plains Database
The easiest and safest way is to use eConnect - SDK with VB samples, created for eCommerce programmers and web designers to call the functionality in Microsoft Great Plains. If your company can not afford eConnect - create your own set of stored procedures to address Great Plains database and go ahead with Visual Studio.Net to do the web publishing.
Happy upgrading and customizing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, California, Texas, New York, Georgia, Arizona, Minnesota, Washington, Colorado and Florida and having locations in multiple states and internationally (help@albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.
bathroom cleaning service Northbrook ..I have yet to see a business that, sometimes in... Read More
When you buy a computer, it most likely comes with... Read More
How do you run a program on a remote server... Read More
Using professional icons in your application or website can bring... Read More
FTP stands for "file transfer protocol". FTP is basically a... Read More
Now is the time to look at an alternative to... Read More
Great Plains Inventory Management (IV) module gives your business a... Read More
In the real world a "fire wall" is a fireproof... Read More
As Mozilla Firefox nears 10% market share, with well over... Read More
It's all about turn times in the eMedia industry! The... Read More
Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta,... Read More
Looks like Microsoft Great Plains becomes more... Read More
What is 'adware'?Adware is basically software or scripts that are... Read More
We are in a transition phase in the Managerial Administration... Read More
What is Groupware?Have you ever had to manage document collaboration... Read More
One of the things we can be as certain of... Read More
Our hosted solution allow you to run your own search... Read More
If you have Microsoft Great Plains as main accounting and... Read More
The major reason I recommend getting your hands on real... Read More
This article is the fourth of a series of articles... Read More
Whether you need to close a sale, gather end-user feedback,... Read More
This article is the third of a series of articles... Read More
Most people don't use Photoshop to its fullest capabilities. Here... Read More
Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we... Read More
Let's say that you have a software project that's under... Read More
insured cleaning company Wilmette ..(1) Avoid using the same variable again and again for... Read More
Spyware, what it is and what it does. Basically, spyware... Read More
The vast majority of us will have, at some point,... Read More
Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Microsoft Business Solutions Great Plains and MS CRM (client relation... Read More
Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
Whether you are a small consultancy firm, a medium sized... Read More
Microsoft Business Solutions Great Plains was historically designed to serve... Read More
This tutorial covers OLAP solutions used by Data warehouses and... Read More
Microsoft Business Solutions CRM is now approaching the phase of... Read More
In the previous ISDN article, we looked at how and... Read More
Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
It's all about turn times in the eMedia industry! The... Read More
SOFTWARE PIRACY We regularly hear reports... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Our opinion is based on our Microsoft Business Solutions Great... Read More
Sometimes your PC will start acting strange for no apparent... Read More
In the new era of internet marketing the problem of... Read More
In the Clinton era the status quo was simple: you... Read More
Microsoft Business Solutions Great Plains has many years of successful... Read More
We've all seen the ads on TV for Netzero 3G.... Read More
A UNIX Shell is in simplest terms, a command line... Read More
Software |