The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

    Mastodon

  • Twitter Updates

  • My Flickr Stream

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now20140424-VMware-Fusion-6.0.3.-no-reclaimable
    More Photos

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,860 other subscribers

Archive for the ‘InterBase’ Category

Next Entries »

InterBase/Firebird – query to show which fields in your database are not based on a domain

Posted by jpluimers on 2009/08/13

Our strategy is that in all of our InterBase and Firebird databases, the column definitions are based on domains.

But some of our databases do not have that for all columns (usually because we got involved later in the development cycle).

When you forget to define a column based on a domain, then both InterBase and Firebird will create a new system domain on the fly that starts with ‘RDB$’.
So if you forget, you get a new system domain for every column!

The below query will list those columns. Read the rest of this entry »

Posted in Database Development, Development, Firebird, InterBase | 4 Comments »

InterBase/FireBird – querying the system tables to get your actually used field/column types

Posted by jpluimers on 2009/08/13

Shortly, I’ll post a blog entry about find out which columns are not based on domains.
In order get the right definition for those domains, I needed a way to get that info from the DB, preferably in a SQL-statement (that saves you starting your application development environment).

The SQL-statement is based on my initial browsing of these documents:

If you find errors or omissions, please let me know.

So here it is:
Read the rest of this entry »

Posted in Database Development, Development, Firebird, InterBase | Leave a Comment »

Edited: Conferences, seminars and other public appearances « The Wiert Corner

Posted by jpluimers on 2009/05/15

I have edited the Conferences, seminars and other public appearances/ page and extended the list of conferences I have attended in the past including many sessions.

Topics covered in these sessions have been C#, Delphi, Databases, Linux, Kylix, debugging, Compact Framework, and much much more.

Let me know which sessions you’d like to see online first.

The list is far from complete, but it is another step into getting the list more accurate.

–jeroen

Posted in .NET, C#, C# 2.0, Component Development, Conferences, Database Development, Delphi, Designer Development, Development, Event, Firebird, InterBase, Package Development, Software Development, SQL Server, Visual Studio and tools, XML, XML/XSD | Leave a Comment »

Colleauges speak @ InterBase PowerDay’s in The Netherlands and Germany

Posted by jpluimers on 2009/04/22

InterBase PowerDay '09 logoTomorrow, the 23rd of April, my Dutch and German InterBase colleauges from better office will be delivering the InterBase PowerDay inAmersfoort.

Speaking are Daniel Magin and Gwan Tan, attending are both regular InterBase developers and InterBase VARs.
The PowerDay costs EUR 124 excluding VAT to attend, and has 4 sessions that roughly covering these areas:

  • What’s new in InterBase 2009
  • InterBase as a vault
  • Advanced InterBase
  • Tools to maintain InterBase

The event is organized together with Barnsten, which are the representatives of CodeGear in The Netherlands.

A similar event is organized in Germany on the 6th of May in Frankfurt/Offenbach. That event is organized by better office Germany and CodeGear Germany. 

better office Germany is InterBase master reseller, and better office benelux (where I work) has some very knowledgeable InterBase people too.

Posted in Database Development, Development, Event, InterBase, PowerDay | Leave a Comment »

Speaking @ DelphiLive ’09, May 13-16, San Jose

Posted by jpluimers on 2009/04/21

I’ll be speaking during DelphiLive ’09 that is held from May 13-16 in San Jose (CA, USA, not any of the other San Jose cities).

This is going to be a top event with really knowledgeable Delphi speakers from all over the world.
Besides the 2 sessions that I’m doing, I’ll be hanging around as are the other speakers.

So feel free to approach us, and learn from the things we learned. Or teach us something new: all of us are eager to learn as well as teach!

The downloads are now available.

Posted in Conferences, Database Development, Delphi, Development, Event, InterBase, Software Development | Tagged: , , | Leave a Comment »

Next Entries »