Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Directing Table Subsets to .htm file
Message
De
24/03/2004 03:02:30
Kiran Bajaj
Yes Bank Ltd
Mumbai, Inde
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Directing Table Subsets to .htm file
Divers
Thread ID:
00889131
Message ID:
00889131
Vues:
59
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform