Neobook db 2.3d
Quote from Simon Lundin on December 7, 2021, 10:17 pmHi, im trying to get every separate record Fields in separate variables
dbfRecordToVar "Data.dbf" "[MyData]" , in this example I get all the fields but in one long file.
dbfFieldToVar "Data" "Audio" "[Audio2]" "", in this example i get separate fields but all records .
Cant find out o get every separate record Fields in separate variables from the db file.
best regards Simon
Hi, im trying to get every separate record Fields in separate variables
dbfRecordToVar "Data.dbf" "[MyData]" , in this example I get all the fields but in one long file.
dbfFieldToVar "Data" "Audio" "[Audio2]" "", in this example i get separate fields but all records .
Cant find out o get every separate record Fields in separate variables from the db file.
best regards Simon
Quote from Gaev on December 8, 2021, 2:36 am@simon-lundin
Welcome to the Forum.
neobookDB is a plugin for the dBase III database, which is very old (circa 1984), and which is no longer supported.
You can still use it, but note that if something goes wrong in the future, you are :-(( :-((
neoDBPro, which is the plugin for MS Access might be a more suitable plugin for database applications ... having said that ...
dbfRecordToVar "Data.dbf" "[MyData]" , in this example I get all the fields but in one long file.
... by 'all the fields but in one long file' is the comma separated list of values of each field for the 'current record' ... in order to get the value of each field, you have to do a StrParse ... after that, each item in the requested arrayed variable can be individually accessed.
get every separate record Fields in separate variables from the db file
For this, you have to cycle through every record (inside a Loop/EndLoop code block); for each iteration of the Loop/EndLoop, you have to do the dbfRecordToVar command, followed by the parse of the result.
Just note that if you have 1,000 records with 15 fields, you will end up with 15,000 variables.
If you need help with performing any of the required steps, ask here; just let us know if you wish to continue using neobookDB or the neoDBPro plugin.
Welcome to the Forum.
neobookDB is a plugin for the dBase III database, which is very old (circa 1984), and which is no longer supported.
You can still use it, but note that if something goes wrong in the future, you are :-(( :-((
neoDBPro, which is the plugin for MS Access might be a more suitable plugin for database applications ... having said that ...
dbfRecordToVar "Data.dbf" "[MyData]" , in this example I get all the fields but in one long file.
... by 'all the fields but in one long file' is the comma separated list of values of each field for the 'current record' ... in order to get the value of each field, you have to do a StrParse ... after that, each item in the requested arrayed variable can be individually accessed.
get every separate record Fields in separate variables from the db file
For this, you have to cycle through every record (inside a Loop/EndLoop code block); for each iteration of the Loop/EndLoop, you have to do the dbfRecordToVar command, followed by the parse of the result.
Just note that if you have 1,000 records with 15 fields, you will end up with 15,000 variables.
If you need help with performing any of the required steps, ask here; just let us know if you wish to continue using neobookDB or the neoDBPro plugin.
Quote from Simon Lundin on December 8, 2021, 9:15 pmI did not know that neobookDB was that old. I will test the new one and its features. I saw that it was a good manual as well. Thanks for the detailed answer, I will return if I cant solve my problem. :)
I did not know that neobookDB was that old. I will test the new one and its features.
I saw that it was a good manual as well. Thanks for the detailed answer, I will return
if I cant solve my problem. :)
Quote from Vadim on December 8, 2021, 9:27 pm@simon-lundin
The plugin works perfectly. Like the laws of logic, which are two and a half thousand years old. )) What's done well never gets old.
The plugin works perfectly. Like the laws of logic, which are two and a half thousand years old. )) What's done well never gets old.
Quote from CN_Iceman on December 12, 2021, 8:47 amQuote from Vadim on December 8, 2021, 9:27 pmWhat's done well never gets old.
Wise words.
I'm writing it down, I'm going to notify my wife. ;-)Greetings.
Quote from Vadim on December 8, 2021, 9:27 pmWhat's done well never gets old.
Wise words.
I'm writing it down, I'm going to notify my wife. ;-)
Greetings.
Quote from DaviddeArgentina on December 12, 2021, 9:19 pmTake a look about SQLite plugin alternatives; there are a lot of posibilites of use, is pretty modern than dBase, has the SQL technology and syntax, and there are more robust for scalability.
My 0.01
Take a look about SQLite plugin alternatives; there are a lot of posibilites of use, is pretty modern than dBase, has the SQL technology and syntax, and there are more robust for scalability.
My 0.01