2008
			2007
			2006
			2005
			2004
			2003

			2008
			2007
			2006
			2005
			2004
			2003

			2008
			2007
			2006
			2005
			2004
			2003
			2002

			2006
			2005
			2004

			2008
			2007
			2006
			2005
			2004

			2007
			2006
			2005
			2004
			2003

			2004
			2003
			2002
			2001
			2000
			1998
			1997
			1996
			1993

			2003
			2002

			2003
			2001

			2003
			2002
			2001

			2003
			2001

			Visual FoxPro 2001
			Visual FoxPro 2000
			Visual Studio 2000

			West Wind 2002
			Double Impact 2001
			FoxTeach 2001
			Jam sessions
			Technical Guidelines

			About
			Acronyms
			Contact information
			Troubleshooting
			Time zones
			Web Service
			Terms & Conditions
			Copyright

Microsoft Czech Republic and DAQUAS organize a conference for developers who create applications using Microsoft Visual FoxPro. "Visual FoxPro DevCon, Praha 2006" takes place in Prague, Czech Republic in September 2006. Visual FoxPro DevCon, Praha 2006 comprises of at least 30 sessions out of which more than 10 are presented in English by worldwide respected FoxPro experts. This year is the 9th year of the event.

Date:
Location:

• Monday, September 11
• Tuesday, September 12
• Acknowledgements
• Picture archive

Monday, September 11

by Jan Vít and Jan Král

Hello again! Now we are in Prague or Praha, as it is known over here, in the Czech Republic. We will report about the 9th Praha FoxPro DevCon. As in the past we will start our reporting with a very short reference to the place, where we are now and where this event will take place.

Well, you should see the VFP Videos specially manu(ally)factured by Kevin Ragsdale. Well done! And you will have a chance to help to promote Visual FoxPro as well. Just open the site and read on!

And we have another slogan for Visual FoxPro: Besides "Fox Rocks!" we now have
       VFP Connects!
Yag then showed, what Visual FoxPro is "connecting" and how it does it:

VFP Connects! You to your data!

The report generator has been completely renewed in Visual FoxPro 9. But this has been not the final stage of the evolution of this vital item of Visual FoxPro. Enhancements of the reporting are on the way. The runtime now is also decorator and visitor. You can preprocess a report to remove things that shouldn't show up - for instance, you can swap in a report at load time, create links for HTML, but prevent printing of the content (if this combination seems to be advisable), the properties of the report can now be handled dynamically at runtime, objects of the report can be rotated and quite a few more things of this type are likely to come to "connect the user to his/her data".

VFP Connects! You to SQL Server!

Visual FoxPro has its own strong database system, but SQL servers are around and are doing a job. So many people like them and most likely they will stay forever. So the Visual FoxPro team made a wise decision according one of the most basic rules of the successful: "If you can't fight them (these SQLs), join them (well that should read: integrate them). So the SQL Upsizing Wizard got a major refresh. Now it is a great tool to conquer the (data) world. Yag presented a demo, which had many of these quite convincing features. And he clearly demonstrated, how "visual" (= optically recognizable) a Visual Wizard can be.

Ease of use is one of the major features. So the SQL Upsizing Wizard can be started with default settings. Re-running it allows optimizing and customizing as needed. And for the speed fans: There have been improvements in the speed when upsizing to Yukon! Doug Hennig tested one table of over 300,000 records that used to take 2 hours. Now the upsizing takes 11 minutes!

VFP Connects! Us to Each Other!

Yag, in his career with Microsoft, is active in two fields: He is successfully overseeing the phenomenal implementation of data tools into Visual Studio and also is working actively with the developer communities.

Then CodePlex comes onto the stage, which is Microsoft's community development web site. CodePlex is a community platform, which allows developers to create new projects on topics they are interested in, in order to share their ideas and questions with fellow developers around the world. CodePlex allows developers to join others who have already started their projects in CodePlex and use whatever they learned from CodePlex projects and provide feedback.

