Start sample for a (My)-sql project

Start sample for a (My)-sql project

Postby Marc Venken » Fri Apr 28, 2017 8:07 am

Hello,

I want to make a program for my football club. A Member system that can be accessed from several computers by the coaches.

Who can share the basic start code to get me going? Once this setup to work, i can create the rest ...

Setup :

There a several options possible, but in FWH there is one where we don't need to install any extra software on the coaches computers.
Only the folder with my program would be the most easy thing to install.

My program won't need high level security, complex sql's, more a pretty simple membership software.

That option if possible for the start sample.

Login to a online database (One Database = Members, with one of the field 'Team' Like Team1,Team2,Team3,...)
User gets a level for data access (4 levels needed) Coache for Team 3 (only sees the members in team 3)
Scope selected data that they only see Team 3
Start XBrowse with this data

From there, I can start. (So the connection and the login is most important)

Two extra functions :

The scope for selecting only team1

A loop for updating data like
replace member->naam with cNaam
replace member-data with dDate

My thanks for any working sample.

BTW : For this club i'm doing it : www.kaboutersopglabbeek.be
Marc Venken
Using: FWH 23.04 with Harbour
User avatar
Marc Venken
 
Posts: 1425
Joined: Tue Jun 14, 2016 7:51 am
Location: Belgium

Re: Start sample for a (My)-sql project

Postby Marc Venken » Fri Apr 28, 2017 9:07 am

Hello,

I also see that I can use standard FWH with DBF if I use the program on my own NAS.

I'v been ably to run a program from 2 locations via NAS, but then there was a connection needed by VPN.

Is there a easy way to have my coaches install VPN on there computers or even better, can I make a connection from my program in FWH from there computer to my NAS ?
Marc Venken
Using: FWH 23.04 with Harbour
User avatar
Marc Venken
 
Posts: 1425
Joined: Tue Jun 14, 2016 7:51 am
Location: Belgium

Re: Start sample for a (My)-sql project

Postby Jack » Fri Apr 28, 2017 9:55 am

Marc ,
I use MS SQL with Fivewin .
I also live in Belgium (Liege)
You can contact me if you want .
ph.jacquet@skynet.be
Jack
 
Posts: 288
Joined: Wed Jul 11, 2007 11:06 am

Re: Start sample for a (My)-sql project

Postby Antonio Linares » Fri Apr 28, 2017 10:17 am

Marc,

You may review FWH\samples\yunus.prg for a great databases management example, full source code provided.

We are going to adapt it to use FWH built in MySQL/MariaDB support
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 42065
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Re: Start sample for a (My)-sql project

Postby dagiayunus » Wed May 03, 2017 11:21 am

Antonio Linares wrote:Marc,

You may review FWH\samples\yunus.prg for a great databases management example, full source code provided.

We are going to adapt it to use FWH built in MySQL/MariaDB support


Sir,

Can we have Mysql/Mariadb sample similar to yunus.org in next version 17.05?

Thanks & Regards
Yunus.
Regards
Yunus

FWH 21.02
dagiayunus
 
Posts: 85
Joined: Wed Nov 19, 2014 1:04 pm

Re: Start sample for a (My)-sql project

Postby Antonio Linares » Wed May 03, 2017 1:28 pm

Yunus,

Yes

We are working on it :-)
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 42065
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Re: Start sample for a (My)-sql project

Postby nageswaragunupudi » Wed May 03, 2017 2:47 pm

Mr Yunus

Please see latest post in mariadb samples
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10620
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: Start sample for a (My)-sql project

Postby dagiayunus » Fri May 05, 2017 8:27 am

Dear Mr.Rao/Mr.Atonio

Thanks for the valuable sample. It helps us to learn professional programing.


Thanks & Regards
Yunus.
Regards
Yunus

FWH 21.02
dagiayunus
 
Posts: 85
Joined: Wed Nov 19, 2014 1:04 pm

Re: Start sample for a (My)-sql project

Postby Marc Venken » Fri May 05, 2017 9:52 am

I totaly agree !!

Without the samples, I could not do it ....
Marc Venken
Using: FWH 23.04 with Harbour
User avatar
Marc Venken
 
Posts: 1425
Joined: Tue Jun 14, 2016 7:51 am
Location: Belgium

Re: Start sample for a (My)-sql project

Postby Antonio Linares » Fri May 05, 2017 1:16 pm

nageswaragunupudi wrote:Mr Yunus

Please see latest post in mariadb samples


viewtopic.php?p=201218#p201218

https://bitbucket.org/fivetech/fivewin-contributions/downloads/mariainv.zip
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 42065
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Re: Start sample for a (My)-sql project

Postby Marc Venken » Fri May 05, 2017 1:40 pm

Hey Antonio,

We have seen the sample's in the other topic.

It was ment as a compliment for FW and the forum, and espacialy for Mr. Rao and you ...

Keep on the work. :wink:
Marc Venken
Using: FWH 23.04 with Harbour
User avatar
Marc Venken
 
Posts: 1425
Joined: Tue Jun 14, 2016 7:51 am
Location: Belgium

Re: Start sample for a (My)-sql project

Postby dagiayunus » Mon May 15, 2017 10:10 pm

Dear Sir,

If we want auto generated invoice no. LIKE INV00001 , INV000002.
and How to update clients balance according to invoices? should we use trigger? How?

Regards
Yunus.
Regards
Yunus

FWH 21.02
dagiayunus
 
Posts: 85
Joined: Wed Nov 19, 2014 1:04 pm

Re: Start sample for a (My)-sql project

Postby nageswaragunupudi » Mon May 15, 2017 11:42 pm

dagiayunus wrote:Dear Sir,

If we want auto generated invoice no. LIKE INV00001 , INV000002.
and How to update clients balance according to invoices? should we use trigger? How?

Regards
Yunus.


For updating clients' balances, use triggers.
For generating sequential numbers like "INV????", we better have another sequence table and use it.
It is not safe to:
(1) Take Max( INVNO ) and increment it or
(2) do it in triggers
Both may result in duplicate numbers in case of multi-user environment

We will publish examples soon.
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10620
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: Start sample for a (My)-sql project

Postby dagiayunus » Mon Jul 08, 2024 4:24 pm

Dear Mr.Rao

*Mariainv.prg*
How to prevent user to change items code?

How to create database on localhost using fivewin?

Thanks and regards
Yunus.

Sent from my SM-M515F using Tapatalk
Regards
Yunus

FWH 21.02
dagiayunus
 
Posts: 85
Joined: Wed Nov 19, 2014 1:04 pm

Re: Start sample for a (My)-sql project

Postby Otto » Tue Jul 09, 2024 10:55 am

Hello Mark,
did you ever create the program for setting up your football players?

I am currently working on a solution for work scheduling in companies.
I originally made the program in Fivewin but am now redoing it as a web application.

This approach should actually be suitable for a football lineup as well.

Best regards,
Otto

Image
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6312
Joined: Fri Oct 07, 2005 7:07 pm


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 79 guests