View RSS Feed

Most Popular Blogs

  1. Product Registration: All you wanted to know but were afraid to ask

    What??? Connectivity Kits and Visual DataFlex combined in one serial number? How can I use it? What about the web server? Can I use the same registration program to enter all my licenses? Which license should be active? And what does being active mean anyway?

    If those questions have crossed your mind but you never really asked them, just carry on reading; this is your chance to get them all answered.

    The Pieces: Types of Licenses

    • How does Data Access
    ...

    Updated 29-Jun-2016 at 05:04 PM by Marcia Booth

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

Name:	Registration1.JPG 
Views:	1727 
Size:	35.6 KB 
ID:	3753   Click image for larger version. 

Name:	Registration2.JPG 
Views:	1792 
Size:	44.2 KB 
ID:	3754   Click image for larger version. 

Name:	Registration3.JPG 
Views:	1745 
Size:	42.7 KB 
ID:	3755   Click image for larger version. 

Name:	Registration4.JPG 
Views:	1700 
Size:	36.3 KB 
ID:	3756   Click image for larger version. 

Name:	Registration5.JPG 
Views:	1819 
Size:	39.8 KB 
ID:	3757  
  2. Windows 2003 Test Environment: Getting rid of a few Annoyances

    Depending on what you are working on, certain improvements in security that Microsoft implemented become annoyances in your test environment. On Windows Server 2003, my favorite two that I need to turn off immediately are:

    1. Internet Explorer Enhanced Security Configuration
    2. Shutdown Event Tracker


    1. Internet Explorer Enhanced Security Configuration
    By default, this is enabled on Windows 2003. Whenever you open IE, you get the message below displayed ...
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	ShutdownEventTracker.JPG 
Views:	1860 
Size:	33.1 KB 
ID:	3760   Click image for larger version. 

Name:	DBE- DidYouKnowBlocked.JPG 
Views:	1604 
Size:	40.3 KB 
ID:	3765  
  3. Arrays & Structs in-depth Part II

    by , 8-Sep-2009 at 08:00 AM (Development Team Blog)
    In [URL="http://support.dataaccess.com/forums/blog.php?b=26"]Part I[/URL] we were just getting warmed up and started looking at the basics of arrays and struct types. Now things are about to get more complicated as we dig in deeper.

    [B]Sorting Arrays[/B]
    If you have [I]Integer[] myArray[/I] for example, then sorting is very simple and straightforward. You simply do [I]Move (SortArray(myArray)) to myArray[/I], and you're done. The runtime takes care of all the magic ...
  4. How to get volume information

    Always wanted to know what drives are available in your computer? Wanted to know what the status of the drive is? Wanted to know the serialnumber (e.g. 503E-A401)? Wanted to know is filename casing preserved? No... then go to the next blog. Yes, read on...

    Drives
    Visual DataFlex has a command called GetDskInfo. You pass it an integer and because drives can be assigned to a drive letter there is a maximum of 26 drives. So we can make a loop through all the drives. In the following ...
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	VolumeInfo.jpg 
Views:	1388 
Size:	74.8 KB 
ID:	3766  
  5. Arrays & Structs in-depth - Conclusion

    by , 6-Oct-2009 at 08:00 AM (Development Team Blog)
    To wrap up this multi-part series about arrays and structs I'll highlight a few key areas and answer some questions that came up.

    [URL="http://support.dataaccess.com/forums/blog.php?b=26"]Part I[/URL] starts by showing the basic use of structs and arrays, how they can be used together and as parameter & return types.

    [URL="http://support.dataaccess.com/forums/blog.php?b=27"]Part II[/URL] discusses how sorting and searching works with native arrays. ...
  6. On the same (code) page

    by , 17-Dec-2009 at 11:00 AM (Development Team Blog)
    International characters have always been very complicated to deal with in computer systems, and configuring your computer for your locale is often more difficult than it should be. Have you ever had the problem where extended ascii characters such as [IMG]http://support.dataaccess.com/forums/blog_attachment.php?attachmentid=59&stc=1&d=1260836739[/IMG] ends up being displayed in a dbForm or similar in your VDF application as [IMG]http://support.dataaccess.com/forums/blog_attachment.php?attachmentid=60&stc=1&d=1260836885[/IMG] ...

    Updated 24-Mar-2011 at 01:03 PM by Marcia Booth

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

Name:	us-good.jpg 
Views:	1927 
Size:	43.0 KB 
ID:	3779   Click image for larger version. 

Name:	swe-bad.jpg 
Views:	1956 
Size:	42.3 KB 
ID:	3780   Click image for larger version. 

