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
foxpro libs
Moderator: Rathinagiri
foxpro libs
All The Best,
Franco
Canada
Franco
Canada
- dragancesu
- Posts: 921
- Joined: Mon Jun 24, 2013 11:53 am
- DBs Used: DBF, MySQL, Oracle
- Location: Subotica, Serbia
Re: foxpro libs
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
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
Re: foxpro libs
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
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
Re: foxpro libs
There is good example in HMG Minigui version for MSSQL
location : C:\MiniGUI\SAMPLES\Advanced\MSSQL
You may get more idea
location : C:\MiniGUI\SAMPLES\Advanced\MSSQL
You may get more idea
BPD
Convert Dream into Reality through HMG
Convert Dream into Reality through HMG
Re: foxpro libs
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 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
Last edited by franco on Mon Dec 11, 2017 9:10 pm, edited 1 time in total.
All The Best,
Franco
Canada
Franco
Canada
- dragancesu
- Posts: 921
- Joined: Mon Jun 24, 2013 11:53 am
- DBs Used: DBF, MySQL, Oracle
- Location: Subotica, Serbia
Re: foxpro libs
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
If it's not a problem, upload that customer.dbf here, let's try to do what you need
Re: foxpro libs
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.
customer table has a field called name can be any customer file with name field.
All The Best,
Franco
Canada
Franco
Canada
Re: foxpro libs
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
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
BPD
Convert Dream into Reality through HMG
Convert Dream into Reality through HMG