About NeobookDB 2.3d database questions
Quote from impactband4u on February 14, 2019, 11:25 pmHi guys
I want to know a few things about using (.dbf) database and want to start using it in my apps.
- How many entries can the database keep? I'm talking about the one i'm using at the moment and not the pro version.
- How do I delete empty entries (spaces) in database?
- Can I use FileWrite to write a variable directly into the database?
Is there any help files or tutorials on how to use database?
Thank You
Hi guys
I want to know a few things about using (.dbf) database and want to start using it in my apps.
- How many entries can the database keep? I'm talking about the one i'm using at the moment and not the pro version.
- How do I delete empty entries (spaces) in database?
- Can I use FileWrite to write a variable directly into the database?
Is there any help files or tutorials on how to use database?
Thank You
Quote from danito on February 15, 2019, 5:36 pmHola espero te pueda orientar.
1.- No hay una cantidad límite de registros sino de tamaño, según recuerdo son 2 Gb.
2.- Para eliminar espacios vacíos se debe compactar la base de datos, usa el comando DbfPack.
3.- Nunca lo he intentado, podría corromperse la base de datos.
4.- Con la instalación del plugin viene un archivo de ayuda.
Hola espero te pueda orientar.
1.- No hay una cantidad límite de registros sino de tamaño, según recuerdo son 2 Gb.
2.- Para eliminar espacios vacíos se debe compactar la base de datos, usa el comando DbfPack.
3.- Nunca lo he intentado, podría corromperse la base de datos.
4.- Con la instalación del plugin viene un archivo de ayuda.
Quote from impactband4u on February 15, 2019, 8:28 pmThank You danito
1.- Thank you, i think 2GB would be enough to store only text
2.- If i'm correct, i think the dbfPack only delete spaces of entries that has already been deleted and not empty spaces currently in the database
3.- ok
4.- I installed the Database plugin but see no help file. Where is it located?
Thank You danito
1.- Thank you, i think 2GB would be enough to store only text
2.- If i'm correct, i think the dbfPack only delete spaces of entries that has already been deleted and not empty spaces currently in the database
3.- ok
4.- I installed the Database plugin but see no help file. Where is it located?
Quote from Gaev on February 16, 2019, 5:40 pm@impactband4u
Is there any help files or tutorials on how to use database?
I have a copy of the Help file ... but note that it is in the (old) .hlp format, which is not readable on machines running the latest Windows versions.
If you have an old (XP ?) machine gathering dust, I can provide a copy of the file ... I suggest that if @luishp is agreeable, I can send him a copy and he can make it available to all who need it from this website.
2.- If i'm correct, i think the dbfPack only delete spaces of entries that has already been deleted and not empty spaces currently in the database
Define what empty spaces (besides those occupied by deleted records) are.
If a field has length of (say) 100 characters, and one of your records only uses 6 characters, such "empty spaces" are not recoverable from the .dbf file; note that the plugin is based on the (circa 1984) PC product called dBase II (and later III and IV). I am not sure why you need to do that since today's PCs come with 100's of GB of disk space :-))
Is there any help files or tutorials on how to use database?
I have a copy of the Help file ... but note that it is in the (old) .hlp format, which is not readable on machines running the latest Windows versions.
If you have an old (XP ?) machine gathering dust, I can provide a copy of the file ... I suggest that if @luishp is agreeable, I can send him a copy and he can make it available to all who need it from this website.
2.- If i'm correct, i think the dbfPack only delete spaces of entries that has already been deleted and not empty spaces currently in the database
Define what empty spaces (besides those occupied by deleted records) are.
If a field has length of (say) 100 characters, and one of your records only uses 6 characters, such "empty spaces" are not recoverable from the .dbf file; note that the plugin is based on the (circa 1984) PC product called dBase II (and later III and IV). I am not sure why you need to do that since today's PCs come with 100's of GB of disk space :-))
Quote from luishp on February 17, 2019, 12:41 pmI think the plugin already comes with that help file but I have been unable to read it or tranform it into any other format.
If anyone can transcode it to a modern help format I can convert it to HTML and upload it to the online documentation section.
Regards.
I think the plugin already comes with that help file but I have been unable to read it or tranform it into any other format.
If anyone can transcode it to a modern help format I can convert it to HTML and upload it to the online documentation section.
Regards.
Quote from mishem on February 17, 2019, 3:20 pmhttp://rgho.st/6gV5WP5dP
Install.cmd from admin.
Read files .HLP on any Windows system
Install.cmd from admin.
Read files .HLP on any Windows system
Quote from Gaev on February 17, 2019, 3:51 pm@mishem
There are several such pages that involve downloading/installation of the old .hlp file handler. In a worst case scenario, people who need to use this (old) software can do so on their own computer.
What would be the best scenario, and I haven't found one, is for some kind of conversion utility that would create a .chm or .html or .pdf file; that way, everybody can then access this content on Windows 10 machines.
There are several such pages that involve downloading/installation of the old .hlp file handler. In a worst case scenario, people who need to use this (old) software can do so on their own computer.
What would be the best scenario, and I haven't found one, is for some kind of conversion utility that would create a .chm or .html or .pdf file; that way, everybody can then access this content on Windows 10 machines.
Quote from mishem on February 18, 2019, 7:57 pmQuote from Gaev on February 17, 2019, 3:51 pmWhat would be the best scenario, and I haven't found one, is for some kind of conversion utility that would create a .chm or .html or .pdf file;
http://www.helpscribble.com/decompiler.html
http://www.oocities.org/mwinterhoff/helpdeco.htm
NEOBOOKDB.chm
http://rgho.st/6zTgGbBPQ
Quote from Gaev on February 17, 2019, 3:51 pmWhat would be the best scenario, and I haven't found one, is for some kind of conversion utility that would create a .chm or .html or .pdf file;
http://www.helpscribble.com/decompiler.html
http://www.oocities.org/mwinterhoff/helpdeco.htm
NEOBOOKDB.chm
Quote from Gaev on February 18, 2019, 8:07 pm@mishem:
Thanks for the links.
I had found HelpScribble but thought that $99 was overkill to convert just one file (they do have have a free 14 day trial, but I wasn't sure about ethics of using it knowing i would not buy it).
HelpDeco is a good (free) find.
Perhaps @luishp can include the converted Help file (rtf format ?) in the NeobookDB plugin.
@mishem:
Thanks for the links.
I had found HelpScribble but thought that $99 was overkill to convert just one file (they do have have a free 14 day trial, but I wasn't sure about ethics of using it knowing i would not buy it).
HelpDeco is a good (free) find.
Perhaps @luishp can include the converted Help file (rtf format ?) in the NeobookDB plugin.
Quote from mishem on February 18, 2019, 8:31 pmQuote from Gaev on February 18, 2019, 8:07 pmI had found HelpScribble but thought that $99 was overkill to convert just one file
HTML Help Workshop copes well.
I did CHM from RTF. :)
NEOBOOKDB.RTF
http://rgho.st/8McT68fVl
Quote from Gaev on February 18, 2019, 8:07 pmI had found HelpScribble but thought that $99 was overkill to convert just one file
HTML Help Workshop copes well.
I did CHM from RTF. :)
NEOBOOKDB.RTF
Quote from impactband4u on February 19, 2019, 12:33 amThank you all for the feedback. I will wait till the help file is in a format that is easy accessible.
Define what empty spaces (besides those occupied by deleted records) are
Hi Gaev
When i create a .dbf "database" file and open (show/hide) it in a rectangle i can see the "Field" names i created. Lets say the first field is "Name". Now when i enter a name in a TextEntry "Name" "[registerName]" and click a button to add the name to database "dbfAddRecord" it added it, but also added a blank entry at the end of the database. When i added 10 Names and want to change Name number 5 to something else, it changes it but again added another blank entry at the end of the database, so now there are two blank entries. How can i delete entries that has nothing in it in the database. Hope i explain it right : )
Thank You
Thank you all for the feedback. I will wait till the help file is in a format that is easy accessible.
Define what empty spaces (besides those occupied by deleted records) are
Hi Gaev
When i create a .dbf "database" file and open (show/hide) it in a rectangle i can see the "Field" names i created. Lets say the first field is "Name". Now when i enter a name in a TextEntry "Name" "[registerName]" and click a button to add the name to database "dbfAddRecord" it added it, but also added a blank entry at the end of the database. When i added 10 Names and want to change Name number 5 to something else, it changes it but again added another blank entry at the end of the database, so now there are two blank entries. How can i delete entries that has nothing in it in the database. Hope i explain it right : )
Thank You
Quote from Gaev on February 19, 2019, 1:13 am@impactband4u:
When i create a .dbf "database" file and open (show/hide) it in a rectangle i can see the "Field" names i created. Lets say the first field is "Name". Now when i enter a name in a TextEntry "Name" "[registerName]" and click a button to add the name to database "dbfAddRecord" it added it, but also added a blank entry at the end of the database.
It has been about 10 years since I last used this (old) software; but I do recall some quirk in that there always had to be at least one empty record in the database file.
When i added 10 Names and want to change Name number 5 to something else, it changes it but again added another blank entry at the end of the database, so now there are two blank entries.
That I had not heard of before.
Are you changing the field's value when viewing the Grid ? If so, how are you completing the change ? Perhaps you are clicking on the icon (plus sign ?) which is to "add a blank record".
You may have to provide details of every keystroke and mouse click in order to figure this out.
How can i delete entries that has nothing in it in the database.
I can't read the Help file on my Windows 10 machine, so please make a backup of your database before trying this.
My (faint) recollection is that you first do a dbfQuery (to filter the records where one of the text fields is empty); then use the script command dbfDeleteAll.
P.S. Unless there is a specific reason to use this plugin, may I suggest that you look into the (more modern) NeoBookDBPro plugin; NeoBookDB is based on technology from the 1980's and will become increasingly unsupportable as time goes on.
@impactband4u:
When i create a .dbf "database" file and open (show/hide) it in a rectangle i can see the "Field" names i created. Lets say the first field is "Name". Now when i enter a name in a TextEntry "Name" "[registerName]" and click a button to add the name to database "dbfAddRecord" it added it, but also added a blank entry at the end of the database.
It has been about 10 years since I last used this (old) software; but I do recall some quirk in that there always had to be at least one empty record in the database file.
When i added 10 Names and want to change Name number 5 to something else, it changes it but again added another blank entry at the end of the database, so now there are two blank entries.
That I had not heard of before.
Are you changing the field's value when viewing the Grid ? If so, how are you completing the change ? Perhaps you are clicking on the icon (plus sign ?) which is to "add a blank record".
You may have to provide details of every keystroke and mouse click in order to figure this out.
How can i delete entries that has nothing in it in the database.
I can't read the Help file on my Windows 10 machine, so please make a backup of your database before trying this.
My (faint) recollection is that you first do a dbfQuery (to filter the records where one of the text fields is empty); then use the script command dbfDeleteAll.
P.S. Unless there is a specific reason to use this plugin, may I suggest that you look into the (more modern) NeoBookDBPro plugin; NeoBookDB is based on technology from the 1980's and will become increasingly unsupportable as time goes on.
Quote from luishp on February 20, 2019, 12:12 amThank you @mishem!
I have converted your RTF to PDF and added it to the plugin download file.
In any case, please note this plugin is really old and, although it still work I do not recommend using it for serious purposes.
Best regards.
Thank you @mishem!
I have converted your RTF to PDF and added it to the plugin download file.
In any case, please note this plugin is really old and, although it still work I do not recommend using it for serious purposes.
Best regards.