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.
maide service in Lincolnshire ..Research bears that less than 70 percent of development projects... Read More
Domino server is a buffer between the operation system and... Read More
Microsoft Business Solutions Great Plains was designed back in the... Read More
This article is the first of a series of articles... Read More
Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More
People often ask me: What image file formats will Photoshop... Read More
Are you a database professional? Do you work with a... Read More
What is Spyware?Spyware monitors your surfing habits and sends the... Read More
A few months back I really got sick of my... Read More
Sticky Noteshttp://www.deprice.com/stickynote.htmWith StickyNote 9.0, you can create beautiful 3D notes... Read More
Some introduction into Great Plains Software products, now Microsoft Business... Read More
When you visit department stores and see that majority of... Read More
Microsoft Great Plains, designed back in 1990th as database transferable... Read More
If you would like to pick something from Microsoft, or... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
Once upon a time not so long ago, there was... Read More
The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More
I provide, here clear explanations and a count of function... Read More
Document Manager and Version HistoryIn previous articles I have discussed... Read More
The term "document management" and "paperless office" is the subject... Read More
Almost all new and major brand of PCs come with... Read More
Best Software Act! is very popular CRM for small and... Read More
When you double-click a layer in the Layer Palette, you... Read More
Current Microsoft Business Solutions Great Plains has more that 10... Read More
Microsoft Business Solutions Great Plains was purchased from Great Plains... Read More
cleaning lady near Deerfield ..One of the main reasons business owners and entrepreneurs use... Read More
Corporate ERP/MRP selection might be tough one, especially considering very... Read More
If you have Microsoft Great Plains and support it for... Read More
Three highly respected names in Human Resources have joined forces... Read More
I have always regretted how Microsoft price gouges and rips... Read More
In our small article we'll consider Microsoft Business Solutions Great... Read More
Adobe Photoshop is one of the world's leading graphics editing... Read More
In the new era of internet marketing the problem of... Read More
Disclaimer: All the thoughts expressed are my views only! Your... Read More
Microsoft Business Solutions Great Plains has full-featured manufacturing set of... Read More
Great Plains Purchase Order Processing (POP) module makes up one-third... Read More
With this small article we are continuing Microsoft Business Solutions... Read More
SAP Inc., a global leader in client/server enterprise application software... Read More
When it comes to screenplay software each screenwriter needs to... Read More
There are many commands that are used in linux on... Read More
In part III of this ISDN primer, we learned that... Read More
Every day millions of new web documents emerge on the... Read More
Microsoft CRM is new player on the CRM software... Read More
Just imagine: you are walking, say, towards your car, and... Read More
Microsoft CRM is winning market share step-by-step from such the... Read More
The Software 2005 conference is now a wrap. This conference,... Read More
ERP Consulting industry is on the way to serve clients... Read More
This short paper will expand on two key reasons to... Read More
The destruction of the Soviet Union about 15 years ago,... Read More
OEComplete is a utility for managing the personal information of... Read More
Software |