Page 2 of 2
Re: System info, Tips & Tricks, scharing project info
Posted: 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
Posted: 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
Posted: 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
Posted: 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
Posted: Wed Mar 30, 2022 8:37 am
by Jimmy
hi Marc,
Aha, using ADO
Thx for Link
Re: System info, Tips & Tricks, scharing project info
Posted: Wed Mar 30, 2022 11:26 am
by Jack
Marc,
I am from Liege en spreek ook Nederlands .
Mijn mail :
ph.jacquet@skynet.bePhilippe