Help Needed for Newbie

dparisi

New Member
I am very new at using 4 GL. So far I have only written simple queries that have been run within NxTrend. My boss wants to take these queries and make them executable from an icon on the user's desktop. I have no idea where to begin. Any help will be greatly appreciated.
 
Well, you need a shortcut with some kind of Progress Call and a link to the program/query to be called.

For instance, if your Progress installation was C:\PROGRESS and you had to connect to a database using a particular PF file, say myprogram.pf and wanted to run a program/query called myquery.p, then this would be a command line for the shortcut:

C:\PROGRESS\BIN\PROWIN32.EXE -basekey "ini" -ininame "progres1.ini" -pf myprogram.pf -p myquery.p

Don't forget to set the Working Directory to be the one containing your Progress code/programs.

However, what I tend to do is to wrap these around in a little program that handles quitting to the OS so that I can use the same code in menus or as stand-alone programs.

Here, my Parameter File (runprog.pf) would be something like:
-yy 1950
-pf mydb.pf
-p runprog.p

And my database PF (db.pf) would be something like:
-db mydb -N tcp -H myhost -S mydb

The shortcut would be something like:

C:\PROGRESS\BIN\PROWIN32.EXE -basekey "ini" -ininame "progres1.ini" -pf runprog.pf -param myquery.p

or, more simply if you are not using external INI files:

C:\PROGRESS\BIN\PROWIN32.EXE -pf runprog.pf -param myquery.p

When you run this, it connects the databases from mydb.pf, starts runprog.p, takes myqeury.p as a parameter, runs myquery.p and quits back to the OS.

I hope that helps.

Simon
 

Attachments

Back
Top