Today I got a Dbase table that was odd: When read using tdbf, some string field contained NULL in one record, but an empty string in another record. I was unable to produce such a file with Personal Dbase 8 as well as our internal tool DBaseTableViewer (which despite its name can also change tables, … Continue reading About DBase string fields
Category: dBase
Specifying a date in dbase
One of the recurring confusions with databases is how to specify a date value in SQL statements. In the case of dbase, it's not just SQL but also the builtin language. There you specify a date as ctod("<date>") where <date> is the date in the format currently used for output. e.g. if you are using … Continue reading Specifying a date in dbase
dBASE: When an empty string field does not match “”
Filtering the current table on a field in dBASE is done like this: set filter to [condition] So if you want all records where ANUMBER > 10 you just type this command: set filter to ANUMBER > 10 It's as easy as this... unless your field ANAME is a character field and you want all … Continue reading dBASE: When an empty string field does not match “”
Using dBase
I recently needed to do some table manipulation with Visual dBase. Not being an expert with this program (I usually write tools for that purpose in Delphi using the BDE or tdbf), I had to look up quite a few commands. Here are the links that proved useful: Beginners’ Corner — Part 2: The dBASE … Continue reading Using dBase