We gotta get this guy into production or accounting - he's got too much programming time on his hands! (what I wish I could do...more programming).
(from one geek to another) Troy Funte
Liberty Electronics
(from one geek to another) Troy Funte
Liberty Electronics
----- Original Message -----
From: Winter, Patrick
To: 'vantage@yahoogroups.com'
Sent: Friday, July 13, 2001 8:46 AM
Subject: RE: [Vantage] 4GL :-P
Now you are starting to scare me. ;-)
-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Thursday, July 12, 2001 4:56 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] 4GL :-P
My dad did that once, though actually used marshmallows instead of elmers.
The trick was to cut the popsickle sticks into tiny little toothpicks, which
could be more efficiently formed into a suspension bridge.
In this case, reportbuilder was the popsicle stick, much to cumbersome for
the job. To really get the job done, I needed something on a lower level,
smaller, more efficent like a toothpick - 4GL code. The elmers glue, ODBC,
had to give way to the Marshmallows, which are outdated, yet still effective
in piecing together a report. Unfortunatly, because my dbf's contain no
indexes, a little bit of Elmers ODBC is still needed to hold the bridge
together
How's that for an analogy? :-P
-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Thursday, July 12, 2001 4:30 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] 4GL
Thad,
Next, I would like to see you to build a suspension bridge out of pop sickle
sticks and Elmer's glue.
Patrick
-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Thursday, July 12, 2001 4:14 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] 4GL
I have created my first 4GL - DBF - Crystal report.
The 4GL program creates DBF files of selected records, and launches a
compiled crystal report against the DBF. The DBF files are accessed through
the Microsoft Dbase ODBC driver, which was a pain to get working
consistently on seperate workstaions, but it can be done.
Before doing anything, start with the tutorial on the progress site, read up
on widgets record selection, and creating reports.
http://www.progress.com/v9/documentation/start.htm has the tutorial, the
Programmer Handbook, and the Language Reference. all of these will come be
useful.
The I wrote code for creating a dbf was largely derived from
http://home.kabelfoon.nl/~prvdam/white2.htm
http://www.apptools.com/dbase/faq/qformt.htm was also an excellent resource
on the DBF file format.
THIS CODE DOES NOT CREATE INDEXES!!!!! That's why it is necessary to access
the dbf files through the microsoft DBASE driver.
The included crystal report references and ODBC driver with the name of
VNTGWRK, and that driver references c:\vntgwrk.
Any dbf tables in the c:\vntgwrk directory should be readable by crystal
through this driver. This is where I had the most trouble. It seemed that
after distributing the crystal report, the dbase driver was overwritten with
an access driver that doesn't recognize dbf files. I still have to fix
that.....
I have only supplied the crystal RPT file, created in Crystal reports 7.
You will need to compile the report, and modify the exe file path at the end
of rcvnoinv.w to reference it. Also, make sure the company filter is set
right, in All 'FOR EACH' statments
All code is supplied as is, no warranties express or implied........yada
yada
The File locations are
http://groups.yahoo.com/group/vantage/files/4GL-Crystal%20rcvnoinv.zip for
the
zip file
and
http://groups.yahoo.com/group/vantage/files/4GL-Crystal%20rcvnoinv.TXT
for a copy of this message, which is the only documentation for that zip
file.
Let me know if you have any ?'s
Have Fun!!!!
Best Regards,
Thaddeus Jacobs
Assistant LAN Technologist / Vantage Support
Kinematic Automation, Inc
mailto:tjacobs@...
To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]