PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV 2024 → HFSQL and SQL Server
HFSQL and SQL Server
Débuté par Antonio Díaz, 24 fév. 2021 20:18 - 12 réponses
Membre enregistré
70 messages
Popularité : +2 (2 votes)
Posté le 24 février 2021 - 20:18
Hi, I have been using SQL Server with an app for windows developed in Clarion. I am trying to move to Windev but feel a little overwhelmed by the choices I have to make. First, I hate the fact that there is no native driver for SQL server available for free but anyway.. I am wondering if I should stay with my db or change to HFSQL (first question).

Second, if I stay with SQL Server, will I still be able to work with WINDEV Mobile and develop apps? or are there issues I should know about?

Third, could I start developing and playing around with WINDEV using the OLEDB driver for SQL Server? If so, will I be able to make the change to the native driver and still use whatever I created before?

I thank you for your help...

--

Antonio Diaz
Emphasys Software, S.C.
Posté le 24 février 2021 - 22:55
Antonio Díaz a écrit :
> Hi, I have been using SQL Server with an app for windows developed in Clarion. I am trying to move to Windev but feel a little overwhelmed by the choices I have to make. First, I hate the fact that there is no native driver for SQL server available for free but anyway.. I am wondering if I should stay with my db or change to HFSQL (first question).

HFSQL is free, and includes an automatic modification tool when you change your DB structure... So, yes, changing to HFSQL should change your life.


Second, if I stay with SQL Server, will I still be able to work with WINDEV Mobile and develop apps? or are there issues I should know about?

HFSQL is available on android, iOS, windev, webdev, everywhere.... SQL Server is... NOT. Furthermore, you can connect directly to a HFSQL server from android and iOS. You cannot do that with any other DB.

Third, could I start developing and playing around with WINDEV using the OLEDB driver for SQL Server? If so, will I be able to make the change to the native driver and still use whatever I created before?

Yes, what you code with OLEDB will work with the native driver (the inverse is not true, as the native driver adds functions that are not available in OLEDB.

Lots of people have come from clarion. You can do it too...
Membre enregistré
70 messages
Popularité : +2 (2 votes)
Posté le 25 février 2021 - 20:11
Thanks Argus, I'm starting to think there should be a group of Clarion developers that use Windev now... Anyway, I really appreciate your help...!

--

Antonio Diaz
Emphasys Software, S.C.
Posté le 25 février 2021 - 22:30
Hi Antonio

I to am an ex clarion developer. I made the move to Windev and have never looked back
MSSQL is my database of choice. I use the ole db driver. the main reason I use it is most of my clients already have MSSQL and if they don't We installed the express version,
Membre enregistré
70 messages
Popularité : +2 (2 votes)
Posté le 26 février 2021 - 14:59
Hi Kel, has it been hard to make the transition? What soft of means have you used to learn WINDEV?... Anything you could share would be much appreciated...

--

Antonio Diaz
Emphasys Software, S.C.
Membre enregistré
794 messages
Popularité : +40 (42 votes)
Posté le 26 février 2021 - 16:49
Hi. Same feeling here. I was using Clarion for 14 years (since MSDOS version and Windows version 1), I bought many interesting templates, until version 8 was released and I saw that everything was still the same and with many bugs. Then I decided to try Windev and never touched Clarion again. To try to get the most out of Windev try not to use the same techniques you used in Clarion. Windev techniques are much more flexible and advanced. Another advantage is that in Windev you have many of the clarion templates included, you don't have to pay again for them.

Rubén
Membre enregistré
70 messages
Popularité : +2 (2 votes)
Posté le 26 février 2021 - 19:59
I totally agree, Rubén. All those 3rd party products I bought are (mostly) already included in WINDEV, which is cool. I don't get an easy feeling trying to learn though, was it hard for you?...

--

Antonio Diaz
Emphasys Software, S.C.
Membre enregistré
794 messages
Popularité : +40 (42 votes)
Posté le 27 février 2021 - 00:50
You should try not to think about how you would do it with Clarion. With Windev it will always be easier. All of us who have gone from Clarion to Windev have tried to do things the same way, but later we realize that it is better not to do it.

Rubén
Posté le 28 février 2021 - 22:58
Hi
I did find it hare at first because it was a different way of thinking.
Now it I need to do something new I look in the help and it is generally pretty good.
I also look at the examples or the examples in the us site the have some great examples on you tube.
My supplier Geoff from software down under has been great if he does not know he will find out.

I cringe when I have to go back to Clarion is seems so primitive

Any help I can give I would be happy to do so.

Kel
Posté le 04 mai 2021 - 00:09
Hi i have been using MSSQl with native drive in Mobile, webdev and webdev
with no problems

I decide not to use HFSQL because no one Knows this database,
Crystal reports do not recgonize HFSQL all my reports in in Crystal Reports
If you have one application with HFSQL in your clients and he decides to buy a third party software
this client will be with a big problems

If you decide to use Microsoft Power BI, SiSens or any others on the market
with HFSQL you can not because they do not read Hfsql DataBase

att
Carlos Lages
Posté le 31 décembre 2021 - 20:40
> I'm starting to think there should be a group of Clarion developers that use Windev now

Has anyone created a group for ex-Clarionites? Or at least a Skype group? I'd be interested. I'm just looking at WinDev after 25+ years with Clarion... and I like what I see.
Membre enregistré
76 messages
Posté le 07 janvier 2022 - 16:28
Hi Frosty

https://join.skype.com/ChHzcnHCha7M - South African WX group that consists mostly of ex Clarion developers - any new developers always welcome - even if not from South Africa.

The group is mostly responsive to questions - even if the answer is - "it's in the help file - and a link to the help" :)

As time progresses, the WX questions becomes less .. until a new developer joins ... the current discussions are mostly of a programming nature ... with WX as the tools of choice...

--
Ben Dell
Riebens Computers Pty Ltd
South Africa Windev Reseller and Support
www.windevsa.co.za
Membre enregistré
3 messages
Posté le 01 mars 2022 - 17:49
SQL Server with an app for windows developed in Clarion. I am trying to move to Windev but feel a little overwhelmed by the choices I have to make. First, I hate the fact that there is no native driver for SQL server available for free but anyway.. I am wondering if I should stay with my db or change to HFSQL