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 vendors dump open source, go for the cash grab Computerworld Microsoft is removing this 30-year-old software from Windows: How you’ll be affected, alternatives and mo The Times of India The Single Best Artificial Intelligence (AI) Software Stock to Buy, According to a Wall Street Analyst -- No, It's Not Nvidia Yahoo Finance AI hallucinates software packages and devs download them – even if potentially poisoned with malware The Register GM loses another software leader amid more reorganization Detroit Free Press Elon Musk Pushes to Increase Use of 'Full Self-Driving' Software as Tesla Sales Cool The Wall Street Journal Finding software flaws early in the development process provides ROI Help Net Security DPP launches new software to improve efficiency Spectrum News Risk management specialist Abrigo snaps up TPG Software for investment accounting tech FinTech Futures Kilgore ISD receives $25000 for bus tracking software CBS19.tv KYTX Abrigo Buys TPG Software FinSMEs Productivity Boost: Real Uses of AI in the Software You Already Have Legal Talk Network Results: Progress Software Corporation Exceeded Expectations And The Consensus Has Updated Its Estimates Simply Wall St Shareholders in Paycom Software (NYSE:PAYC) are in the red if they invested three years ago Yahoo Finance Unpleasant Surprises Could Be In Store For Paycom Software, Inc.'s (NYSE:PAYC) Shares Simply Wall St Leading the Way: Software Solutions for Finance Leadership Excellence The Rolla Daily News - The Rolla Daily News We Need to Decarbonize Software IEEE Spectrum Take-Two Interactive Software, Inc. to Acquire The Gearbox Entertainment Company Inc., Developer of Highly ... Business Wire NAB 2024: RT Software Announces New Partnership with Videodata Sports Video Group Progress Software Confirms Bid to Acquire MariaDB The Wall Street Journal Defense Modernization Caucus aims to help military cut through red tape, acquiring emerging technologies and software 13newsnow.com WVEC NAB 2024: Evertz Highlights New Features for Its Software-Defined Video-Networking Solution Sports Video Group Hedge fund Citadel makes a rare software engineering hire from Twitter/X eFinancialCareers These 2 DevOps Stocks Are Must-Owns for Software Investors, Says Wall Street Analyst - Yahoo Finance Can Genesis Succeed Where Lexus and Infiniti Struggled? EVs and Software Could Be the Ticket MotorTrend The Government's Struggles With Outsourcing Software Development The New York Times Local startup launches AI productivity software aimed at blue-collar service companies RichmondBizSense HB Wealth Management LLC Boosts Stock Position in Take-Two Interactive Software, Inc. (NASDAQ:TTWO) Defense World Using Multicloud Network Software to Enable Business Critical GenAI Applications Featured The Fast Mode Switching to a Payroll Software Mid Year Is Seamless with Latest 2024 EzPaycheck Payroll Software PR Web NAB Show: Pebble Launches PRIMA Software Platform TV Technology 7 No-Brainer Software Stocks to Own Now InvestorPlace Software Stocks Give IBD 50 Something To Chew On As Charts Start To Look Better Investor's Business Daily Do Analysts Expect Paycom Software Inc (PAYC) Stock to Rise After It Has Gained 8.87% in a Month? InvestorsObserver Porsche partners with Applied Intuition to develop and deploy vehicle software Automotive Testing Technology International Rebellion Defense Secures GSA Contract to Provide Software Services to Government Clients ExecutiveBiz EVs, software spur higher automotive sales for microchip makers Automotive News Porsche and Applied Intuition announce joint developments Porsche Newsroom JFrog Software Supply Chain Report Shows Most Critical Vulnerabilities Scores are Misleading - CTech 15 Biggest Software Companies in the UK Yahoo Finance Australia Bytes and Bias– Unraveling the Influence of Gender Dynamics in Open Source Software hackernoon.com Intel, Microsoft Slip as China Blocks Foreign Chips, Software in Government Computers - Investopedia RLDatix Finalizes Acquisition of Breitenbach Software Healthcare IT Today AI Facilitates Rapid Development of Diabetes Prevention Software, Study Finds The Healthcare Technology Report. Battery Ventures Announces Strategic Investment in AdaCore to Propel the Future of High Integrity Software ... Business Wire Marelli has developed a Light Domain Controller to enable software-defined vehicle architectures StreetInsider.com |
RELATED ARTICLES
XML Parser and Their Types XML parser is a software module to read documents and a means to provide access to their content. XML parser generates a structured tree to return the results to the browser. Microsoft Navision Database Selection: C/SIDE or MS SQL Server - Overview For IT Specialist There are certain pluses and minuses in both cases and you should make your decision, based on your company needs. We'll give you some hints in this subject and you should know then where to look further. Understanding Document Management The term "document management" and "paperless office" is the subject of countless articles and books. Everyone wants to achieve this lofty goal but not everyone understands what the terms really mean. The Opera Alternative Security flaws have long plagued Internet Explorer (IE), the market-dominating web browser from Microsoft. IE won the early browser wars, not only because it was free and bundled with Windows, but because it had some features and capabilities that its only real competitor, Netscape, didn't have. Crystal Reports For Microsoft RMS - Overview For Developer/Report Designer If you are software developer or database administrator - we would like to give you the clues on Crystal Report creation for Microsoft RMS Database: Microsoft SQL Server or MSDE - this means that you can deploy native SQL driver for connection or use ODBC for flexibility. Tables Structure - it is extremely self-explanatory: Customer, Transaction (invoices, returns, layaways and others), TransactionAmount, Cashier, Tender to give you examples Links - Usually master table has ID column and Transaction-related table links by [Entity]ID column: Transaction. How To Identify, Cure and Prevent Spyware/Adware Infections Just when you thought you were Web savvy, one more privacy, security, and functionality issue crops up - spyware. Installed on your computer without your consent, spyware software monitors or controls your computer use. Microsoft Great Plains: Getting New Users Licenses - Annual Service Plan FAQ Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM require existing customer to be on active service contract: enhancement program. Minimal maintenance plan gives you free new software version (however upgrade itself, if it is done by your MBS partner is not free). Microsoft Navision and Crystal Reports - An Overview Microsoft Business Solutions - Navision is an integrated solution for small and midsize companies looking to expand their business operations without much interruption to its existing processes. Microsoft Navision enables businesses to alter as much or as little of its existing system, integrate add-ons and vertical segments of its development. 5 Time-Saving Tips in Microsoft Word Whether you have used Microsoft Word for years, have just switched from WordPerfect or are new to word processing, try these easy steps to save time and simplify your work in Word:Turn off Personalized Menus and ToolbarsAlthough it is a default, Personalized Menus and Toolbars is a terrible "feature" which limits your initial view to select toolbar buttons and menu commands. Do you only have one row of toolbars at the top of the screen? When you click on a menu, does it expand only after a few seconds? If so, you will save yourself a lot of frustration by turning off this personalized display:1. Crystal Reports For Microsoft Navision - Overview For Programmer/IT Specialist Let us give you - developer some hints in the report creation. C/SIDE database - use C/ODBC to create the connection for your Crystal Report. 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. An Easy Way to Deal with Email Viruses and Worms If you feel intimidated when someone tries to teach you something new on the computer, this article is for you!In the course of my career, I've worked with many people who I knew were smart but were convinced that they couldn't learn how to do new things on a computer. At some point, they'd convinced themselves that they weren't one of those "computer people". A Time-Saving Programming Tactic that Doesn't Work Let's say that you have a software project that's under severe time pressure. Let's say that this deadline is so tight that you already know it will involve many late nights of black coffee and frenetic programming. 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. 7 Things to Consider Before Buying Small Business Accounting Software The world of small business accounting software can be a minefield for any business owner. However choosing the right package is one of the most critical business decisions you will make. Microsoft CRM Customization - Processing In/Out-Going Email Messages We would like to give you several situations, when you may need custom development and programming to improve Microsoft CRM functionality. This overview is for programmer, software developer, IT specialist, database administrator. Software Piracy SOFTWARE PIRACY We regularly hear reports about the cost to the software industry of software piracy, but are the claims to be taken at face value? Statistics are notoriously biased towards what the author is trying to say. Types of Software: There are three basic types of software, although these do have their own subsections, as will be discussed later: 1. Groupware: What Works the Way Businesses Do? GroupwareThe internet is full of 1.5 million to 7 million indexed pages of groupware packages available on the market today. Microsoft CRM Customization Secrets - Second Edition This article is for advanced Microsoft CRM SDK C# developers. It describes the technique of direct SQL programming, when SDK doesn't have the functionality to do the job. Your Computer May Be Infected, Heres How To Check (NOT about virus) NOTE: Please take time to read on - it may be vital for your PC's security. If you are not in the mood, just save it or print it out for later reference. |
home | site map |
© 2006 |