Intelligentes Datenbankdesign

[Prototypjack]

Achja, Entschuldigung.
Hier mal der Aufruf beim initialen Füllen aller Boxen:

Delphi-Quellcode:

      lResults.Query('SELECT "songid", "filename", "artist", "title", "a' +
        'lbum", "tracknum", "year", "genre", "rating", "playtime", "filesize"' +
        ', "lyrics", "format", "vbr", "bitrate", "lastplayed", "timesplayed" ' +
        'FROM "music"');

Und hier die Grundstruktur (SQLite):
CREATE TABLE "music" ("songid" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "format" varchar(10), "vbr" number(1), "filename" varchar(255), "artist" varchar(255), "title" varchar(255), "album" varchar(255), "tracknum" varchar(10), "year" number(4), "genre" varchar(255), "rating" number(1), "bitrate" integer, "lastplayed" timestamp, "notes" varchar(255), "timesplayed" integer, "timeadded" timestamp, "filesize" integer, "playtime" integer, "lyrics" memo ) Gruß,
Max