Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Directing Table Subsets to .htm file
Message
From
24/03/2004 03:02:30
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Directing Table Subsets to .htm file
Miscellaneous
Thread ID:
00889131
Message ID:
00889131
Views:
58
Hi !!

Objective - to direct a subset of a table into an HTML file.

Can someone help on the below piece of code - is something wrong with the approach. Are there better ways to do this.

Have been using _genhtml.prg to redirect contents(subset of the table) to an .htm file.
Have used code generated by the Wizard

Code Start

* -- Generated Web Wizard Script File --
*
* A unique record has been created in GENHTML.DBF with your settings.
* This record can be referenced by the ID specified in the
* DO (GENHTML) command below.

LOCAL lnSaveArea
lnSaveArea=SELECT()
SELECT 0

SELECT Report FROM "G:\UTIMF\TEST.DBF" ;
INTO CURSOR webwizard_query

IF EMPTY(_GENHTML)
_GENHTML='GenHTML.PRG'
ENDIF
DO (_GENHTML) WITH "G:\UTIMF\SAN.HTM",ALIAS(),2,,"_16S133SU1"
IF USED("webwizard_query")
USE IN webwizard_query
ENDIF
SELECT (lnSaveArea)
set safe on

Code End

This piece of code returns an error - "File _runcodeerror.prg' does not exist".
Upon clicking on IGNORE - shows up further on the error - _htmltable, Error - 1, Method - runcode, Line 3. occurs.

Rgds,

KB
Next
Reply
Map
View

Click here to load this message in the networking platform