foxpro libs

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

Post Reply
franco
Posts: 241
Joined: Sat Nov 02, 2013 5:42 am
DBs Used: DBF
Been thanked: 8 times

foxpro libs

Post by franco » Sun Dec 10, 2017 6:46 pm

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

User avatar
dragancesu
Posts: 535
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 11 times
Been thanked: 95 times

Post by dragancesu » Mon Dec 11, 2017 8:59 am

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

User avatar
Anand
Posts: 271
Joined: Tue May 24, 2016 4:36 pm
DBs Used: DBF
Has thanked: 50 times
Been thanked: 41 times

Post by Anand » Mon Dec 11, 2017 10:05 am

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
Image

User avatar
bpd2000
Posts: 1005
Joined: Sat Sep 10, 2011 4:07 am
Location: India
Has thanked: 154 times
Been thanked: 66 times

Post by bpd2000 » Mon Dec 11, 2017 10:10 am

There is good example in HMG Minigui version for MSSQL
location : C:\MiniGUI\SAMPLES\Advanced\MSSQL
You may get more idea
BPD
Convert Dream into Reality through HMG

franco
Posts: 241
Joined: Sat Nov 02, 2013 5:42 am
DBs Used: DBF
Been thanked: 8 times

Post by franco » Mon Dec 11, 2017 7:09 pm

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 ;)
Last edited by franco on Mon Dec 11, 2017 9:10 pm, edited 1 time in total.

User avatar
dragancesu
Posts: 535
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 11 times
Been thanked: 95 times

Post by dragancesu » Mon Dec 11, 2017 8:56 pm

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

franco
Posts: 241
Joined: Sat Nov 02, 2013 5:42 am
DBs Used: DBF
Been thanked: 8 times

Post by franco » Mon Dec 11, 2017 9:12 pm

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.

User avatar
bpd2000
Posts: 1005
Joined: Sat Sep 10, 2011 4:07 am
Location: India
Has thanked: 154 times
Been thanked: 66 times

Post by bpd2000 » Tue Dec 12, 2017 3:49 am

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
BPD
Convert Dream into Reality through HMG

Post Reply