| Home | Links |
1. Replace Dexterity cursor with SQL Stored Procedure
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.
2. Use Crystal Reports, call them from via VBA in Modified form
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 (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.
Advent Software to Host Analyst and Investor Day Event on Friday, May 11, 2012 Reuters SAN FRANCISCO - February 6, 2012 - Advent Software, Inc. (NASDAQ: ADVS), will hold its Analyst and Investor Day in New York on Friday, May 11, 2012, beginning at 9:00 am (EST). The meeting will feature presentations by Advent's executive team covering ... Advent Software Achieves Record Quarterly Revenue of $86 Million and Record ... Advent Software's CEO Discusses Q4 2011 Results - Earnings Call Transcript Advent Software Q4 Profit Drops; Issues Q1, FY12 Revenue Outlook - Quick Facts |
Scorpion Software Announces AuthAnvil Single Sign On Support for Level ... San Francisco Chronicle (press release) Scorpion Software, an industry leader in strong authentication and password management solutions for IT Service Providers and IT departments is pleased to announce integrated support for AuthAnvil Password Solutions with Level Platforms, ... Scorpion Software Offers Support for Level Platforms Managed Workplace |
Caduceus Software Plans to Integrate a Cloud Platform with its Software ... SmallCap Network By Ed Liston Caduceus Software Systems Corp. (OTC: CSOC), a software company specializing in the development of an all-in-one solution for private practitioners and doctors, today, said that it plans to integrate a cloud platform with software systems. Caduceus Software Systems Corp. Plans to Integrate a Cloud Platform with its ... QualityStocks News - Caduceus Software Systems Provides Update on Current ... |
Proposal Software Continues Strong SaaS Revenue Growth in 2011 MarketWatch (press release) WESTPORT, Conn., Feb 06, 2012 (BUSINESS WIRE) -- Proposal Software, Inc. (PSI), The Leader In Proposal Productivity(TM), and makers of PMAPS(R) WebPro (Proposal Management and Production System) announced 2011 results that continue its systemic growth ... |
Manhattan Software Announces Strategic Partnership With Indiabulls for ... MarketWatch (press release) 6, 2012 /PRNewswire via COMTEX/ -- Manhattan Software, the global leader in enterprise real estate software and a leader in the 2011 Gartner Magic Quadrant for Integrated Workplace Management Systems, announced today a strategic partnership with ... |
Mezeo Software Announces National Master Distributor for Japan MarketWatch (press release) HOUSTON, TX, Feb 06, 2012 (MARKETWIRE via COMTEX) -- Mezeo Software(R), a leading provider of cloud storage management solutions, today announced the appointment of a master distributor for Japan, AIR Company Limited, a Japanese company focused on ... |
The Cloud Software Companies You Need to Know About Motley Fool But software as a service is easy enough to define. Whenever you have to access your application through a central location, and pay ongoing license fees to the developer, that's generally software as a service. Microsoft's Office suite is plain old ... |
Is BMC Software Growing or Slowing? DailyFinance By Seth Jayson, The Motley Fool Posted 4:11PM 02/06/12 Investing There's no foolproof way to know the future for BMC Software (NAS: BMC) or any other company. However, certain clues may help you see potential stumbles before they happen -- and before ... |
Oakland police get free forensic software to analyze Occupy videos San Francisco Chronicle (blog) A Pasadena forensic video enhancement software company has donated its technology to Oakland police to help in capturing the goings-on at Occupy Oakland demonstrations, the company announced in a statement. At the request of Oakland law enforcement, ... |
Longwood Software Establishes Strategic Reseller Agreement with Canada's Interlinc MarketWatch (press release) MAYNARD, Mass., Feb 06, 2012 (BUSINESS WIRE) -- Longwood Software, Inc., the developers and marketers of the RevBase(R) software-as-a-service (SaaS) marketing asset management system ( www.revbase.com ), announced today a strategic reseller agreement ... |
Google News
Related Articles
Microsoft CRM Integration with Lotus Notes Domino: Messaging Connector ? Future Directions
IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management) from now on can work in tandem. Microsoft CRM Lotus Notes Domino connector from Alba Spectrum Technologies provides seamless messaging in MS CRM through Domino. Our customers suggest future direction for the connector. Considering our consulting practice experience in MS CRM and Lotus Notes customization, upgrade, integration ? in this small article we'll reveal our half year development plans
Cisco Certification: Introduction To ISDN, Part III
Configuring PPP PAP Authentication
Microsoft Great Plains FA: Fixed Assets ? Overview For Consultant
Great Plains Fixed Assets Management module is a robust tool that can help you manage your assets effectively. It integrates perfectly with other Great Plains modules like General Ledger, Purchase Order Processing, and Payables Management ensuring accuracy while reducing redundant data entry.
Database Guru James F. Koopmann Reviews DBxtra Reporting and Query Tool
DBxtra is a powerful query and reporting tool that hides many of the complexity and technical expertise required for creating connections to disperse data sources, building queries, designing reports, and delivery information throughout an enterprise or to your customer base.
Free Software - Powerful Alternatives to Budget-Busting Software
When you buy a computer, it most likely comes with Microsoft Windows preinstalled. And when you need a word processor, spreadsheet, or other software, you probably buy it from a computer store. That software is vital. Without it, a computer is just an expensive paperweight.
Can You Calculate Complex Financial Calculations?
Are you a whiz at calculating financial information? Not the easy personal stuff, like figuring out your monthly mortgage based on a fixed interest rate for x number of years, or how much money you have available each month after all your bills are paid. (You can probably use your fingers to figure that one out!)
Four Desktop Tools To Drastically Increase Your Productivity
Sticky Notes
Brand Your Websites URL With a Favicon
Have you ever noticed that when you look at your browser favorites menu or the address bar, some entries have their own little icon beside their URL?
Start Developing Your Own Software
Learning how to program software seems like a daunting task fit only for the geeks and nerds who lock themselves away in dark rooms staring at their monitors for days on end as they pour over thick manuals written largely in zeros and ones. Fortunately the reality is that it's not as complicated to make basic applications as people may think. If it were, the majority of nerds wouldn't be doing it because the defining factor of our kind is an inherent laziness. Why do you think we like computers? The heaviest thing we have to lift is a monitor and that's done fairly irregularly and for a very short period of time.
Groupware: Avoid the Ad Hoc Shuffle
Groupware
MicroWorld Releases New Version of MailScan Ver. 4.5 - Antivirus and Content Security Software
MicroWorld Technologies, Inc. the leading solutions provider in the area of Anti-virus and Content security, has announced the launch of its new version of MailScan Ver. 4.5, the antivirus and content security software for mail servers.
Great Plains Dynamics on Pervasive/Ctree support ? overview for consultant
All of us know that Microsoft bought former Great Plains Software and formed Microsoft (Great Plains) Business Solutions in the earlier 21st century. It was total success for GPS, we guess, but for Great Plains Dynamics / eEnterprise / Dynamics C/S+ clients it was the time of change. First of all ? Great Plains Software, as being independent corporation in 1990th had to stake on certain future predictions. They decided that future should be based on these two basic principles:
Software Upgrades Arent Always the Best Move
When my daughter was getting into AOL instant messaging (AIM) and using all the cool add-ons, I looked for more as it's a great way to learn about extending applications. While doing research, I learned that if you wanted to use AIM themes, you don't want to upgrade to AIM 5.9. A post at MyThemes suggests sticking with or downgrading to 5.5. MyTheme shows what steps to take, should you prefer to stick with 5.9. The post also shows where to download 5.5 and how to downgrade back to it. Furthermore, 5.9 was bloated. Think it took a while for AIM to completely load in 5.5? 5.9 is worse.
SQL: Querying Microsoft Great Plains ? Overview for Database Administrator/Developer
Microsoft Great Plains Customization and Development ? Overview for Programmer
When Great Plains Software was designing and developing Great Plains Dynamics/Dynamics CS+/eEnterprise - it placed several fundamental principles into the system
Where to Find Free Fleet Maintenance Software
Costs of fleet maintenance software can vary widely. It is generally expected that the fleet manager will look at the needs of the company to determine what software package is best suited for their particular needs. Depending upon the size of the company, number of vehicles to be maintained and services of the company, you may be able to locate free fleet management software for your needs.
Microsoft Great Plains Customization Recovery & Upgrade for Large Corporation
At the end of XX century, in the late 1990th Great Plains Software eEnterprise was recognized as one of the leader on the midsize to large corporate ERP market. Due to the nature of eEnterprise architecture - it is Great Plains Dexterity based application and Dexterity imposes some specific to the database access and table structure ? eEnterprise was subject to relatively inexpensive customization. During the recession time a lot of former Great Plains Software and then Microsoft Business Solutions partners either went out of business or merged with Auditing firms and their Great Plains clients saw this instability and simply stopped annual enhancement program payments and become so-called orphan clients. Today, in 2005 ? it is time to upgrade from eEnterprise 6.0 to Microsoft Great Plains Professional 8.0. If you have major customization for eEnterprise ? you need to understand your options before you find your new Microsoft Business Solutions VAR of record. In this small article we will describe you the main steps and options to upgrade Dexterity customization:
Cisco CCNA Certification: Becoming A Truly Valuable CCNA.
I've been active in the Cisco Certification track for four years, working my way from the CCNA to the coveted Cisco Certified Internetwork Expert title, and during that time I've conducted job interviews and casual conversations with hundreds of CCNAs and CCNA candidates.
Can Group Collaboration Software Meet Business Needs?
According to a survey conducted by InfoTrends/CAP Ventures entitled "Content-Centric Collaboration," 51 percent of businesspeople utilizing technology such as Microsoft Office and e-mail collaborate almost daily as a part of their business operations and need group collaboration software to support electronic collaboration.
Is Your Computer Sick?
Viruses and spyware usually show up on your computer one of two ways.
Common misspellings for words used in this page include acuracy addres adn adres adress affort ahev ahve almsot alomst alsot amke anbd annouced anounced anual aplication apon applicaiton applicaitons archetecture architechture artical artice articel aslo availaible availble availiable availible avalable avaliable avilable awya baceause bakc baout bcak beacuse becasue beccause becouse becuase bedore befoer beng buisness busineses busness bussiness ceratin certian claer clera cmoputer comany comapany completelyl concider consdider coputer corparate creaeted decribe definining delevopment desgined desigining dessigned developement develpment devolopement discribe doign donig durig durring duting eahc ealier eiter enchancement ened entitlied enxt equialent equivelant equivelent equivilant equivilent equivlalent expeced experiance expierence eyar fidn finacial follwoing folowing fomed fomr frome fromed fundametal generaly gerat graet grat gropu haev halp haviest howver hten htey htikn hting htink htis hvae hvaing hvea hwile independant independendet indipendent indpendent infomation informtion inot intergration intrest iwll iwth jstu jsut knwo konw kwno larg launchs leran liek littel liuke maintainance maintainence maintance maintenence majoroty managment mantained marjority messenging mkae mkea moeny moreso morgage mounth mroe nkow nkwo nowe nto omre onyl otehr owrk parituclar particualr paticular peopel poverful poweful powerfull pratice preiod preriod probablly probaly procedger proceedure realitvely reconized recquired recrod relativly relitavely relpacement requred rocord severeal shoudl shoudln simpley smoe soem sofware sohw specfic specif strat stucture sturcture succsess sucess taht tath technnology technolgy teh tehy tghe thast theese themselfs themslves theri thgat thge thier thign thikn thiunk thn thne thnig thoughout througout thru thsi thta thyat tiem tihkn tihs timne tiome tje tjhe twpo tyhat tyhe uise usally useing usualy ususally verison veyr vrey vyer vyre waht wass watn weas wehn whant whith whn whta wih wiht wille witht witn wiull wnat wnated wokr wokring writen wrok wroking ws wtih wupport yearm yera ytou yuo.