View RSS Feed

Recent Blogs Posts

  1. Data Access Blogs Moved to Our Web Site

    Dear Developers,

    we have moved our blogging environment from the forums to our new web site.

    We hope to continue to provide fresh and useful information to you, our customers. Please visit our new blogging home. There are already numerous blog posts waiting for you.
    Categories
    Uncategorized
  2. How to make Dynamic, Variable # Top/Bottom, Ranked, Drill-down Report Using Dynamic AI

    by , 28-Sep-2015 at 05:05 PM (Development Team Blog)
    It takes one mouse click on a total column heading in a Dynamic AI report to make it a Top 10 or Bottom 10 report, and just a few mouse clicks can combine multiple Top 10 reports into a single presentation like this Top 10 dashboard. But what if you want to let the user choose the number to rank, and choose if the report ranks from the bottom instead of the top of the totals? What if, unlike the examples presented in the above Top 10 Dashboard, you also want the rank number to appear on each row? ...
  3. More software for DataFlex web app developers

    by , 28-Sep-2015 at 12:00 PM (Development Team Blog)
    We are excited to announce today the beta test launch of new software for OAuth, RESTful & Web API Integration. This software enables developers to connect their DataFlex applications to a variety of web resources including Office 365, Google, Facebook, Meetup, MailChimp and more. Full details are in a new sub-forum. Use is free to licensed DataFlex developers.

    Some background….

    Data Access Worldwide's fundamental role is to help developers deliver more and better business ...
  4. SQL Injection Protection in the DataFlex Environment

    Overview

    This document provides information about SQL Injection attacks and how the risks associated with them are mitigated in the DataFlex application environment. When SQL statements written by a developer are included in an application program for direct execution by an SQL server, the developer is responsible for making sure that his or her programming style does not let the guard down for threats like SQL Injection or other risks.

    What is an SQL Injection attack? ...
    Attached Thumbnails Attached Files
  5. Manually Uninstalling DataFlex

    A normal uninstall procedure of DataFlex revision 19.0 and earlier requires three simple steps:
    1. Run Programs and Features (accessible through Control Panel on your Windows machine)
    2. Select to uninstall DataFlex
    3. Restart your computer to finalize the process (and release anything DataFlex that was loaded in memory)

    Sometimes users fail to execute step 3 and go straight to installing another build of DataFlex. What might happen is that files not released from memory will still be ...

    Updated 8-Apr-2023 at 09:05 AM by Marcia Booth

    Categories
    Uncategorized
  6. WebApp Framework Access Restriction

    The WebApp Framework comes with a prepared system for building proper secure Web Applications. By default there is the session manager that generates a unique key for each session and remembers the login state of this session and there are several hooks that allow the developer to easily implement access rules on view level. Now having this all in place it is just a matter of implementing the right hooks to restrict access to parts of the application based on the login state and user rights. But ...
  7. Migrating from 17.1 to 18.0: DataFlex Web Framework Structure Change

    If you are migrating a web application from Visual DataFlex 17.1 to DataFlex 18.0, you might need to take an extra step to get your application to successfully compile and run in the new revision.

    This is due to a change in the tWebRow structure used in DataFlex Web Framework.


    Background

    To understand the two main reasons for this change it is important to understand how this worked under 17.1.

    When the DataFlex web framework was developed, ...

    Updated 24-Apr-2014 at 10:03 AM by Dennis Piccioni

    Categories
    Uncategorized
  8. DataFlex Report Writer: Currency symbol not relying on Windows Locale

    If you use a numeric column in a report where the value requires a currency symbol (e.g. article price, order total) you can format the field to print a currency symbol before the number. In the following screenshot is the Euro symbol seen in front of the Credit Limit, the Purchases and the Balance.



    For this you format the field and on the Number tab-page you can choose between "Windows Default ...
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Default Currency.jpg 
Views:	23533 
Size:	63.2 KB 
ID:	7439   Click image for larger version. 

Name:	Double Currency.jpg 
Views:	10033 
Size:	53.0 KB 
ID:	7440   Click image for larger version. 

Name:	Custom Mask.jpg 
Views:	8283 
Size:	59.7 KB 
ID:	7441   Click image for larger version. 

Name:	create mask parameter.jpg 
Views:	8119 
Size:	64.9 KB 
ID:	7442   Click image for larger version. 

