It is currently Wed Nov 13, 2019 11:07 am

All times are UTC + 1 hour




Post new topic Reply to topic  [ 11 posts ] 
Author Message
 Post subject: YADA - Yet another database application
PostPosted: Sun Mar 17, 2019 11:34 pm 
Offline
Enthusiast
Enthusiast
User avatar

Joined: Tue Nov 22, 2011 5:11 pm
Posts: 273
Location: Kelowna, BC, Canada
Image


In July of last year, RobertSF posted this: https://www.purebasic.fr/english/viewtopic.php?f=27&t=70998

I had a look at it, and it motivated me to do another version of it, also aimed at PB beginners but using
SQLite instead.

My application is written in PB 5.70 and has only been tested under Windows 10. It should be easily adaptable
to slightly older versions of PB, and to MacOS & Linux as well.

It will automatically create its own database and populate it with sample data for immediate exploration upon the first run.

I would be remiss if I didn't thank all the friendly folks at the forums who have helped me time and again over the years - thank you!
Some of your wisdom and kindness is included in the source!

This little desktop application is not quite end-user release quality, but pretty close.

If you find something wrong with it, please post it here and I will try and fix it - time permitting. Enjoy!

You can download it here: http://www.otaksoft.com/purebasic/ContactManager.zip

_________________
PB 5.71 on Windows 10 & OS X High Sierra


Top
 Profile  
Reply with quote  
 Post subject: Re: YADA - Yet another database application
PostPosted: Tue Mar 19, 2019 12:18 am 
Offline
Addict
Addict
User avatar

Joined: Sat Apr 26, 2003 2:15 pm
Posts: 833
Location: Cuernavaca, Mexico
Very nice Kai,

Clean and very intuitive, I like it. :mrgreen:

_________________
- It was too lonely at the top.

Current Machine: Win 10 Pro 64-bit, Dual Xeon E5-2670, 64 gigs ram, Geforce GTX 1660 Ti w/6 gigs ram


Top
 Profile  
Reply with quote  
 Post subject: Re: YADA - Yet another database application
PostPosted: Tue Mar 19, 2019 8:07 pm 
Offline
Addict
Addict
User avatar

Joined: Sun Nov 05, 2006 11:42 pm
Posts: 4520
Location: Lyon - France
Nice !!! thanks for sharing 8)

_________________
ImageThe happiness is a road...
Not a destination


Top
 Profile  
Reply with quote  
 Post subject: Re: YADA - Yet another database application
PostPosted: Wed Mar 20, 2019 2:23 am 
Offline
Enthusiast
Enthusiast
User avatar

Joined: Tue Nov 22, 2011 5:11 pm
Posts: 273
Location: Kelowna, BC, Canada
Image


Version 1.0.1 of YADA Contactmanager is now available from

http://www.otaksoft.com/purebasic/ContactManager.zip

Change log:

- Added support for: Address, City & PostalCode
- Find function now scrolls found record into view
- Filter now highlights matches in the column used for filtering and no longer in the ID column
- Change detection in form_Config is now handled via bit flags
- Support for default export directory added
- Support for filtering all exports (XML, JSON, CSV) added

Fixes:
- Error messages: The title caption and the actual message were swapped.

Notes:
- This release is not backwards compatible with databases generated by version 1.0.0. If you have one of these, simply delete it.
- The preference item 'PropercaseNames' has been renamed to 'PropercaseStrings' since it now applies to addresses and city names
as well. Deleting an existing Contactmanager.prefs file will get rid of that redundant entry.

Enjoy!

_________________
PB 5.71 on Windows 10 & OS X High Sierra


Last edited by kpeters58 on Sat Jun 08, 2019 5:44 am, edited 1 time in total.

Top
 Profile  
Reply with quote  
 Post subject: Re: YADA - Yet another database application
PostPosted: Thu Apr 18, 2019 1:00 pm 
Offline
Moderator
Moderator
User avatar

Joined: Thu Dec 31, 2009 11:05 pm
Posts: 1105
Location: Germany::Berlin()
Nice 8)

_________________
ImageImageImageImage Image


Top
 Profile  
Reply with quote  
 Post subject: Re: YADA - Yet another database application
PostPosted: Tue Oct 15, 2019 6:24 am 
Offline
New User
New User

Joined: Mon Oct 14, 2019 7:31 am
Posts: 7
Trying to download and have a look and learn from and I see the domain is expired - look forward to looking and learning from it. Thanks in advance!


Top
 Profile  
Reply with quote  
 Post subject: Re: YADA - Yet another database application
PostPosted: Tue Oct 15, 2019 12:40 pm 
Offline
Enthusiast
Enthusiast
User avatar

Joined: Wed Sep 22, 2010 1:17 pm
Posts: 311
Location: United Kingdom
RSBasic sometimes squirrels away any goodies he likes the look of at:
https://www.rsbasic.de/backups/

I think this is the one you're looking for:
http://backup.rsbasic.de/?file=ContactManager.zip


Top
 Profile  
Reply with quote  
 Post subject: Re: YADA - Yet another database application
PostPosted: Thu Oct 17, 2019 7:28 am 
Offline
New User
New User

Joined: Mon Oct 14, 2019 7:31 am
Posts: 7
thank you


Top
 Profile  
Reply with quote  
 Post subject: Re: YADA - Yet another database application
PostPosted: Thu Oct 17, 2019 8:03 pm 
Offline
Enthusiast
Enthusiast
User avatar

Joined: Tue Nov 22, 2011 5:11 pm
Posts: 273
Location: Kelowna, BC, Canada
Domain should have auto-renewed but didn't :(

Fixed. Sorry for any inconvenience!

_________________
PB 5.71 on Windows 10 & OS X High Sierra


Top
 Profile  
Reply with quote  
 Post subject: Re: YADA - Yet another database application
PostPosted: Fri Oct 18, 2019 2:47 am 
Offline
Enthusiast
Enthusiast

Joined: Wed Mar 11, 2009 4:06 pm
Posts: 142
Location: NL
Not sure whats purpose of magic line

offset = RowCount / 20 ; 20 works pretty well in initial, minimized and maximized window sizes

in form_main.pbi is for, but needs to be commented on macOS, otherwise last item will always be selected and can't select anything else.


Top
 Profile  
Reply with quote  
 Post subject: Re: YADA - Yet another database application
PostPosted: Fri Oct 18, 2019 8:47 pm 
Offline
Enthusiast
Enthusiast
User avatar

Joined: Tue Nov 22, 2011 5:11 pm
Posts: 273
Location: Kelowna, BC, Canada
Rinzwind wrote:
Not sure whats purpose of magic line

offset = RowCount / 20 ; 20 works pretty well in initial, minimized and maximized window sizes

in form_main.pbi is for, but needs to be commented on macOS, otherwise last item will always be selected and can't select anything else.



On Windows, with screen scaling > 100% and using the program's find functionality, the 'found' record doesn't always fully scroll into view - hence the addition of a small offset to ensure that it does. Removing it should be harmless. It looks like macOS does something not too smart when asked to scroll past the last record...??

I assume your statement is only true for locating one of the last 3 records or so? I can't see how your blanket statement could be true in all cases - unless there also is some bug involved.

_________________
PB 5.71 on Windows 10 & OS X High Sierra


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 11 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  

 


Powered by phpBB © 2008 phpBB Group
subSilver+ theme by Canver Software, sponsor Sanal Modifiye