The File Key Access DLL enables you to read and write records via a key of your choice.
E.g. if you want to save the Beatles song “When I'm Sixty-Four” with its publishing dates, etc. you code it as follows:
key="Beatles"
title ="When I am Sixty-Four"
composer="Paul McCartney"
album="Sgt. Pepper's Lonely Hearts Club Band"
released=1967
record=title";"composer";"album";"released
writekey(file,key,record)
record=readkey(file,key)
PARSE VALUE record WITH title';'composer';'album';'released
The alternative usage of databases as mySQL was far too slow for this simple approach.
To test the DLL you can run MusicList.rex of the zip file. It imports 5000 records containing Artist-Song with the key: Artist.
If someone is interested in a more detailed description of all available functions, I will create a documentation. |