| |
| |
|
Software Information |
|
|
|
Upgrading Great Plains Dexterity Customization - switching to new technologies: SQL, Crystal, eConne
1. Replace Dexterity cursor with SQL Stored ProcedureDexterity 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.
2. Use Crystal Reports, call them from via VBA in Modified formThe 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 (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.
MORE RESOURCES:
Software - Google News |
|
|
|
RELATED ARTICLES
QuarkXpress Tips: How to Move Content Between Print and Web Layouts Since its release in 1987, QuarkXpress had made an immediate impact to computer enthusiasts. QuarkXPress introduced precision typography, layout and color control to the desktop computer, and delivered those features to designers at a fraction of the cost of proprietary typesetting systems. Microsoft Great Plains Oil & Gas - Implementation & Customization Highlights Microsoft Great Plains serves the wide spectrum of horizontal markets. Great Plains could be considered as ERP platform, which you could expand with third party modules or advance with your own in-house custom functionality. How To Develop Software For Your Business Software development is a risky business.Many software developers are barely skilled at their trade, much less at business. Fleet Maintenance Software Reviews Innovative Maintenance Systems (IMS) is one company that offers solutions for companies in need of fleet maintenance software. One of their most popular products is Fleet Maintenance Pro®. SQL scripts for Project Accounting: Microsoft Great Plains series - overview for developer Microsoft Business Solutions Great Plains has Project Accounting module where you can budget the project, assign it to customer contract and then log expenses, timesheets, inventory spending, and finally bill the customer against the project or contract. Microsoft Great Plains Project Accounting does excellent job, but there are cases when you need developer or MS SQL DB Admin touches. Microsoft CRM in Latin America: Implementation, Customization, Support - Overview for Consultant Microsoft Business Solutions CRM is present several years on the US software market plus it makes advances in Europe. We expect substantial number growth of Microsoft CRM implementations across South and Central America and the need for Microsoft CRM implementation, support, tuning, reporting, training services, especially in such countries as Mexico, Columbia, Venezuela, Argentina, Peru, Uruguay, Chili, Costa Rica. Corporate ERP: Microsoft Great Plains For The Plant In Brazil - Overview For CIO Microsoft Business Solutions Great Plains as new ERP for multinational corporation manufacturing facility in Brazil.If your company plans to outsource manufacturing in Brazil by purchasing existing facility there, the first step would be to implant new management team and revise business processes and procedures. Professional XP Style Icons in Software and Website Development Using professional icons in your application or website can bring a modern and aesthetically pleasing appearance to your product or service. This will not only help you to attract potential customers but also give you that "edge" you need to stand out from your competitors. Beware of The Pirated Software E-Mail Scams! You have gotten those E_Mails buy software at deep discounts. It is very tempting to save 85% to 95% on your favorite Software Titles. Dreamweaver vs FrontPage There are two major WYSIWYG(What You See Is What You Get) editors available for beginners. These are: Microsoft FrontPage and Macromedia Dreamweaver. Brief Notes About Mainframe Software Pricing We don't think about mainframe software pricing anymore, we just go out buy a server hardware/software "package" from Microsoft, but did you ever tink about how they got their ideas for the usage licence, it all started with IBM and the introduction of Cmos logic technology in 1994, simnce then mainframe software pricing has steadily became disproportion to the comparatively minute hardware costs, which has been stated to be "typically four to five times the hardware cost" in terms of the system budget.This trend has given rise to growing concerns over the direct results of current software pricing techniques which are leading to problems such as making smaller applications costly to operate on large systems. When is a Software Engineer Not a Software Engineer? The title of "software engineer" has got to be among the most highly abused in the corporate high-tech world. It's also one of the most popular. Business Planning Software Once a business idea is selected, it is highly recommended that we sharpen the concept by a detailed planning process. The result of this step is a comprehensive business plan, with its major components being the marketing "mix," the strategic plan, operational and logistical structures, and the financial proposal. OS 101: Suggestions for Choosing an Operating System An operating system (abbreviated OS) is essentially the path through which a computer accesses files, games, the Internet, and all vital stored information. The OS is the most important program on a computer because it runs all of the other programs. Microsoft CRM for Large Corporation - Security Microsoft Business Solutions CRM proved to be reliable solution in the whole spectrum of industries and market niches: transportation & logistics, education, recruiting & placement, supply chain management, pharmaceutical, oil & gas, aerospace & defense, manufacturing, wholesale & retail. When corporation is looking into CRM application to choose from - one of the fist questions is security. Hear It in Digits Music downloads are off the charts! We're listening to digital music in the digital era.The driving force behind the phenonmena is the technonolgy called MP3. Basic Steps To Optimize Your Internet Security After seeing many people complain about their weak Internet security I decided to write down some things that will help you for your Internet security.First, here are some tips to make windows safer :For basic security and update patches install Service Pack 2 for Windows XP or Service Pack 4 for Windows 2000. Separate Anti-Keylogging Protection: Who Needs it Most? If there still are few unprotected computers left, I haven't seen any. Every emerging threat causes means of defense to appear. Know-how in Microsoft Publisher For those who still don't know, Microsoft Publisher helps computer users to easily create, customize and publish materials such as flyers, brochures, catalogs, newsletters and websites. It provides tools to create professional and compelling marketing materials that will help you take your business further. Make or Break Factors - When Considering Estimating Software Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can prove to be a major factor in the success or failure of their business.When a customer requests a bid on a job, they need a fast turnaround, and the best price.
|
| home | site map |
| © 2006 |
