FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour System info, Tips & Tricks, scharing project info
Posts: 1772
Joined: Thu Sep 05, 2019 05:32 AM
Re: System info, Tips & Tricks, scharing project info
Posted: Wed Mar 30, 2022 06:31 AM

hi,

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

greeting,

Jimmy
Posts: 300
Joined: Wed Jul 11, 2007 11:06 AM
Re: System info, Tips & Tricks, scharing project info
Posted: Wed Mar 30, 2022 07: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)

Posts: 1487
Joined: Tue Jun 14, 2016 07:51 AM
Re: System info, Tips & Tricks, scharing project info
Posted: Wed Mar 30, 2022 07: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.08 with Harbour
Posts: 1487
Joined: Tue Jun 14, 2016 07:51 AM
Re: System info, Tips & Tricks, scharing project info
Posted: Wed Mar 30, 2022 07:49 AM
Jack wrote:Hi,

Philippe (from Belgium)


Hey Philippe, From where in Belgium ? I'm from Opglabbeek (Limburg)
Marc Venken

Using: FWH 23.08 with Harbour
Posts: 1772
Joined: Thu Sep 05, 2019 05:32 AM
Re: System info, Tips & Tricks, scharing project info
Posted: Wed Mar 30, 2022 08: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
Posts: 300
Joined: Wed Jul 11, 2007 11:06 AM
Re: System info, Tips & Tricks, scharing project info
Posted: Wed Mar 30, 2022 11:26 AM

Marc,
I am from Liege en spreek ook Nederlands .

Mijn mail : ph.jacquet@skynet.be

Philippe

Continue the discussion