Een tip over hoe omgegaan kan worden met Multiple Recordsets als return value van een Select of stored procedur (met dank aan Geoff Schallr).   lees meer...

This is the first paper in a series of four tutorials, which seek to guide the reader into the world of SQL from DBF. The four papers are:
A Combined SQL/DBF Server Using Dual Inheritance Coding in VO for the SQL Environment Migrating from DBF to SQL Employing the Sovo SQL Classes and Tools This paper describes the process of Dual Inheritance and how it was used to develop a combined SQL and DBF solution    lees meer...

DBF is still a universal data source format and even if the choices widen or vary in the future, there will be a great deal of legacy data of this format to support for many years to come. The DBF format still holds popularity ultimately because it’s cheap, easy to use and easy to repair. It is readily converted to any other format, especially to XML, where direct on-disk string manipulation makes DBF a superior internet format. But all this format flexibility appears to come at a cost. The potential for data corruption (and more particularly index corruption) seems to be greater than the auto-integrity providing environments like Oracle and SQL.   lees meer...

For those who have been following various VO version releases, it is quite plain that the GUI classes are finally coming of age. Beset with problems in VO 1 days, the GUI classes gave rise to the hugely successful ClassMate suite and ReportPro but converting to these 3rd party products is a serious commitment and not for the beginner. So most of us are “trapped” into using the native VO GUI classes… but are they all that bad?   lees meer...