Name:	currency mask function.jpg 
Views:	8833 
Size:	103.8 KB 
ID:	7443  
  9. More test data please...

    This blog covers a little project I recently have been working on to create a larger and more diverse data set for the order entry workspace delivered as one of the examples. The set of data in the database delivered with version 17.1 was already increased and changed. This was mainly done to get a better set of data for the demonstration of Dynamic AI integration in a DataFlex application. The data in older versions of the workspace was a bit outdated and limited in size. While the increase was ...
    Attached Thumbnails Attached Files
  10. Modifying Application to use New Font System Introduced in 17.0

    Visual DataFlex 17.0 introduced a change in regards to fonts. Visual DataFlex 17.0 (and higher) allows true Windows fonts to be used in applications. Before 17.0, Sans Serif was the only font used in Visual DatFlex.

    That means that applications being migrated to 17.0 or higher may need to be adjusted in order to have the desired screen layout on all platforms and resolutions, but once you make this one-time change, your application should look the same on any platform.

    ...

    Updated 8-Sep-2014 at 01:10 PM by Marcia Booth

    Categories
    Uncategorized
  11. Configuring HTTP Compression for DataFlex WebApps

    A standard feature of the Internet Information Server is HTTP compression. This module is available to optimize the performance of web applications by compressing HTTP responses that are sent to the client. The goal is to decrease the size of the responses to allow faster network transmission. Of course this has the side effect that the CPU usage increases on the server (and on the client). So we are trading CPU usage against bandwidth here. This means that HTTP compression doesn't always make your ...

    Updated 17-Feb-2014 at 04:26 AM by Harm Wibier

    Categories
    Uncategorized
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	9 - Collection Editor Mime Types.png 
Views:	7595 
Size:	46.5 KB 
ID:	7181   Click image for larger version. 

Name:	12 - FireBug Response Header.png 
Views:	7322 
Size:	41.5 KB 
ID:	7446   Click image for larger version. 

Name:	11 - FireBug After Dynamic Compression.png 
Views:	6942 
Size:	24.7 KB 
ID:	7447   Click image for larger version. 

Name:	10 - Enable Dynamic Compression.png 
Views:	7054 
Size:	101.2 KB 
ID:	7448   Click image for larger version. 

Name:	8 - Configuration Editor Dynamic Types.png 
Views:	9296 
Size:	110.9 KB 
ID:	7449   Click image for larger version. 

Name:	7 - Configuration Editor.png 
Views:	6707 
Size:	109.4 KB 
ID:	7450   Click image for larger version. 

Name:	FireBug Disable Cache.png 
Views:	7143 
Size:	8.7 KB 
ID:	7451   Click image for larger version. 

Name:	FireBug with Static Compression.png 
Views:	6965 
Size:	27.3 KB 
ID:	7452   Click image for larger version. 

Name:	FireBug Before Static Compression.png 
Views:	7201 
Size:	85.9 KB 
ID:	7453  

    Click image for larger version. 

Name:	Enabling Static Compression.png 
Views:	7453 
Size:	104.2 KB 
ID:	7454   Click image for larger version. 

Name:	Compression In IIS.png 
Views:	7133 
Size:	137.2 KB 
ID:	7455   Click image for larger version. 

Name:	Installing HTTP Compression.png 
Views:	7290 
Size:	121.9 KB 
ID:	7456   Click image for larger version. 

Name:	Screenshot IIS Static Content.png 
Views:	6709 
Size:	57.6 KB 
ID:	7457  
  12. How to make an XML file look 'nice'?

    This blog is about XML readability. Since 1999 DataFlex is capable to handle XML in and XML out via classes defined in the FleXML.pkg (cXMLDomDocument etc). One of the most heard remarks in support questions is how to make XML readable for the human being as Microsoft XML writes the XML data as one long line of text. While OK most developers want to be able to read the content in an editor. You can easily format the XML file with tools like Notepad++ but how to do this from your own code?
    ...
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	xml raw.png 
Views:	7956 
Size:	3.7 KB 
ID:	7161   Click image for larger version. 

Name:	converted.png 
Views:	7452 
Size:	7.5 KB 
ID:	7162   Click image for larger version. 

Name:	google translated.png 
Views:	7713 
Size:	31.3 KB 
ID:	7163   Click image for larger version. 

Name:	converted pretty.png 
Views:	7925 
Size:	6.4 KB 
ID:	7164  
  13. Interactive Report in Windows with Visual Report Writer

    Now we are on the edge of delivering the final Visual Report Writer 3.0 I want to learn you how you can make use of the new interactive previewer that is available in the product. In this blog we create a report that shows all orders that used the current selected INVT item. Clicking on an order should bring up the order view with the clicked order found and displayed. Using the INVT table means that you can use the order entry example workspace.

    The Report
    The report needs to ...
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Inventory Ordered Report.png 
Views:	8439 
Size:	43.2 KB 
ID:	7061   Click image for larger version. 

Name:	select report.png 
Views:	8128 
Size:	15.6 KB 
ID:	7062   Click image for larger version. 

Name:	object names.png 
Views:	8006 
Size:	13.3 KB 
ID:	7063   Click image for larger version. 

