[Mybusinessbasic-devel] RE: [mybb] Keyed Database System
Status: Alpha
Brought to you by:
mikecurry1974
Menu
▾
▴
[Mybusinessbasic-devel] RE: [mybb] Keyed Database System
|
From: Michael S. L. <mi...@ha...> - 2003-12-19 18:10:53
|
OpenBasic (from MAI) added stuff as well for multi-keyed files. Since the fields were named you could just specify the field name to read instead of having to use asterisks to ignore the fields you don't want. For instance, if you were only interested in the field named "PARTNUM" you could use the following: 9901 IOLIST #PARTNUM=PARTNUMBER$ This would read in the PARTNUM field and ignore the rest of the record. If you used a variable name that matches the field name you could use this alternate format: 9901 IOLIST #PARTNUM$ And it will read the PARTNUM field into the PARTNUM$ variable. -- Michael St. Laurent Hartwell Corporation -----Original Message----- From: John Spikowski [mailto:Jo...@vi...] Sent: Friday, December 19, 2003 9:59 AM To: my...@ya... Subject: RE: [mybb] Keyed Database System The most difficult part is going to be the IOLIST functionality. PVX has extended the functionality of IOL's over the years. How many 'C' programmers are currently on the list ? -----Original Message----- From: Mike [mailto:mik...@ro...] Sent: Friday, December 19, 2003 9:50 AM To: my...@ya... Subject: RE: [mybb] Keyed Database System Yes it does, not bad. We should start some planning and get everyone something to do... any suggestions anyone? _____ From: Michael St. Laurent [mailto:ro...@li...] Sent: Friday, December 19, 2003 12:50 PM To: 'my...@ya...' Subject: RE: [mybb] Keyed Database System Wow, that seems like exactly what we're looking for, doesn't it? -----Original Message----- From: Mike [mailto:mik...@ro...] Sent: Friday, December 19, 2003 5:55 AM To: my...@ya... Cc: myb...@li... Subject: [mybb] Keyed Database System Check this out and let me know what you think, Theodore brought this to my attention... we could use this for the normal directives... (Direct/Keyed/etc) As for SQL I think we should add new commands. http://mission.base.com/peter/source/ <http://mission.base.com/peter/source/> PBL - The Program Base Library PBL is a GPL C library of functions that can be used in a C or C++ project. PBL is highly portable and compiles warning free on Linux gcc, Windows Cygwin gcc and Windows Microsoft Visual C++, V 6.0. The code of the PBL library includes: PBL BASE - license GPL/LGPL, some base functions, see pbl_* functions, PBL HASH - license GPL/LGPL, an open source memory hash table implementation, see pblHt* functions, Features: * random access lookups * sequential access * regression test frame * LGPL license PBL KEYFILE - license GPL/LGPL, an open source key file implementation, see pblKf* functions, Features: * ultra fast B* tree implementation for random lookups * transaction handling * sequential access methods * embedable small footprint, < 35 Kb * arbitrary size files, up to 4 Terrabytes * arbitrary number of records per file, up to 2 ^^ 48 records * duplicate keys * advanced key compression for minimal size B trees * keylength up to 255 bytes * datalength up to 2 Gigabytes per record * key files are binary compatible between arbitrary platforms * regression test frame * LGPL license PBL ISAM - license GPL/LGPL, an open source ISAM file implementation, see pblIsam* functions Features: * ultra fast B* tree implementation for random lookups * transaction handling * sequential access methods * embedable small footprint, < 75 Kb * arbitrary size files, up to 4 Terrabytes * arbitrary number of records per file, up to 2 ^^ 48 records * duplicate keys and unique keys * advanced key compression for minimal size index files * keylength up to 255 bytes per index * keylength up to 1024 bytes per record * datalength up to 2 Gigabytes per record * ISAM files are binary compatible between arbitrary platforms * regression test frame * LGPL license To unsubscribe from this group, send an email to: myb...@ya... _____ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/mybb/ <http://groups.yahoo.com/group/mybb/> * To unsubscribe from this group, send an email to: myb...@ya... <mailto:myb...@ya...?subject=Unsubscribe> * Your use of Yahoo! Groups is subject to the Yahoo! <http://docs.yahoo.com/info/terms/> Terms of Service. To unsubscribe from this group, send an email to: myb...@ya... _____ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/mybb/ <http://groups.yahoo.com/group/mybb/> * To unsubscribe from this group, send an email to: myb...@ya... <mailto:myb...@ya...?subject=Unsubscribe> * Your use of Yahoo! Groups is subject to the Yahoo! <http://docs.yahoo.com/info/terms/> Terms of Service. To unsubscribe from this group, send an email to: myb...@ya... _____ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/mybb/ <http://groups.yahoo.com/group/mybb/> * To unsubscribe from this group, send an email to: myb...@ya... <mailto:myb...@ya...?subject=Unsubscribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . To unsubscribe from this group, send an email to: myb...@ya... _____ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/mybb/ <http://groups.yahoo.com/group/mybb/> * To unsubscribe from this group, send an email to: myb...@ya... <mailto:myb...@ya...?subject=Unsubscribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . |
