Page 2 of 2

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

PostPosted: Wed Mar 30, 2022 6:31 am
by Jimmy
hi,

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

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

PostPosted: Wed Mar 30, 2022 7:35 am
by Jack
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)

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

PostPosted: Wed Mar 30, 2022 7:43 am
by Marc Venken
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

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

PostPosted: Wed Mar 30, 2022 7:49 am
by Marc Venken
Jack wrote:Hi,

Philippe (from Belgium)


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

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

PostPosted: Wed Mar 30, 2022 8:37 am
by Jimmy
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

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

PostPosted: Wed Mar 30, 2022 11:26 am
by Jack
Marc,
I am from Liege en spreek ook Nederlands .

Mijn mail : ph.jacquet@skynet.be

Philippe