Under these premises Yag actively promotes VFPX and VFPY, which is kind of the Visual FoxPro section within CodePlex. It is a Visual FoxPro Community effort to create open source add-ons for Visual FoxPro 9.0. In the keynote, Yag showed some enhancements from VFPX. Within VFPX code, classes, and libraries made available to the Visual FoxPro community. Presently these Projects are actively in development

• ClassBrowserX
• Code Analyst
• ctl32 Statusbar
• GDIPlusX
• JustBehave
• New Property and Method Replacement
• OOP Menu Project

VFP Connects! You to Visual Studio and .NET!

The NET4COM library is a collection of COM classes that wrap a subset of the .NET Framework 2.0. The .NET Framework is a rich collection of namespaces and API that provides a comprehensive set of functionality that developers can use to build applications that run on the .NET platform. While Visual FoxPro does have a rich library of API, there are some features that either do not exist in the Visual FoxPro libraries or are harder to use than in the Framework. NET4COM brings together a small subset of the .NET Framework - a collection of commonly used API that brings to Visual FoxPro functionality that does not exist.

The MY library for Visual FoxPro is similar to NET4COM. MY is implemented natively for Visual FoxPro and, similar to NET4COM, exposes commonly used functionality in a hierarchy that is easy to discover and navigate. The Sedna CTP Setup will install the MY library and related files in the "MY" folder under the selected install destination.

MY was introduced with Visual Basic DotNet. The MY namespace is a native Visual FoxPro class library that contains similar wrappers for SYS() functions, Windows API and Windows Script Host properties and methods. It allows statements like

       MY.Computer.FileSystem.SpecialFolder.MyDocuments

NET4COM and MY are included in the Microsoft Visual FoxPro Sedna - Community Technology Preview (CTP) June 2006

Data Designer Extensibility (DDEX) data object types represent data source objects from an external data source. They are offered by DDEX Providers and rendered in the Visual Studio IDE, which is defined in the data object support schema file. As Yag showed, DDEX integration allows Visual Studio developers to naturally access Visual FoxPro data.

Yag also showed us a new InteropForms toolkit coming from the Visual Basic team. It allows us to create a DLL with forms written in VB and access them like any other form in Visual FoxPro. Yag created a form using Visual FoxPro data (thru DDEX) in Visual Basic and saved it as a DLL, calling it from Visual FoxPro and mixing the access as needed.

VFP Connects! Us to Each Other!

There are a great variety of Sites on the web, which connects the community members, like

• VFP DevCenter
• MSDN Forums
• Universal Thread
• Foxite
• German FoxPro Users Group
• Yag's Blog

Many of us have been working with Reports in previous versions of Visual FoxPro and many of us were not satisfied. Nowadays we have here Visual FoxPro 9.0 and Martins session, which will show us some good features.

Martin started with a report designer. He mentioned some features in this area such as:

• Safe mod (every single field has one safe mod). This means that programmer can forbid for example writing in the particular filed
• Better UI (user interface which is much more flexible)
• New forms

Of course Martin did not forget to show us other very interesting and for many of us new things in report designer. For instance, he demonstrated us to work with system variable _reportbuilder. He did not any examples, instead he made a big effort to explain us how the report designer works and how the builder communicates with Report Designer.

• Report Designer evaluate _reportbuilder variable and call the builder
• Builder react on Report Designer and he can modify FRX and send it back

Another thing that he spoke about was ReportBuilder application (ReportBuilder.app), which is communicating with Report Designer. It can replace native dialogs (tooltips, review and so on). He showed us many examples such as processing events by ReportBuilder application or copying styles.

At the end he managed to mention something about running the reports and ReportListener (basic class in Visual FoxPro) and we couldn't forget of Report output application which maps codes numbers on instance of ReportListeners and so on.

The session was exhausting; nevertheless there were a lot of interesting information and good tips so we are looking forward to the second part (Reports in Visual FoxPro 9.0 part 2).

