PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

|
|
|
FR
Accueil → WINDEV 2024 → Windev Service to copy data from SQL to HFSQL
Windev Service to copy data from SQL to HFSQL
Débuté par anahoret3, 05 mar. 2025 19:25 - 3 réponses
#1
Posté le 05 mars 2025 - 19:25
Greetings,
Could you suggest,

The task is to have a service/application running on the server, which would copy data from SQL server and insert it to HFSQL server. I had a project where I just had application and it is really nice and easy. But each time server restarts, windows account is not logged in and application is not running.

I thought I need to try to run similar code in windows service, but found topics where developers gets mystic stuff with service.

How do you deal with situations when you need a service to regularly copy the data ?

Could you please share some pictures or code on how you service is working ? Something simple preferably.
What is your opinion about windev services, how reliable it is ?

How do you start your procedure periodically ?
(I would like to define time like each 10mins execute procedure)
Is it correct way doing it ? (seems this part is running each millisecond)




Thanks in advance !
#2
Membre enregistré
92 messages
Posté le 09 avril 2025 - 01:54
Windows Services works perfectly fine if written in WinDev.

Create a Windows Service App
Create your procedures that needs to run

Look at the Training (WINDEV): WD Service Example.

Kind Regards

anahoret3 a écrit :
Greetings,
Could you suggest,

The task is to have a service/application running on the server, which would copy data from SQL server and insert it to HFSQL server. I had a project where I just had application and it is really nice and easy. But each time server restarts, windows account is not logged in and application is not running.

I thought I need to try to run similar code in windows service, but found topics where developers gets mystic stuff with service.

How do you deal with situations when you need a service to regularly copy the data ?

Could you please share some pictures or code on how you service is working ? Something simple preferably.
What is your opinion about windev services, how reliable it is ?

How do you start your procedure periodically ?
(I would like to define time like each 10mins execute procedure)
Is it correct way doing it ? (seems this part is running each millisecond)




Thanks in advance !


--
Ben Dell
Riebens Computers Pty Ltd
Southern Africa PcSoft Distributor
www.windevsa.co.za
PcSoft Sales, Support and Training
#3
Membre enregistré
92 messages
Posté le 09 avril 2025 - 01:54
Windows Services works perfectly fine if written in WinDev.

Create a Windows Service App
Create your procedures that needs to run

Look at the Training (WINDEV): WD Service Example.

Kind Regards

anahoret3 a écrit :
Greetings,
Could you suggest,

The task is to have a service/application running on the server, which would copy data from SQL server and insert it to HFSQL server. I had a project where I just had application and it is really nice and easy. But each time server restarts, windows account is not logged in and application is not running.

I thought I need to try to run similar code in windows service, but found topics where developers gets mystic stuff with service.

How do you deal with situations when you need a service to regularly copy the data ?

Could you please share some pictures or code on how you service is working ? Something simple preferably.
What is your opinion about windev services, how reliable it is ?

How do you start your procedure periodically ?
(I would like to define time like each 10mins execute procedure)
Is it correct way doing it ? (seems this part is running each millisecond)




Thanks in advance !


--
Ben Dell
Riebens Computers Pty Ltd
Southern Africa PcSoft Distributor
www.windevsa.co.za
PcSoft Sales, Support and Training
#4
Membre enregistré
62 messages
Posté le 10 avril 2025 - 15:35
Hello,
as Ben said, services written in vindev works very well...
Just another solution, if you want to continue using already written applications:

use autorun to login in your profile
https://learn.microsoft.com/it-it/sysinternals/downloads/autoruns
and then start your app in shell:startup

Hope this helps
Andrea
→ Revenir à WINDEV 2024