Name:	conflict.jpg 
Views:	1845 
Size:	37.9 KB 
ID:	3781   Click image for larger version. 

Name:	settings-xp.jpg 
Views:	1905 
Size:	93.2 KB 
ID:	3782   Click image for larger version. 

Name:	settings-vista.jpg 
Views:	2005 
Size:	104.1 KB 
ID:	3783   Click image for larger version. 

Name:	swe-good.jpg 
Views:	1864 
Size:	49.5 KB 
ID:	3784  
    Attached Thumbnails Attached Images     
    Attached Thumbnails Attached Files
  7. INT and CCH Files Explained

    When using the Connectivity Kits, we hear a lot about intermediate (INT) files and structure cache (CCH) files, but the role that those files play in the Connectivity Kit world seems to not be completely understood.

    What is an INT file?
    INT files are text files that contain the driver name to be used to open a table, the table's connection information (server, database, etc) and identification (table name, schema, etc), and some special information (e.g. whether the table is ...

    Updated 13-Apr-2022 at 10:17 AM by Marcia Booth

    Tags: cli, marcia booth, sql
    Categories
    Uncategorized
  8. Activation and Deactivation: A suggested approach

    by , 28-Dec-2009 at 09:00 AM (Development Team Blog)
    The DataFlex activation and deactivation mechanism has a long history. It was built as part of the original object-oriented user interface and has gone through many changes. It had to be extended to support modal and non-modal objects. It was then expanded to work with data aware objects (DEOs). Later it was altered to support Windows controls. It should come as no surprise that the end result is that there are a lot of ways to make this work and even more ways to make this not work. Sooner or later ...

    Updated 1-Sep-2011 at 11:44 AM by Dennis Piccioni

    Categories
    Uncategorized
  9. Adjusting Server Settings prior to installing Visual DataFlex

    The default Windows settings constantly change and starting with Windows Server 2003 some settings are not configured to accommodate what is needed in a Visual DataFlex environment. Also, some components necessary for Visual DataFlex to fully run are not installed by default. So, before installing Visual DataFlex, you should review and configure your server.

    In order to install and successfully run, Visual DataFlex needs the following to be appropriately set:

    1. Internet
    ...

    Updated 8-Aug-2014 at 11:17 AM by Marcia Booth

    Categories
    Uncategorized
  10. The Case for Source Control

    Source Control has been discussed in our forums off and on for years and it appears that some developers are not convinced that using it will benefit them. If you are not currently using source control, you should seriously reconsider doing so. I hope this article clears up most questions you have.

    Source control is often also referred to as "version control" or "revision control". I prefer the term source control because it does so much more than simply tracking revisions, as I will ...
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	VaultHistoryBT4711.PNG 
Views:	2664 
Size:	16.7 KB 
ID:	3806   Click image for larger version. 

Name:	VaultHistoryBT4711DrillDown.PNG 
Views:	2696 
Size:	57.8 KB 
ID:	3807   Click image for larger version. 