Visual FoxPro and Barcodes time
Jan Dudek

Barcodes had undoubtedly found its place in today's business. Even though their presence on various products never surprises anyone today, it has not always been this way.

The patent of this technology was made in 1949, but it took almost another three decades until the first barcode reader was actually produced in 1974 by a company named NCR. The first product whose barcode was actually read by such devices was Wrigley's Juicy Fruit packet in supermarket called MARSH and it can still be seen in the Smithonian Institution's National Museum of American History.

Just as Jan was examining all the various barcode formats, he also showed a few Visual FoxPro examples, which can be used for their generation. In order to have the attendees acquire a good understanding of the logic behind the barcodes, Jan provided quite in-depth information.

In the end Jan also mentioned the 2D codes, first introduced in 1988 and then spent some time talking about hardware devices usually present at the shop registers, such as the receipt printers, barcode readers, customer displays and cash drawers and how they are actually serviced from software applications.

This was the first of the two Hands-on Labs (aka HOL) presented on this year's DevCon. Since this was the first time the organizers of the conference decided to introduce this kind of a seminar, they were themselves curious as to whether this seminar will actually get any attendees at all.

Organizers and speakers of both HOL were likewise surprised that both of the HOL sessions were filled to the last place shortly after the special registration for them was started.

This HOL in particular was targeted toward Visual FoxPro beginners and in short showed everything necessary to create a functional Visual FoxPro project with a simple form in it. The form was fairly simple. It used the NorthWind sample database and consisted of a grid and a few textboxes. Just enough to get everyone interested in the particular project and Visual FoxPro itself, of course.

At the end of the session Jan also pointed to some information sources a Visual FoxPro beginner should look at to get more information about Visual FoxPro. Moreover, he also created a document, which exactly copies everything that was mentioned in the session and will be available in the conference download together with the session source code. With help of such a document everyone should be able to re-create the project at home by just themselves. This happened to create a little smile on face of everybody present.

The second HOL was discussing the use of the SQL server from within Visual FoxPro. This HOL was presented by Igor Vít, a well recognized member of the Czech FoxPro community and the main person behind the organization of the entire conference. Unfortunately, none of the reporters were present at that particular session, but our spies reported with a great enthusiasm that he handled the session so well and is such an excellent speaker that he should try to have more sessions next year. Even if that would actually incur the cost of having less time to organize the conference, which, under his guidance, is always a wonderful experience!

As last year, we followed Martin's session. This year his topic was forms. First of all we had to realize that within a single session Martin only presented some carefully selected topics of his vast knowledge of this topic.

He started with definitions of forms. Then he continued with how to create a form using command create form or how to run a form using command do form. Of course, Martin mentioned every single parameter of these commands.

Martin tried to point out differences between single form and formset and he mentioned some advantages and disadvantages as well.

Martin extended the session to classes and events as far as these topics are related to forms. He put a big emphasis to explain how an event evolves step by step. He helped us how to fix this problem using Visual FoxPro help, topic "Event sequence in Visual FoxPro". There you can find the events how they go systematically after each other. In this session Martin also discussed using SET EVENTTRACKING command for tracking events while your application is running.

The session tried to explain to us how we can effectively close the form, for example using command release window or clear windows, but he pointed out that sometimes it is not required to quit the form.

If you wanted to know something about data environment do not worry. Martin told us how the environment works. What is a cursor and how can we work with it, and many other things.

He spoke also about problems with modal and modeless form. For example, a frequent mistake is to run modeless forms from modal forms.

At the end, he showed us another tips and tricks such as running another form from exe/app or sharing data environment by more forms.

The session was full of more great tips and tricks, which are not mentioned here, but the good thing was that the session was determined not only for professionals but even for beginners. Every single programmer could get some good experience about forms and have fun at the same time.

This session was basically filled with many rules of thumb on how to design a scalable application with help of objects.

The developer should first of all get a fine understanding of all the processes the business of the customers uses. The information gathered this way should then be used to create objects.

