DataEase blog

By deafult, DataEase rounds UP a calculated numeric field (which is set to 1dcp or more).

Therefore, if field X = a + b + c and fields a, b & c is of 2dcp or more with each having a derivation of 1/3, DataEase rounds the calculated value to 1 instead of 0.99 (recurcive, depending on the number of decimal places).

If you amend field X’s derivation to:

floor(a*100+0.5)/100 + floor(b*100+0.5)/100 + floor(c*100+0.5)/100

Field X will now display 0.99 (recurcive, depending on the number of decimal places it has been defined to).

Have you had a chance to experience the power and flexibility of DataEase 7?

7 Reasons to Use DataEase 7:

• Vista Ready
  DataEase 7 is compatible with the latest Windows Vista operating system. As one of the first desktop databases to employ a 64-bit filing system, DataEase 7 is particularly suited to work with both Windows XP and Vista.
• Huge capacity
  DataEase 7 can hold and manipulate up to 16 billion records giving you plenty of scope to grow your application - provided of course that you have sufficient hard disk space!
• Multiple reporting outputs
  Produce reports in PDF, RTF, HTML and Excel. Very useful when sharing information with customers and colleagues.
• Real world forms
  Scan in real forms that can be filled in on screen then printed exactly as they appear. A quick and easy way to do away with manual form filling for good!
• Lots of new features
  MultiBox, Tab Controls, Relationship Diagrams, Catalog Display, Spin Lists, Memo Fields, and much much more. Take advantage of these features to quickly create smart business applications.
• Low cost upgrades
  Existing DataEase 6.52 users can upgrade to DataEase 7 for as little as £65 (exc. VAT). An absolute bargain when you consider the huge array of new features and benefits the new version gives you!
• Continuous development
  We are committed to continue improving and developing DataEase 7 - with two maintenance patches issued since its release we are in constant touch with our user base to deliver a product that continues to meet your requirements.
  

The DataEase Team

Use the “FileExist” function (which references the CDFS2.dll library) and not the “IsFile” function (which references the OSFUNC.dll library) to check if a file exists on your workstation or server!

Here’s a nice little utility that allows you to change your default printer.

Step 1:

Create the following CDF’s:
——————————————–
Function Name: GetDefaultPrinterA
CDF Library Name: Winspool.drv
Return Type: Long

Parameters:
prtNameBuffer – Long
prtNameSizeBuffer – Long
——————————————–
Function Name: SetDefaultPrinterA
CDF Library Name: Winspool.drv
Return Type: Long

Parameters:
prtName – String
——————————————–
Function Name: RecordSave
CDF Library Name: dfwacts.dll
Return Type: Int

After creating the above CDF’s, close and re-open your application. This simply refreshes the list of CDF’s, in particular the two you have just created.

Step 2:Create a new form with one field: ‘DefaultPrinterName’ Text 255, Prevent-Entry

De7, with its built in libraries, is now capable of printing your reports to PDF format, without the need for 3rd party utilities.

Simply design your report so that it displays the print dialog window when run, run the report and select the location to output the report in PDF format.

Alan Couchman, a Sapphire veteran for 18 years, passed away last week after treatment for cancer. During a long and versatile career with Sapphire, Alan filled a variety of senior management positions including Consulting Services Director. During all this time Alan carried on his duties with high integrity, genuine courtesy and a desire to help and support our customers. Alan was a true gentleman who was very popular with both customers and colleagues alike and will be missed by all who met him. Sapphire’s staff and friends send our thoughts and deepest condolences to his family.

Please note that new maintenance patches are now available for DataEase 7 and DataEase 7 Lite.

They will update DataEase 7 build 516/5016 to the latest 7.0.38.0, and DataEase 7 Lite build 616/6016 to the latest 7.1.38.0.

Go to http://www.dataease.com/support/downloads.php to download them now.

As a DataEase user you probably know that Sapphire has always offered you a number of high quality services such as Technical Support, Training, Conversions and Consultancy, but did you know that we also provided:Web Services - We help companies harness the power of the Internet, by designing and developing informative, community and e-commerce type websites. Complement these with our Internet Marketing solution to give your business a competitive edge in lead generation.

Legacy Transformation Services - We are able to convert or migrate many different types of legacy systems to your modern platform of choice, thereby reducing the cost and unlocking the business value of your legacy applications.

Application Development - We develop new applications using a variety of technologies to suit your specific requirements including Microsoft.NET, Oracle, DataEase, NetPlus and J2EE between many others. We leverage innovative technologies, techniques and assets for an outstanding solution design and delivery.

Offshore Resource Services (O.R.S) - We will establish your own offshore office in a choice of locations to enable you to do more for less at a quality higher or equal to local resourcing options.

And because we employ a unique onshore-offshore of combining highly experienced client facing project managers and analysts with development undertaken in one of our modern offshore centres, we can deliver cost effective and high quality solutions.

For more details visit www.sapphiregroup.com.

The DataEase Team