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: 1338
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: 1338
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: 280
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: 41205
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.
Dagia Yunus.
Rajkot, India

FWH 17.04
dagiayunus
 
Posts: 69
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: 41205
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: 10206
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.
Dagia Yunus.
Rajkot, India

FWH 17.04
dagiayunus
 
Posts: 69
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: 1338
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: 41205
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: 1338
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.
Dagia Yunus.
Rajkot, India

FWH 17.04
dagiayunus
 
Posts: 69
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: 10206
Joined: Sun Nov 19, 2006 5:22 am
Location: India


Return to FiveWin for Harbour/xHarbour

Who is online

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