The classical school of thought consists of creating objects based on all the nouns collected from the text describing the future application. This text is generally referred to as the "Use Case". After determining the objects' names, the approach then recommends using the verbs in the text to identify methods and the adjectives are usually used as objects' attributes. According to Craig, this is not the right way. All objects are first of all to be characterized by their behavior which is why we should concentrate on the verbs in the "Use Case" before attempting to actually identify the object names itself.

In his session Craig explained many terms used in object oriented development, such as encapsulation, polymorphism. He also explained many of the, usually, indigestible definitions in the object oriented world. To make sure all attendees understood all the concepts, he often used several real world examples. For example to explain the "behavior" of an object, he used a comparison between mouse and his presenter he uses for switching slides. They are both used for different purposes and therefore they need to be different objects. Keeping that in mind, we should always subclass when there is a difference in behavior, not when we just need one more property to an already existing object.

Make sure to divide everything to as many objects as logically and technically possible. Do not overload them with things they should not care about. To handle more complicated tasks objects should communicate with one another by means of massages. Your only job should be to make them understand each other, to make them you the same "language". Craig compared this to attempting to write a Visual FoxPro code to look like C# code. Remember, C# uses the semicolon to end the line whereas Visual FoxPro uses it to continue the line!

Finally, always remember: "Objects should do all the things in the application, yet they are lazy and they should not depend on other objects, yet they need to collaborate..."

If you are wondering how to make sense out of the last paragraph, let me help you a bit. The solution should be to divide large tasks into multiple objects and make the collaboration work using the factory design pattern to maintain the loose coupling of all the objects.

As the last attendees were coming to the conference room, those already in there kept themselves occupied by trying to figure out what this session was really going to be about.

When Norbert started his session, everyone immediately began to understand what the name of the session really stood for - creating a server with the help of Visual FoxPro.

First of all, Norbert explained the basics of the TCP/IP protocol and made sure everyone was familiar with all the networking terminology he was going to use throughout his session.

The whole solution, as presented by numerous examples, comprised of utilizing the WinSock component. This is an OCX component installed together with Visual Studio version 6 and provides the means to Visual FoxPro developers to actually use TCP/IP calls directly in their applications. Just by knowing the IP address of the target computer it allows the application to easily send any string from one computer to another over TCP/IP.

The rest of the examples presented showed an implementation of a powerful way to control the server from the client. The client sent a command string over the wire (wireless also, of course) to the server and it just executed the received command in a simple EXECSCRIPT(), in order for attendees to actually see that something had happened.

Yet powerful, this approach also introduces a big security risk. A Risk too high actually, that it prevents the shown implementation to be directly used in a real world application. This, of course, is something Norbert pointed out and stressed that this was actually only for demo purposes and that some security measures should be taken into account before using such a concept in the open of world wi(l)de web.

IntelliSense is one of the most powerful tool in Visual FoxPro. When the IntelliSense first appeared in Visual FoxPro 7.0 it was revolution. Nowadays it is indispensable and very important tool for developing. Developing applications became much easier and faster then before. But how about having IntelliSense in an application? Is this possible?

In his session Doug showed that "Adding IntelliSense to Your Application" can be made to become a functional and efficient part of any application.

The main topic of this session was to show you how to incorporate IntelliSense into your runtime. This are the main advantages to do so.

• Your customer will be able to change the behavior of the application.
• It is scriptable and autocorrect as well.

