foxpro libs

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

Post Reply
franco
Posts: 816
Joined: Sat Nov 02, 2013 5:42 am
DBs Used: DBF
Location: Canada

foxpro libs

Post by franco »

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
All The Best,
Franco
Canada
User avatar
dragancesu
Posts: 920
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: foxpro libs

Post by dragancesu »

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: 595
Joined: Tue May 24, 2016 4:36 pm
DBs Used: DBF

Re: foxpro libs

Post by Anand »

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
Regards,

Anand

Image
User avatar
bpd2000
Posts: 1207
Joined: Sat Sep 10, 2011 4:07 am
Location: India

Re: foxpro libs

Post by bpd2000 »

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: 816
Joined: Sat Nov 02, 2013 5:42 am
DBs Used: DBF
Location: Canada

Re: foxpro libs

Post by franco »

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.
All The Best,
Franco
Canada
User avatar
dragancesu
Posts: 920
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: foxpro libs

Post by dragancesu »

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: 816
Joined: Sat Nov 02, 2013 5:42 am
DBs Used: DBF
Location: Canada

Re: foxpro libs

Post by franco »

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.
All The Best,
Franco
Canada
User avatar
bpd2000
Posts: 1207
Joined: Sat Sep 10, 2011 4:07 am
Location: India

Re: foxpro libs

Post by bpd2000 »

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