Puppy Personal Database

A home for all kinds of Puppy related projects
Message
Author
User avatar
gposil
Posts: 1300
Joined: Mon 06 Apr 2009, 10:00
Location: Stanthorpe (The Granite Belt), QLD, Australia
Contact:

Programmers aren't real people

#46 Post by gposil »

Greg said
Help.. cursor in top section... had two original records in old data base... put cursor I think in second field to see if I could modify.. at the top section... hit random keys.. and blew out the two records.. record count stayed... but current record indicator went to negative number... so something blew big time. Prior, next, first.. nothing will show old records.
Shows you the difference between programmers and real people...hitting random keys(from Previous post)...who'd have thought... :lol:
It's great you're testing it Greg and the feed back speeds up ironing out bugs. The random keys effect has to do with key combinations equaling delete record (Ctrl+d etc)...the simple fix will be rollback, coming in 0.5b
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]

Master_wrong
Posts: 452
Joined: Thu 20 Mar 2008, 01:48

#47 Post by Master_wrong »

:D

finally personal databases for pc...

one more feature needed --- > birthday record and option to auto remind it, perhaps link it with pschedule, at command or crontab... ?

interesting, I haven't seen anything like this

User avatar
gposil
Posts: 1300
Joined: Mon 06 Apr 2009, 10:00
Location: Stanthorpe (The Granite Belt), QLD, Australia
Contact:

#48 Post by gposil »

Master_wrong said
one more feature needed --- > birthday record and option to auto remind it, perhaps link it with pschedule, at command or crontab... ?
Yes birthday record and pschedule link will be in upcoming version.
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]

tlchost
Posts: 2057
Joined: Sun 05 Aug 2007, 23:26
Location: Baltimore, Maryland USA
Contact:

File Location

#49 Post by tlchost »

Is it possible/can it be done to set the default path of the database?

I use ChoicePup and have 3 savefiles.... one for day to day use, one for web development and one for testing. Rather than install the program and data in each of the versions, I would like to have it on my usb drive.

I've tested it, works fine on /mnt/home I'd like to tell the program to always look on /mnt/home/ppdb for the data files. Not only will it save space in the save files, but I can access the database(s) from windows when not running ChoicePup.

Thanks

Thom

Minnesota
Posts: 326
Joined: Thu 11 Sep 2008, 11:25

radom keys

#50 Post by Minnesota »

Shows you the difference between programmers and real people...hitting random keys(from Previous post)...who'd have thought... Laughing
It's great you're testing it Greg and the feed back speeds up ironing out bugs. The random keys effect has to do with key combinations equaling delete record (Ctrl+d etc)...the simple fix will be rollback, coming in 0.5b
_
Just for the record.... keys I am certain I hit.. were fasdfasfasfasf.... possibly one row lower...as That is the set I use for entering random data into fields for many years...very fast to put in... Will check again.... Been writing user oriented programs since 1968 :)). Operators will do almost anything, trust me!

Keep up the good work..
it is not easy making a program with complete error checking and all the features. It takes time to figure out what can go wrong, what can't go wrong and what WILL STILL GO WRONG! ERROR checking is one half of a program.

:)

User avatar
gposil
Posts: 1300
Joined: Mon 06 Apr 2009, 10:00
Location: Stanthorpe (The Granite Belt), QLD, Australia
Contact:

#51 Post by gposil »

tlchost said
Is it possible/can it be done to set the default path of the database?
Yes, version 0.6(not released yet) already has the setting available in Options/Preferences menu.

Minnesota said
what can't go wrong and what WILL STILL GO WRONG! ERROR checking is one half of a program.
Hit the nail on the head...maybe it's 75% of development time... :)
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]

Minnesota
Posts: 326
Joined: Thu 11 Sep 2008, 11:25

screen shots of fdadfasfasf

#52 Post by Minnesota »

attached base test data base with two records.

second screen... entered afsdfasfasf or fafsfasdf into the name field... and you can see the record count and missing data... oh well....

:)))
Attachments
Entered top with fasfasfasf 5 26 09.jpg
(28.49 KiB) Downloaded 702 times
test db wtih two records.jpg
(52.74 KiB) Downloaded 477 times

User avatar
gposil
Posts: 1300
Joined: Mon 06 Apr 2009, 10:00
Location: Stanthorpe (The Granite Belt), QLD, Australia
Contact:

#53 Post by gposil »

Minnesota, I have tried to duplicate the problem you're having but can't, could you give me a blow by blow so I can see what's happening.

Thanks

Guy
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]

Minnesota
Posts: 326
Joined: Thu 11 Sep 2008, 11:25

blow by blow

#54 Post by Minnesota »

Brought up old database
It needs to have data.. I first used the original test db yesterday.

Today for the pictures I sent, I used test I had built with ver .4 Blue highlighted box is where I entered the random field data. Might blow on any data? I simply tried entering anything in the field....Just to see if I could still update the top pane. That is all I tried....

Move the cursor to the name field at the TOP window...

Hit a bunch of the home keys... sdfasfasfasfas or asfasfafasfasf or fsdffsafaas.... and it all blew up....Home keys with left hand.

If you still can not duplicate this.... I will try building again from scratch and give it another shot... sending the pieces...

OK?

Just guessing.... Key field.. first field is locked at the top.... second - name field was not... Did not try first address field.. as data was gone... Can build other test DB.. to test other fields if you need me to do so.

User avatar
gposil
Posts: 1300
Joined: Mon 06 Apr 2009, 10:00
Location: Stanthorpe (The Granite Belt), QLD, Australia
Contact:

Update

#55 Post by gposil »

Version 0.5b uploaded...

Major additions and changes:

