Bookmark and Share

Software Information

Cisco Certification: Five Things To Do DURING Your CCNA Exam


There are plenty of articles out there about how to prepare for the CCNA exam.  However, there are also things you can do to increase your chances of success on exam day during the most important part of the entire process -- the time that you're actually taking the test.

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.ApplicationPublic crwReport As CRPEAuto.ReportPrivate Sub Print_BeforeUserChanged(KeepFocus As Boolean, CancelLogic As Boolean)If SalesTransactionInquiryZoo.Type = "Invoice" ThenIf crwApplication Is Nothing Then                                Set crwApplication = CreateObject("Crystal.CRPE.Application")End IfSet crwReport = crwApplication.OpenReport(RPT)crwReport.ParameterFields(1).SetCurrentValue (DocumentNo)crwReport.PreviewEnd If3.  Use Direct .Net Web Publishing from Great Plains DatabaseThe 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  

Choose your Java Wisely


Java has come along a long way.  Many would agree with this.  I did not until the Java 1.5 ?Tiger? hit me.  The tiger had several new features, and more importantly, it has new syntax.  Six major upgrades that the tiger presents are certainly the generics, enhanced for loop, autoboxing (unboxing), improvement on Typesafe enum, Static import and the metadata.  Of course there are many more, which can be found at java?s official site.  Out of these six, at least four would be used in my daily ?programming? life.  From java 1.1 to 1.4, it seemed more like new frills were simply added.  It felt like earning more brownie points when you downloaded the newer version.  But should I start using 1.5 immediately, maybe not.

Microsoft CRM Programming Secrets ? Tips For Developers


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.

Microsoft Great Plains Integration with Legacy Systems ? Overview For Developer


Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Small companies use Small Business Manager (which is based on the same technology ? Great Plains Dexterity dictionary and runtime), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations.

Microsoft RMS ? Great Plains Integration ? Overview For IT Specialist


Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS) are getting new market share due to the Microsoft strong marketing campaign. Both products: Microsoft Great Plains and Microsoft RMS are coming from the same Microsoft subdivision - Microsoft Business Solutions (MBS), however due to the fact that both products were bought by Microsoft from different vendors, the integration between the two is not an easy thing. At this time MBS has RMS integration on the General Ledger and Purchase Order level into Great Plains out of the box. This integration has some advancements in comparison to old product: QuickSell, but it is still GL and PO only. We do understand the need for midsize and large retail companies, structured as clubs and selling on account to their members to have more adequate integration when you can synchronize your Sales information and have robust Great Plains reporting.There is the product on the market, which is integration on the Receivables Management level from RMS to Great Plains, written by Daniel Sionov and Andrew Karasev and maintained by the alliance between LightEdge Solutions (www.lightedge.com) and Alba Spectrum Technologies (www.albaspectrum.com). In Alba Spectrum Technologies we actually do coding and product tuning for specific client needs.

Removing Incoming Email in MS Exchange, C# Example


The purpose of one of our projects was MS Exchange handler for processing incoming email.

A Guide To Purchasing Professional XP Icons Online And Enhancing Your Applications


Icons are used everywhere; right from software applications, to internet browsers, to operating systems to websites and even in print media. But businesses have to waste a good deal of money and time in manufacturing icons on their own. Professional icons are tough to create and need expertise in terms of creative artists, lots of time and software. But just as in any other field today, here again there are specialized organizations dedicated to manufacturing and supplying ready made icons. This article is meant for those of you who intent to purchase readymade XP icons for your applications

SyncUp ? A File/Folder Synchronizer For Windows


SyncUp, a file synchronizer is designed to assist the home and advanced users. The product has a simple and familiar windows explorer type interface for easy file handling. Further, the Scan Results provides a detailed preview of the files for synchronization.

OEComplete ? A Personal Information Manager


OEComplete is a utility for managing the personal information of the user. It is designed to be flexible and affordable even for the home user. OEComplete allows setting up appointments and tasks, and creates notes for easy reference. Recurrence, reminders and attachment enhance the competence in addition to import and export facility.

Microsoft Great Plains Dynamics on Pervasive SQL.2000 Data Repair ? Overview For DBAs


Some introduction into Great Plains Software products, now Microsoft Business Solutions. Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Small companies use Small Business Manager (which is based on the same technology ? Great Plains Dexterity dictionary DYNAMICS.DIC and runtime DYNAMICS.EXE), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations.

