FiveTech Software tech support forums

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

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 ,
I use MS SQL with Fivewin .
I also live in Belgium (Liege)
You can contact me if you want .
ph.jacquet@skynet.be

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

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.

Yunus,

Yes

We are working on it

Mr Yunus

Please see latest post in mariadb samples

Dear Mr.Rao/Mr.Atonio

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


Thanks & Regards
Yunus.

I totaly agree !!

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

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.

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.

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.