1.) Grid is now read only
2.) Right click context menu in grid ( See Screenshot)
3.) Ability to see deleted records(in red) or not
4.) Undelete facility(provided you haven't packed the database)
5.) Sort database view on key field (last Name)
6.) Addition of calculator and calendar tools
7.) Preferences now active with default database location etc
8.) Context menu choices for email or WWW on selected record.

Freeform database creation will not be included till version 0.6. Also, for the time being the database view grid will be read only, as a glitch has turned up that cannot be addressed with Puppy's current version of Gtk2+.(This will be addressed, but I see it as no great inconvenience for the time being)

Please keep suggestions coming...

NB. Please uninstall all previous versions prior to install of 0.5b as number of changes will conflict with older versions.
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]

Minnesota
Posts: 326
Joined: Thu 11 Sep 2008, 11:25

similar problem

#56 Post by Minnesota »

Sorry to report.. .but upper gird still open and same problem exists.

See attached.

Questions.

I attempted to Unload the old versions.. I had 0.4 and 0.5 loaded to Puppy 4.10 on a stick... was apparently able to unload .5 but 0.4 would not do a thing... so simply loaded .5b...and tried test. Blew up... so took new CD of 4.2.1 final.. - clean start. as you can see... same issue.

Now of course I can show deleted records... so for some reason top gird is 1) still unlocked... and 2) entering data to the name filed will blow out the db... which is quite interesting actually...

Is there a special method to uninstall a pet.. I have never tried it before.

Also learning more about how to use paint for capture :))) with text.

Will test other features. This problem can be fixed later.

Keep with it.
Attachments
pb 5b 52709 b.jpg
(33.1 KiB) Downloaded 630 times

User avatar
gposil
Posts: 1300
Joined: Mon 06 Apr 2009, 10:00
Location: Stanthorpe (The Granite Belt), QLD, Australia
Contact:

#57 Post by gposil »

To remove pet go to Puppy Package Manager in Setup menu and remove from there.

The only thing I came up with is that the 'd' key is a shortcut to delete record in the grid...I can remove that...but that's it at this stage...remember database records are only really deleted from a table when the database is packed and re-indexed, otherwise they are just hidden in normal view...hence the toggle for show deleted or not.

Keep up the good work...it helps a great deal. :)

PS. Fixed that keying problem...grid now recognizes no key strokes...will upload fix tomorrow.
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]

Minnesota
Posts: 326
Joined: Thu 11 Sep 2008, 11:25

Thank you

#58 Post by Minnesota »

Thank you Sir:

Will keep playing this end :).

Any possibility of validity checking the fields.. at least for Alpha verses Numeric? Unless phone numbers have alpha still some locations in the world? Humm... forgot about that... as I think Canada has Alpha in zip?

User avatar
gposil
Posts: 1300
Joined: Mon 06 Apr 2009, 10:00
Location: Stanthorpe (The Granite Belt), QLD, Australia
Contact:

#59 Post by gposil »

Minnesota said
Any possibility of validity checking the fields.. at least for Alpha verses Numeric? Unless phone numbers have alpha still some locations in the world? Humm... forgot about that... as I think Canada has Alpha in zip?


Yes the validity checking is somewhat problematic...UK also has alpha in zip and a number of country's numerical zips differ in length...The phone numbers are a real problem, the US format just doesn't match anywhere else but I am working on some validity checking...
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]

tlchost
Posts: 2057
Joined: Sun 05 Aug 2007, 23:26
Location: Baltimore, Maryland USA
Contact:

#60 Post by tlchost »

gposil wrote: Yes the validity checking is somewhat problematic.
One could call a rule for postal code and phone after the country is selected.

Of course the rule set could live in a seperate database.

User avatar
gposil
Posts: 1300
Joined: Mon 06 Apr 2009, 10:00
Location: Stanthorpe (The Granite Belt), QLD, Australia
Contact:

#61 Post by gposil »

Exactly tlchost that what i'm doing ver 0.6... :)
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]

tlchost
Posts: 2057
Joined: Sun 05 Aug 2007, 23:26
Location: Baltimore, Maryland USA
Contact:

#62 Post by tlchost »

gposil wrote:Exactly tlchost that what i'm doing ver 0.6... :)
I have to share with you that a million years ago when I was beta testing DbaseIV, I really enjoyed the input to the design guys....and this is really fun too.

Curious....is there/can there be an option to open a dbase in one format(dbase4) and save it to another format(dbase3).

Now...if one could port some of the dabse programming into Linux.................

Thom

User avatar
gposil
Posts: 1300
Joined: Mon 06 Apr 2009, 10:00
Location: Stanthorpe (The Granite Belt), QLD, Australia
Contact:

#63 Post by gposil »

tlchost said
Curious....is there/can there be an option to open a dbase in one format(dbase4) and save it to another format(dbase3).
Yes export of database to mutiple formats will be available in v 0.6.
dbaseIII+
dbaseIV
dbaseVII
Foxpro
SQLite
and a little further down the track Paradox, Oracle and M$ODBC.
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]

User avatar
gposil
Posts: 1300
Joined: Mon 06 Apr 2009, 10:00
Location: Stanthorpe (The Granite Belt), QLD, Australia
Contact:

#64 Post by gposil »

Version 0.5b random key bug fix now uploaded...0.6 release with mass of feature changes should be ready tomorrow... :)
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]

Minnesota
Posts: 326
Joined: Thu 11 Sep 2008, 11:25

control keys

#65 Post by Minnesota »

Question...are the control keys functional?

Looks like not all the options at the top... previous, first... have control keys...?

The key for save shows as Control -p.. is that right? And how much data must be entered to use the save? Putting in first three fields, then trying either ctrl-p or ctrl-s did not seem to work...

Next version :).

Post Reply