Name:	VaultBT4711ChangesInBC.PNG 
Views:	9070 
Size:	92.3 KB 
ID:	3808  
  11. Source Control and Visual DataFlex 101: The Basics

    In The Case for Source Control, I told you why you should use source control. Now I will show you how to use source control with Visual DataFlex. This post will demonstrate the basics of source control from a single developer perspective. Source Control and Visual DataFlex 102: Multi-Developer Use moves on to using source control when multiple developers work on the same project. The purpose of this post is to allow you to start using source control in a fast and efficient manner. See Configuring Source Control for Visual DataFlex ...
  12. How to change the internet connection timeout

    When your Visual DataFlex application makes an external call to a webservice the main program waits for its completion. If the request does not return immediately several things can be the cause. Your connection to your ISP can slow, the webserver you try to reach is busy, can be difficult found etc. If you want your application to continue as soon as possible and know (and this is the unknown keyfactor) that particular call should not take more than a couple of milliseconds to complete you can ...
  13. ESQL: Fetching from Batch Statements

    When using the database Connectivity Kits, developers may choose to use embedded SQL (ESQL) in their applications to take advantage of the database server capabilities and set processing. In ESQL you can execute many different statements either one by one or in batches. So, how can batch statements be used in Visual DataFlex?

    What are Batch Statements
    A batch of SQL statements is a group of two or more SQL statements or a single SQL statement that has the same effect as a group ...
  14. The Case of the Ignore Case

    The Database Connectivity Kits used to add an uppercase (U_) column when tables were converted from DataFlex native databases to an SQL backend. That column was there just to fulfill the need of an uppercase index segment.

    However, starting with build 5.0.0.63 (find the latest builds available at ftp://ftp.dataaccess.com/pub/products/connectivity/ ), the Connectivity Kits were changed and by default they simply use the collating sequence defined for the database on the backend and ...
  15. How to Add a Chart to Your Visual DataFlex Web Application?

    What do you need to do when you want to enrich your web application with some charts? First of all it is important to find data that let itself nicely present in a chart but you probably have that else you won't be interested in reading this blog. Then you need to decide what kind of chart you would like to use. Do you want a pie, a bar or a line graph? Dealt with this it is time to find a good API, a good tool that you can use. There are many solutions available on the web. For this blog I used ...

    Updated 2-Dec-2013 at 02:28 AM by Vincent Oorsprong (Images enlarged)

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

Name:	TopNCustomers.jpg 
Views:	1783 
Size:	161.6 KB 
ID:	4100   Click image for larger version. 

Name:	TopNCustomers Part 1.jpg 
Views:	1475 
Size:	49.1 KB 
ID:	4101   Click image for larger version. 

Name:	Pie Chart.jpg 
Views:	1672 
Size:	103.5 KB 
ID:	4103  
    Attached Thumbnails Attached Images  
  16. Getting More Out of Your Browser Control

    Since the introduction of COM in Visual DataFlex, around Visual DataFlex version 5, there has been a example application that contains an ActiveX object that represents Microsoft's Internet Explorer. In the example, that loads a default web-page, you can enter another address, click on a hyper-link which loads a new page, go back or forward, all the usual operations you can do with Internet Explorer itself too. While this example is good you can do much more and this blog is informing you about ...

    Updated 2-Dec-2013 at 02:27 AM by Vincent Oorsprong (Images enlarged)

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

Name:	TipOfTheDay.jpg 
Views:	1520 
Size:	75.3 KB 
ID:	4170   Click image for larger version. 

Name:	Import COM library.jpg 
Views:	1641 
Size:	110.4 KB 
ID:	4171  
  17. Getting More Out of Your Browser Control - Part II

    In the first blog I told you how to connect to the HTML document object inside your Microsoft Internet Explorer browser object. How you can dynamically load a string holding a HTML document structure. In this blog I will extend this a bit.

    Let's go back to the Did You Know dialog in DataBase Explorer and look what extras we can learn from there.

    Context Menu
    If you bring up that dialog and you right click the browser control you will notice you cannot get to ...
  18. Create a New Universally Unique IDentifier (UUID)

    If you are in a need to have a unique ID in your application you might want to make use of a Universally Unique IDentifier (UUID). The term UUID is interchangeable with GUID (Globally Unique ID). A UUID is a string that contains five blocks of hexadecimal digits. The Windows API has functions for this and in this blog I show you how to create UUIDs in Visual DataFlex.

    An example of a valid UUID string is: 2CA263F1-5C94-11E0-84CC-002170FBAC5B. As you can see it consists of 8 hexadecimal ...
  19. Registration-Free COM [by Dan Levene]

    [B]Registration-Free COM[/B]

    I was privileged to deliver [URL="http://marketing.dataaccess.com/Synergy2011_Presentations/DeplyingRegFeeComCntrl_DL.pdf"]a presentation on this topic at the recent Synergy 2011 Conference in Orlando[/URL]. As a result of discussions that ensued from that presentation and the broad interest that seems to exist in this topic, I am also privileged to offer this guest blog.

    First, indulge me while I provide some background on the technology ...

    Updated 21-Jun-2011 at 01:55 PM by Stephen W. Meeley

    Tags: dan levene
    Categories
    Uncategorized
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	ManifestModifier2.jpg 
Views:	693 
Size:	58.7 KB 
ID:	4417   Click image for larger version. 

Name:	ManifestModifier1.jpg 
Views:	868 
Size:	71.7 KB 
ID:	4418  
  20. A Folder Selector With Initial Folder Setting

    This week two developers asked me about a folderbrowser/selector. Over the years several solutions have been created (fully) using the Windows API. But as far as I know they all do not have the ability to set the focus on a certain folder shown in the tree. And that is what the developers wanted to have. I said it is "simple" to make a folder selector yourself. This blog tells you how you can create one yourself using Visual DataFlex code and a bit Windows API code.

    The Dialog ...
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	2011-05-21_205030.jpg 
Views:	1781 
Size:	31.2 KB 
ID:	4354   Click image for larger version. 

Name:	2011-05-22_092811.jpg 
Views:	1825 
Size:	59.3 KB 
ID:	4355  
Page 1 of 2 12 LastLast