System info, Tips & Tricks, scharing project info

Re: System info, Tips & Tricks, scharing project info

Postby Jimmy » Wed Mar 30, 2022 6:31 am

hi,

Question : can FiveWin use SQL Syntax for DBF like FoxPro or Xbase++ v2.x :?:
greeting,
Jimmy
User avatar
Jimmy
 
Posts: 1732
Joined: Thu Sep 05, 2019 5:32 am
Location: Hamburg, Germany

Re: System info, Tips & Tricks, scharing project info

Postby Jack » Wed Mar 30, 2022 7:35 am

Hi,
I think SQL is very faster than DBF .
When i develop a new application, i no more use DBF tables and go to Sql .
The select instruction is very fast and it is easy to make complex query on multiple tables .
The Update instruction is also very very fast .
In network configuration it is very very fast .

Have a good day,

Philippe (from Belgium)
Jack
 
Posts: 288
Joined: Wed Jul 11, 2007 11:06 am

Re: System info, Tips & Tricks, scharing project info

Postby Marc Venken » Wed Mar 30, 2022 7:43 am

Jimmy wrote:hi,

Question : can FiveWin use SQL Syntax for DBF like FoxPro or Xbase++ v2.x :?:


I have seen code that uses DBF in combination with SQL

http://forums.fivetechsupport.com/viewtopic.php?f=3&t=26873&p=149080&hilit=FW_DBFSQLQUERY#p149080
Marc Venken
Using: FWH 23.04 with Harbour
User avatar
Marc Venken
 
Posts: 1434
Joined: Tue Jun 14, 2016 7:51 am
Location: Belgium

Re: System info, Tips & Tricks, scharing project info

Postby Marc Venken » Wed Mar 30, 2022 7:49 am

Jack wrote:Hi,

Philippe (from Belgium)


Hey Philippe, From where in Belgium ? I'm from Opglabbeek (Limburg)
Marc Venken
Using: FWH 23.04 with Harbour
User avatar
Marc Venken
 
Posts: 1434
Joined: Tue Jun 14, 2016 7:51 am
Location: Belgium

Re: System info, Tips & Tricks, scharing project info

Postby Jimmy » Wed Mar 30, 2022 8:37 am

hi Marc,
Marc Venken wrote:I have seen code that uses DBF in combination with SQL
http://forums.fivetechsupport.com/viewtopic.php?f=3&t=26873&p=149080&hilit=FW_DBFSQLQUERY#p149080

Aha, using ADO

Thx for Link
greeting,
Jimmy
User avatar
Jimmy
 
Posts: 1732
Joined: Thu Sep 05, 2019 5:32 am
Location: Hamburg, Germany

Re: System info, Tips & Tricks, scharing project info

Postby Jack » Wed Mar 30, 2022 11:26 am

Marc,
I am from Liege en spreek ook Nederlands .

Mijn mail : ph.jacquet@skynet.be

Philippe
Jack
 
Posts: 288
Joined: Wed Jul 11, 2007 11:06 am

Previous

Return to FiveWin for Harbour/xHarbour

Who is online

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