Start sample for a (My)-sql project

[Marc Venken]

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]

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 ?

[Jack]

Marc ,
I use MS SQL with Fivewin .
I also live in Belgium (Liege)
You can contact me if you want .
ph.jacquet@skynet.be

[Antonio Linares]

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

[dagiayunus]

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.

[Antonio Linares]

Yunus,

Yes

We are working on it

[nageswaragunupudi]

Mr Yunus

Please see latest post in mariadb samples

[dagiayunus]

Dear Mr.Rao/Mr.Atonio

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


Thanks & Regards
Yunus.

[Marc Venken]

I totaly agree !!

Without the samples, I could not do it ....

[Antonio Linares]

Mr Yunus

Please see latest post in mariadb samples

http://forums.fivetechsupport.com/viewt ... 18#p201218

https://bitbucket.org/fivetech/fivewin- ... riainv.zip

[Marc Venken]

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.

[dagiayunus]

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.

[nageswaragunupudi]

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.