Microsoft Great Plains - Typical Problems And Fixes ? Overview For IT Administrators


How to delete the user? This is the first problem you encounter - when user shuts down the computer - Great Plains doesn't have the command to log off the user and when user tries to login the next day - she gets error message that user is already logged on. The fix:

Microsoft Navision Customization Upgrade ? Tips For Programmer/IT Specialist


Currently Microsoft Business Solutions is on the way of creating so-called suites: Microsoft Financials, Microsoft Distributions, Microsoft HR, Microsoft Manufacturing. It is very difficult to say which product will be the core of which suite, but the best guess is this: Microsoft Great Plains - Microsoft Financials and probably Distribution/Supply Chain Management and HR, Solomon - Microsoft Project or Professional Services, Navision - Microsoft Manufacturing. If you have Microsoft Business Solutions Navision and support it for your company then you need to know some technical details about Navision version upgrade and what is going on behind the scenes, which options do you have in case of C/SIDE customization or Jet Reports.

Is Your Family Protected?


When you think about Security, what do you think of? We all have one device or another to assist in keeping us safe. We have pad locks and security systems to safe guard our home, alarm systems to protect the equipment in our cars, parental controls on our cable TV and satellite accesses. We even have ways to protect our loved ones from computer invasions.But are we protected enough, are we using the best devices to combat the unwanted and dangerous intrusions, not to mention keeping our family from stumbling across those out on the internet?Let?s face it, without the proper soft ware to protect your computer, you are at risk every time you connect to the internet. There are the viruses, the Trojans and unwanted spam, not to mention the chat rooms where millions fall victim of on-line predators, and let?s not forget the #1 problem on the internet, pornography.You may be saying, but I have the best anti- spy ware money can buy and my internet service provides parental controls. Here?s the underlying question: How effective are they? Statistics show that 95% of internet users don?t have the adequate security to prevent attacks or control the content the computer user can access. The average computer is scanned by online intruders on average of 12 times a day. More and more victims are realizing the importance of these safety devices. The newest trend for identity theft is to steal information and cash out, out side of the country making it impossible to trace and leaving the victims with nothing to replace the funds.What do I do, you ask? Let me begin with the basics. There are four steps to take into consideration.1. Evaluate- There are diagnostic tools to find and identify dangerous threats to your computer. These tools are as simple as popping into you computer and scanning your hard drive. Threats are then identified with the proper recommended course of action to take.2. Eliminate- Once the threats have been identified the obvious next step is to eliminate. These security tools help scan, eliminate and block threatening spy ware, annoying ad ware and cookies, damaging worms and Trojan horses.3. Protect- Set up a barrier around your computer. This will keep intruders out and create a fire wall. This is the most effective way to defend you against hackers and avoid identity theft.4. Control- This final step will create a peace of mind for you, with the knowledge that you can avoid potentially dangerous web sites. You can block undesirable websites as well as avoid ones that try to download spy ware onto your computer.So what?s the next course of action? Find a security device that will cover these four steps and protect you from all of these hazardous things. There are even programs that will do this and automatically update every month to ensure added safety and avoid any new unknown danger. My advice, find them, get them on your computer to avoid any heartache that could happen. The average cost for these programs, to completely cover you computer, vary from $40- $120 depending on the collection of software you use. The products that will automatically update usually run $5 - $10 a month to give you the essential idea of, get it and forget it. Too many times we forget to update our securities and fall victim of these malicious acts. Don?t wait, don?t become a victim before you take action. What is the price for your safety?

Microsoft Navision Customization and Reporting ? Tips For Programmer/IT Specialist


C/SIDE (Client/Server Integrated Development Environment) - The core of Navision is the C/SIDE. C/SIDE is the foundation for all the business management functionality of Navision. It is made up of five building blocks, called object types, which are used to create the application. These five object types are shared throughout Navision to create every application area, and give it a unified, consistent interface. This powerful language allows for the internal construction of new business logic and sophisticated reporting. Because of the internal nature of modifications it?s highly recommended that you develop all your code in ?processing only? report objects and called from the native code base. By grouping all your code in logical units, upgrades and additional modifications are easier to manage.

More Articles from Software Information:
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39


© Athifea Distribution LLC - 2013