Overview


VETLINKSQL is full of modern programming technology which will assist the user and allow sophisticated processes to be implemented. Some major architectural technology features are explained below.

SQL Database


VETLINKSQL uses an industrial strength SQL (Structured Query Language) database. This technology provides a very high degree of reliability and robustness and allows very fast retrieval of information regardless of the database size. Reporting with SQL databases is also made very easy and virtually “anything” is possible. SQL databases also allow “Stored Procedures” to be utilised in the database for very fast access to information.

Stored Procedures


VETLINKSQL uses a large number of stored procedures to perform complex tasks. Stored procedures in SQL databases are “programs” that are written into the data itself, and can process huge tasks across a huge database within fractions of a second with a very high degree of reliability. At last count, there were over 300 stored procedures in VETLINKSQL. One example of the use of a stored procedure is the generating of client statements for printing. For a client base of around 10,000, a statement build can take as little as two minutes – and this is while all users are still online using the entire application during the day!

MDI Technology


MDI (Multiple Document Interface), technology allows the user to work on an unlimited number of windows at the same time on screen. Unlike legacy applications where you have to close a task window to perform another task or have a limit of open windows, this technology allows virtually an unlimited number of multiple windows to be open at the same time on-screen. Some older applications will achieve limited success by either allowing you to run multiple copies of the program or provide “tabs” to access other relevant information. This should not be confused with true modern MDI technology where you decide (and not the program) what you want to be working on. This technology allows full and independent windows on-screen (not minimized) to do virtually anything at any time.

Intelligent Notes


This is an embedded technology within the program. This feature allows the user to create one-time only or shared notes (with full mail-merge capability) that may be “attached” to clients, animals, bills or products. The “sticky” notes may then be “programmed” by the user to pop up or print out all through the program based on the user’s preference. Examples include: Pop Up at Appointment, Pop Up at Billing, Pop Up on Arrival, Pop Up on Order, Print on Bill, Pop Up on Inward Goods Receipting, etc. With this embedded technology in place, future updates of the program will simply add on new attributes for Pop Ups and Printing wherever required.

Object Oriented


VETLINKSQL is developed using modern OOT (Object Oriented Technology). This allows for a very well structured code base that is easy to maintain and update. “Objects”, once written and tested, may be used all throughout the program with ease. A bug-fix on an object means that the entire application where the object is implemented is automatically updated and fixed. This is the only way forward for modern applications – ask your vendor in writing if their application is Object Oriented – if not, you could be buying very old legacy technology.

Zero Downtime Design


VETLINKSQL has been designed so that virtually all tasks can be performed while users are busy using the application. These include, but are not limited to:
  • Database Backups
  • Statement Printing
  • End Of Period Functions for all Ledgers
  • Bulk Mailers and mail-merge letters / reports

Document Manager


A Document Manager is integrated into every Client, Animal and Product/Service record. This component provides a fast and easy method for the creation, storage, and retrieval of information such as Notes, Phone Notes, Letters, emails, and SMS messages. While MS Word can also be used, an integrated fully graphical word processor with spell checker is built-in with a full one-step mail-merge functionality at every workstation, thereby reducing the overall cost of implementation for a practice. The fully integrated word processor can be used to make standard templates that can automatically populate all variables for instant mail-merge! Best of all, it is supplied free of charge with VETLINKSQL for every workstation.