HMGforum.com

Hi all, I own visual foxpro5.
Is it possible to add the forpro library s to hmg and us some of its features.
I still am not able to use sql. I have spent hours on trying to make it work. I have gone though the posts and still do not understand.
So I keep using temporary indexes and relationships. This is not as fast as using sql which foxpro has and is very good, AND I UNDERSTAND.
Thanks in advance... Franco

A long ago watched the FoxPro, a great system, but M$ bought it and it turned out a long time ago
I think the answer is NO
With HMG you have the option to use MySQL which is a far better solution if you want to work with SQL

Hi franco

I think you want to use sql commands on dbf files, as is used in FoxPro.
If Yes, then you may open the dbf files in ODBC and use sql commands in HMG.

Regards,

Anand

There is good example in HMG Minigui version for MSSQL
location : C:\MiniGUI\SAMPLES\Advanced\MSSQL
You may get more idea

I can not make even samples work.
I am not knowledgeable in any downloading and installing after items in hmg if they are not there.
I have a table customer.dbf
what do I need to download from where and where do I put the downloads in the hmg systems
I am using win8.1 hmg3.2 and win10 hmg3.44
I would like to build a simple program like
I have a table customer.dbf with field name
francosql.prg
#include <hmg.ch>
#include <mysql.ch>

Function Main
private dbo := ' '
aTable := hmg_SQL(dbo, "select * from customer") // updated from inv error
select atable
go 1
msgbox(name)
use
delete ("atable.dbf")
return

Thanks Franco

I'm not sure I know what you need, something like a FoxPro? Yes, it was great, but it's gone, abandoned, unfortunately

If it's not a problem, upload that customer.dbf here, let's try to do what you need

Sorry I had the example wrong ... I changed inv to customer
customer table has a field called name can be any customer file with name field.

When you are working with .dbf, I suggest following
Our smart user Dragan had created excellent Quick Code generation utility
viewtopic.php?f=10&t=4170&hilit=quickgen+quick
If required change path of your HMG directory in bat file