YADA - Yet another database application

Applications, Games, Tools, User libs and useful stuff coded in PureBasic
User avatar
kpeters58
Enthusiast
Enthusiast
Posts: 341
Joined: Tue Nov 22, 2011 5:11 pm
Location: Kelowna, BC, Canada

Re: YADA - Yet another database application

Post by kpeters58 »

Sorry for the delay - updated zip file including the images has been posted

http://www.otaksoft.com/purebasic/ContactManager.zip
PB 5.73 on Windows 10 & OS X High Sierra
User avatar
jcaceres
New User
New User
Posts: 5
Joined: Wed Jul 01, 2020 5:49 am

Re: YADA - Yet another database application

Post by jcaceres »

THANK YOU C87

I WAS ABLE TO DOWNLOAD IT. MY MISTAKE. WAS CHECKING ON AN OLDER POST.

It works fine now. thanks a lot.
User avatar
C87
Enthusiast
Enthusiast
Posts: 176
Joined: Mon Jul 17, 2017 7:22 am
Location: Cotswolds England

Re: YADA - Yet another database application

Post by C87 »

Hi kpeters58, The one I remember is in the Add/Edit module - form_Contact.pbi
Nothing major but easily fixed. :)
If you have selected add a new record, add the record, then save and without closing make changes
to that new record, then click Save again. It will add another new record with those changes. So
you end up with two nearly identical records. One the original Add & one the modified Add.
All it needs is a switch from the ADD to EDIT variable after adding. I thought a good one
for anyone going through it would easily fix! Mmm, that's odd...two the same. Why is that?

Cheers, C87
If it's falling over......just remember the computer is never wrong!
User avatar
kpeters58
Enthusiast
Enthusiast
Posts: 341
Joined: Tue Nov 22, 2011 5:11 pm
Location: Kelowna, BC, Canada

Re: YADA - Yet another database application

Post by kpeters58 »

Image

Version 1.1.0 of YADA Contactmanager is now available from

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

Change log:

- Added UNIQUE constraints at the database level for: email, phone number and combination of first-& last names, address and city
- Added support for multi-language support (based on Freak's post here: viewtopic.php?t=26729)
YADA now supports both English & German, switchable at runtime. Effort required to add another language: Approx. 1 h.

Fixes:
- Some typos and minor tweaks

Notes:
- This release is not backwards compatible with databases generated by earlier versions. If you have one of these, simply delete it.

Enjoy!
PB 5.73 on Windows 10 & OS X High Sierra
User avatar
C87
Enthusiast
Enthusiast
Posts: 176
Joined: Mon Jul 17, 2017 7:22 am
Location: Cotswolds England

Re: YADA - Yet another database application

Post by C87 »

Hello kpeters58, Very impressed with the langauge option. Have to say I'd not have thought of doing that.
Your users may want to add the following new line 221 to form_Contact.pbi after the existing line 220 :

Code: Select all

line 
219     If DBMode = #DBMode_Insert
220         InsertRecord()
221         DBMode = #DBMODE_Edit     ;<<<<<< Add this line to prevent another record from being added by clicking [SAVE] without closing 
222      Else ; #DBMode_Edit
223         UpdateRecord()
224      EndIf
Regards, C87
If it's falling over......just remember the computer is never wrong!
User avatar
kpeters58
Enthusiast
Enthusiast
Posts: 341
Joined: Tue Nov 22, 2011 5:11 pm
Location: Kelowna, BC, Canada

Re: YADA - Yet another database application

Post by kpeters58 »

C87 wrote:Hello kpeters58, Very impressed with the langauge option. Have to say I'd not have thought of doing that.
Your users may want to add the following new line 221 to form_Contact.pbi after the existing line 220 :

Code: Select all

line 
219 &nbsp;&nbsp;&nbsp;&nbsp;If DBMode = #DBMode_Insert
220      &nbsp;&nbsp;&nbsp;InsertRecord()
221     &nbsp;&nbsp;&nbsp;&nbsp;DBMode = #DBMODE_Edit     ;<<<<<< Add this line to prevent another record from being added by clicking [SAVE] without closing 
222    &nbsp;&nbsp;Else ; #DBMode_Edit
223      &nbsp;&nbsp;&nbsp;UpdateRecord()
224    &nbsp;&nbsp;EndIf
Regards, C87
C87 wrote:Hello kpeters58, Very impressed with the langauge option. Have to say I'd not have thought of doing that.
Your users may want to add the following new line 221 to form_Contact.pbi after the existing line 220 :

Code: Select all

line 
219     If DBMode = #DBMode_Insert
220         InsertRecord()
221         DBMode = #DBMODE_Edit     ;<<<<<< Add this line to prevent another record from being added by clicking [SAVE] without closing 
222      Else ; #DBMode_Edit
223         UpdateRecord()
224      EndIf
Regards, C87

Hi Will,

not a bad idea, but i would probably tie that to AppData\KeyAutoCloseContacts being #False as your suggestion is only meaningful if the contact form stays open after save.

Cheers,
Kai
PB 5.73 on Windows 10 & OS X High Sierra
Post Reply