« In Leading, The Vital Convergency Drives Outstanding Issues
This post deals mainly with:
- business
This article is for intermediate Outstanding Champaigns Sleight developer. It depicts the ways to phase extinct Manual dexterity functionality and supercede it with fresh engineerings.
Microsoft Outstanding Fields and its current programing linguistic communication Manual dexterity should still be regarded earnestly by developers community of interests. Nonetheless Microsoft Business concern Answers proclaimed switch to fresh engineerings, for the most part .Net, where all the Megabits practical applications will be ordered into suites (Microsoft Financials, Microsoft Statistical distributions, Microsoft Fabrication, Microsoft Human Resourcefulness) and incorporate into so named Microsoft Business organisation Portal site. Seeming into the future we advocate you to canvass Microsoft Outstanding Fields Manual dexterity customization for replacing it’s part with Microsoft SQL Waiter stored procs, Crystallization Reports, direct C#/VB.Net web publishing, eConnect
1. Supersede Manual dexterity pointer with SQL Hived away Process
Manual dexterity was intentional as multiplatform engineering (chiefly Btrieve, Ctree, SQL Waiter, potentially Seer). Sleight information regaining chemical mechanism is founded on Range start, Range End, Get First and Get Next articles. It is in fact like, withal a small spot obtuse to pointer in Transact SQL. Recollective ambits in Manual dexterity are full campaigners for replacing by SQL stored procedures with update article.
For illustration, view to supersede postdating Sleight 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.
Spell errEOF do
If Sales rep ID of table SOP_HDR_WORK = ERIC then
Redact table SOP_HDR_WORK.
Set Sales representative ID of table SOP_HDR_WORK to BILL.
Salvage table SOP_HDR_WORK.
End if.
Get next table SOP_HDR_WORK.
End spell.
With the postdating SQL code
Update SOP10100 set SLPRSNID=BILL where SLPRSNID=ERIC
Delivery novel information into a table in Manual dexterity is founded on change/edit table articles, in SQL they are equivalent (by public presentation) to introduce one record at the clip.
When having tenacious rhythm of modification/edit table in Sleight, view replacing by SQL stored procedure with Insert Into article.
2. Use Crystallization Reports, call them from via VBA in Limited sort
The easy mode to name Crystallization Report from your VBA code from your limited kind:
Const RPT = “D:ClientsTheClientInvoice Position.rpt”
Public crwApplication As CRPEAuto.Practical 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(”Crystallization.CRPE.Practical application”)
End If
Set crwReport = crwApplication.OpenReport(RPT)
crwReport.ParameterFields(1).SetCurrentValue (DocumentNo)
crwReport.Preview
End If
3. Use Direct .Net Entanglement Publication from Outstanding Fields Database
The leisurely and dependable fashion is to apply eConnect - SDK with VB samples, made for eCommerce coders and web interior designers to name the functionality in Microsoft Outstanding Fields. If your society can not give eConnect - make your own set of stored procedures to turn to Outstanding Champaigns database and go before with Optic Studio apartment.Net to do the web publishing.
Felicitous raising and customming! if you want us to do the business - yield us a phone call 1-866-528-0577! help@albaspectrum.com
Posted in Computers and Internet |