There are also problems. Doug mentioned for example that we could not input foxcode database straight into the project, because this does not work. The same problem is with foxcode.prg. We cannot put it into our project as well. If we did, there will be an error (something like Couldn't find the foxcode.prg). We should create our own customize IntelliSense using clone of foxcode.prg with some changes. He explained us that IntelliSense in runtime is supported in prg or memo window, but not supported in EditBox. After all we don't have much control in prg window.

Have you ever dreamt about IntelliSense with your own favorite methods and properties? No problem. Doug showed us how to reach this. Using FFIBuilder these thing come true. This builder adds two records to your IntelliSense table.

• First one record for HandleFFI script record.
• Second one record for namespace.

Updating was no problem. To update foxcode.exe just add FFI.vcx and FFI.dbf into the project, but he warned us not to add the images. Images must be kept in the main application.

This session was something like an information tornado. There were many tips, which can actually make your developer life much easier. It is very hard to describe feeling from this session. I can only quote Doug Hennig: "Developers cannot live without IntelliSense".

Dim db As New Northwind(...)
Dim contacts = _  
    From c in db.Customers _
    Where c.City = "London"
    Select c.Name, c.Phone

Dim contacts As New XElement("contacts", _
    From c in customers _ 
    Where c.Country = "USA" _
    Select New XElement("contact", _
        new XElement("name", c.CompanyName), _
        new XElement("phone", c.Phone) _
    )
)

If you are eager to see this in action, feel free to download a CTP from Microsoft web and test it for yourselves. Also be sure to provide feedback, it is still a work-in-progress and by providing your feedback you could influence its final shape.

Communication Visual FoxPro and SQL Server
Ivan Arnold

Every year we usually have session focused on SQL Server and Visual FoxPro. Neither this year was different. Ivan Arnold decided to tell us something about SQL Server in general point of view, but also about communicating between SQL Server and Visual FoxPro.

He started with introduction of SQL 2000 MSDE, which is actually high-performance SQL machine available in Visual FoxPro or Office installation. He also told us that this machine is free, but it does not have administrator tools.

Then Ivan focused on Microsoft SQL Server 2005 Express, which is also high-performance machine without any connection restriction, but he pointed out that it needs .NET framework 2.0 to work. Ivan also outlined the restrictions of this SQL Server.

Ivan also introduced SQL Manager 2005 to the audience, which was developed in .NET. Besides being the necessary management tool for this SQL Server, it also provides an excellent query builder.

ODBC drivers are very important for connection between Visual FoxPro and SQL Server. Ivan knew that and he spoke a little bit about these drivers. He mentioned SQL 2000 driver and new SQL Native client driver as well. After that, we used these drivers to connect to the database. We also used SQL profiler, which can monitor all activities passing through to the SQL Server. It is a trace program, which is able to remember all executed commands.

If you were afraid that this session gives you only basic information about SQL Server, you were terribly wrong. The session was perfectly interlaced with many and many great examples how to do it effectively and without mistakes and if you were lucky and smart enough you could win a t-shirt.

Mining for Gold in XSource
Doug Hennig

This is one of the sessions which after you leave the room makes you think: "Wow! Do I really have all of these tools and other classes already installed on my machine?" Yes! This session went through everything the Visual FoxPro developers get right out of the box in the XSource directory where Visual FoxPro gets installed.

The examples showed ranged from displaying video files to show a flying paper from one folder to another to symbolize a file being copied to examples a bit more complex such as a toolkit for creating builders.

Ever needed to get the list of the SQL server instances installed? To show in a drop down list, perhaps? There is an easy way. Just use SQLDatabaseMgmt to get the collection containing these server names. This, however, is not the only functionality of SQLDatabaseMgmt. It can also get you a lot of information about databases and tables contained in the SQL server.

If you need a progress bar, you can find one in there as well and if you like those messages saying something like "4 second remaining", which change the number to various values every second, you can use a trick of substituting this value with the result of a RAND() function. As you might have guessed, it works just as nice as other applications trying to come up with real values.

Another example showed how to simply store the position and size of a form. Ever changed a resolution of your display (laptop in a dock with separate monitor perhaps) and your windows found their place outside of your screen? Yes? Then this is also something to look into XSource.

Tips & Tricks
Pavel Celba

The conference is not only studying news, but it is about friendship, good atmosphere and fun as well. If you can put these things together, you can have an unforgettable session. As in the last years every participant of conference was looking forward to Pavel Celba's session.

As a warming up Pavel started with a report preview and continued with SQL Select commands. He was speaking about Escape clause or how to use Set fields command in a different way.

If you didn't see Doug Henning's session (Adding IntelliSense to Your Applications) you had a good chance to learn something about IntelliSense. Pavel showed us some good tips and tricks with IntelliSense such as how to add your own commands into it or where IntelliSense definition is stored (FoxCode.dbf).

Pavel mixed useful knowledge with a lot of humor. For example he showed us some tips from the internet. The best one was definitely the process of creating an empty zip file. Very helpful, don't you think? But this is not everything, if you were able to answer his tricky questions for example:
      -> How do we get a consecutive number of the last day of a month.
If you answered correctly, then you could win a t-shirt or a cap with the Daquas logo. But Pavel soon run out of t-shirts. So he changed to biscuits as a reward for the first correct answer. It seems that Visual FoxPro programmers are capable to handle almost every kind of situation :-)).