Name:	remove filters.png 
Views:	8217 
Size:	9.8 KB 
ID:	7064   Click image for larger version. 

Name:	sort fields.png 
Views:	7896 
Size:	15.3 KB 
ID:	7065   Click image for larger version. 

Name:	options page.png 
Views:	7925 
Size:	13.5 KB 
ID:	7066   Click image for larger version. 

Name:	add image resources.png 
Views:	8264 
Size:	9.3 KB 
ID:	7067   Click image for larger version. 

Name:	options page 2.png 
Views:	8309 
Size:	9.6 KB 
ID:	7068   Click image for larger version. 

Name:	enlarged inventory view.png 
Views:	8148 
Size:	7.7 KB 
ID:	7069  

    Click image for larger version. 

Name:	invt view with report.png 
Views:	8136 
Size:	20.4 KB 
ID:	7070  
  14. PowerStatus event

    At the Data Access forums I found a question if it was possible to respond when the computer enters the sleep modus. The topic draw my attention and I decided to play around a bit. In this blog you learn how to make respond code.

    Notification event
    Windows can send a notification message to your application when changes occur in the power status. To be able to receive the notification message the application needs to register itself for receiving these messages. This is done with ...
  15. How to use Windows API functions in Visual Report Writer

    by , 19-Jul-2013 at 04:37 PM (Development Team Blog)
    In this blog I’ll show you how to use Windows API functions in Visual Report Writer.
    We are using the function [B]PathFileExists[/B] exposed by the library ‘[B]Shlwapi.dll[/B] ‘

    Visual Report Writer uses the [B]VARIANT[/B] type to communicate with the External Library Functions (ELF). Because of this Windows API’s can’t be called directly, doing so will stop the rendering of the reports as Visual Report Writer expects a variant type to return and direct calling might even crash ...
  16. How to make your own ELF

    by , 19-Jul-2013 at 04:33 PM (Development Team Blog)
    In this blog, i'll show you how to make a function number2words for use in Visual Report Writer. We are creating a dynamic link library (DLL) containing useful routines that can be used by Visual Report Writer. Using External Library Functions (ELF) is a great way to extend the functionality of Visual Report Writer.

    This walkthrough uses C and assumes you understand the fundamentals of the C language and Microsoft Visual Studio 2008.

    [B]This blog covers the following:[/B] ...
  17. Visual Report Writer and The Web (XIII)

    In this thirtheenth blog about Visual Report Writer and the Web I want to tell you how you can make a report that is interactive. A demo of a report that does this can be found at the Live Demo website (European Server, USA server). If this is the first blog you read I encourage you to read the twelve other blogs (1: The Solution, 2: Invoices Report, 3: The Cleanup, 4: The CustomerList, 5: The Orderlist, 6: The Credit and Balances Overview), 7: Inventory Stock Levels), 8: Sick Leave), 9: FileList (RDS)), ...
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	2013-07-11_063308.jpg 
Views:	8385 
Size:	68.8 KB 
ID:	6611  
  18. Visual Report Writer and The Web (XII)

    In this twelfth blog about Visual Report Writer and the Web I want to take you some not really report related features that can be found at the Live Demo website (European Server, USA server). If this is the first blog you read I encourage you to read the eleven other blogs (1: The Solution, 2: Invoices Report, 3: The Cleanup, 4: The CustomerList, 5: The Orderlist, 6: The Credit and Balances Overview), 7: Inventory Stock Levels), 8: Sick Leave), 9: FileList (RDS)), 10: Four Wine Data Based Reports) ...
  19. Visual Report Writer and The Web (XI)

    In this eleventh blog about Visual Report Writer and the Web I want to take you to the last not yet discussed report that can be found at the Live Demo website (European Server, USA server) named top 10 sales persons. If this is the first blog you read I encourage you to read the ten other blogs (1: The Solution, 2: Invoices Report, 3: The Cleanup, 4: The CustomerList, 5: The Orderlist, 6: The Credit and Balances Overview), 7: Inventory Stock Levels), 8: Sick Leave), 9: FileList (RDS)) and 10: ...
  20. Visual Report Writer and The Web (X)

    In this tenth blog about Visual Report Writer and the Web I want to take you to the next four reports that can be found at the Live Demo website (European Server, USA server) grouped under Wines. If this is the first blog you read I encourage you to read the nine other blogs (1: The Solution, 2: Invoices Report, 3: The Cleanup, 4: The CustomerList, 5: The Orderlist, 6: The Credit and Balances Overview), 7: Inventory Stock Levels), 8: Sick Leave) and 9: FileList (RDS)). Meanwhile we have been able ...
Page 1 of 8 1234 ... LastLast