Improving Great Flatlands Skill Personalization – changing to new technologies: SQL, Amazingly, eConne
1. Substitute Skill pointer with SQL Saved Procedure
Dexterity was made as multiplatform technological innovation (primarily Btrieve, Ctree, SQL Server, possibly Oracle). Skill information accessing procedure is depending on Variety begin, Variety End, Get First and Get Next conditions. It is actually identical, however a little bit more slowly to cursors in Manage SQL. Lengthy varies in Skill are excellent applicants for the alternative by SQL stored techniques with upgrade stipulation.
For example, consider to restore the following Skill code:
Range obvious SOP_HDR_WORK.
Clear ‘SOP Type’ of desk SOP_HDR_WORK.
Clear ‘SOP Number’ of desk SOP_HDR_WORK.
Range begin desk SOP_HDR_WORK.
Get first desk SOP_HDR_WORK.
While errEOF do
If ‘Salesperson ID’ of desk SOP_HDR_WORK = “ERIC” then
Edit desk SOP_HDR_WORK.
Set ‘Salesperson ID’ of desk SOP_HDR_WORK to “BILL”.
Save desk SOP_HDR_WORK.
Get next desk SOP_HDR_WORK.
With the following SQL code
Update SOP10100 set SLPRSNID=”BILL” where SLPRSNID=”ERIC”
Bringing new information into a desk in Skill is depending on change/edit desk conditions, in SQL they are comparative (by performance) to placing one history at plenty of your time.
When having a long pattern of change/edit desk in Skill, consider alternative by SQL stored process with Place Into stipulation.
2. Use Amazingly Reviews, refer to them as from via VBA in Customized form
The great way to Amazingly Review from your VBA rule from your modified form:
Const RPT = “D:ClientsTheClientInvoice Position.rpt”
Public crwApplication As CRPEAuto.Application
Public report 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”)
Set report = crwApplication.OpenReport(RPT)
3. Use Immediate.Net Web Posting from Excellent Flatlands Database
The simplest and most secure way is to use eConnect – SDK with VB examples, made for eCommerce developers and web developers to the efficiency in Microsoft organization Excellent Flatlands. If your organization simply can’t manage eConnect – c