Other specialties were problems with Visual FoxPro. He advised us what to do when the FoxPro is running incorrectly. An important source of failure could be a faulty resource file.

After that he showed us how to shutdown Visual FoxPro 9.0 It took a while because Pavel had brought with him a really slow laptop. He outlined how he carefully selected the slowest one he could get, because he wanted to show us how Visual FoxPro 9.0 is brilliant program that is even able to run on such slow computer. Thank you, Pavel.

At the end Pavel asked us what is our opinion of what is missing in Visual FoxPro. People usual answer is that Unicode support or encryption are missing.

Finally he told us where we can find inspirations for our development (internet web pages, magazines, e-mail conferences and so on). Nevertheless the session didn't give you a chance to get bored or think about any thing else but listing. It was instructive and entertaining as well.

Cool Uses for ReportListeners
Doug Hennig

Since Visual FoxPro 9 shipped out, Visual FoxPro developers have had a powerful feature at their fingertips. I am talking about the new reporting engine and especially the report listener class which it uses to generate various report outputs.

There are a few report listeners shipping together with Visual FoxPro. Apart from generating a standard report for printing, they can also create an HTML or XML output. By creating your own you can also allow for other output formats or just simply tweak the existing ones.

This session aimed at the latter. Doug showed how to add various new features to report generation or report previews. Enabling hyperlinks in the report is one of such features. By clicking a link on the report, the user can trigger opening a new web page, displaying another report (also called drilldown report) or it can simply open another Visual FoxPro form.

If you are interested in having a table of contents for your HTML report, be sure to take a look at Fabio Vazquez's NavPaneListener, which can generate a thumbnail picture for every report page.

The report can also be rendered into a cursor. This might be useful in cases when you need to get as many information about the report generated as possible. Moreover the report can then become searchable and with a few GDI tricks also "alive" so that it can be aware of user clicking it.

Questions and Answers

Every single year our conference has different topics, but only one is still the same: Questions and Answers.

People are not coming to conferences only for attending sessions and learning something more or just to get materials, they also hope to find solutions for their imminent problems and this is something this session usually helps them with.

There were a lot of questions. Some of them were interesting more some less, some were even funny.

Developers asked for example if there will be support for Unicode in Visual FoxPro. It didn't take a long time and Alan Griver answered that they are not planning any future support of Unicode in Visual FoxPro.

Another question was if there will be some kind of Visual FoxPro Express edition. Unexpectedly, Alan asked for a microphone and said: "It doesn't make any sense. If we want an express version we must put something out, but you probably wouldn't want this. "

These were not the only questions Alan answered. Another one went like this: "Are there any difficulties installing service pack 1 for Visual FoxPro 9.0?" The answer was, yes, you guessed it, a simple "NO".

There were also other interesting questions. Some asked about whether Visual FoxPro will be integrated into the Visual Studio or if there is going to be a Visual FoxPro 11. The first one came back with a simple "NO" and the second one did not get an answer at all. It is just too early for that.

Speakers weren't able to answer all questions, but don't worry this is not the last DevCon. Good luck with development and see you again on Question and Answers.