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.
We all take the computer for granted. I mean, all... Read More
Some companies that are in need of fleet management may... Read More
Assertion facility is added in J2SE 1.4. In order to... Read More
If you've been using MySQL database to store your important... Read More
Now that spyware is the single most dangerous threat to... Read More
How many steps does it take you to locate and... Read More
Trying to figure out a stream in banning one email... Read More
Once a business idea is selected, it is highly recommended... Read More
Just stress testing one of the latest Linux distributions. Been... Read More
In 2004 Oracle, Inc. made its new step toward J2EE... Read More
Small can be beautiful! Working with Knoppix for the past... Read More
The adware and spyware definitions list is very long. But... Read More
First we had the original Google search that evolved into... Read More
After seeing many people complain about their weak Internet security... Read More
Our company, Novaprof Inc., developed unique software - DB Integration.... Read More
Anyone who has ever used Microsoft Word knows that it... Read More
Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Remember old good days when your company probably had Great... Read More
In the real world a "fire wall" is a fireproof... Read More
Costs of fleet maintenance software can vary widely. It is... Read More
Great Plains Accounting, accounting package for mid-size and small companies... Read More
Microsoft CRM customization techniques are very diversified and based on... Read More
It would be easy to think, like most people apparently... Read More
Best Software Act! is very popular CRM for small and... Read More
Fundraising software lets you connect with donors in a way... Read More
Looks like Microsoft Great Plains becomes more... Read More
Intro This concise article will tell you in plain English... Read More
Finding the best spyware removers to detect and remove spyware... Read More
We would like to give you several situations, when you... Read More
Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More
Looking at all the ads which promise to get rid... Read More
Three highly respected names in Human Resources have joined forces... Read More
Now that spyware is the single most dangerous threat to... Read More
You would like to protect your documents, wouldn't you? Reasons... Read More
Although we don't know whether Microsoft ever envisioned such a... Read More
Buying accounting software is a major investment. It's an important... Read More
Microsoft Great Plains may be recommended for international freight forwarding... Read More
While I was preparing some personal background information for a... Read More
SAP Inc., a global leader in client/server enterprise application software... Read More
Microsoft Great Plains, designed back in 1990th as database transferable... Read More
Microsoft Business Solutions Great Plains is very good fit for... Read More
In a previous article, I wrote about OpenOffice... Read More
Features Additionally, Vista will include many other new features.Aero Vista... Read More
Adobe Photoshop is one of the world's leading graphics editing... Read More
Music downloads are off the charts! We're listening to digital... Read More
When you need a phone number, you do a quick... Read More
If you have Microsoft Great Plains as main accounting and... Read More
Microsoft Great Plains serves majority of US based horizontal and... Read More
Software |