Export query results (not a report) as HTML?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Internetdomainowner@hotmail.com - 27 Jul 2008 03:22 GMT

Whats the command to export the results of a query as a HTML page? I
can do it by clicking "FILE" --> "SAVE AS HTML" but I want to setup a
real simple program to query and spit out a *.html file... any ideas?

Reply to this Message

Claude Fox - 27 Jul 2008 16:43 GMT

GenHTML.Prg is the prg that is run when you take that option. You can run
it manually like:
DO GenHTML With lcHTMLFileName, lcTableName

ActiveVFP -www.activevfp.com
Free, Open Source VFP Web Development

> Whats the command to export the results of a query as a HTML page? I
> can do it by clicking "FILE" --> "SAVE AS HTML" but I want to setup a
> real simple program to query and spit out a *.html file... any ideas?

Reply to this Message

Internetdomainowner@hotmail.com - 28 Jul 2008 14:57 GMT

> GenHTML.Prg is the prg that is run when you take that option. You can run
> it manually like:
[quoted text clipped - 10 lines]
>
> - Show quoted text -

Thank you for your responce.. however, I'm still lost...

Here is my code below...

Select * from parts.dbf where alltrim(partno)=="12345" and
alltrim(itemstatus)<>"X"

Copy to "C:\Results.htm" type htm (? -- not sure what would go here
but your telling me it should be)

DO GenHTML With lcHTMLFileName, lcTableName

What is IcHTMLFileName? What is IcTableName?

Thanks so much!

Reply to this Message

Bernhard Sander - 28 Jul 2008 16:28 GMT

Hi Internetdomainowner

> DO GenHTML With lcHTMLFileName, lcTableName
>
> What is IcHTMLFileName? What is IcTableName?

Start your VFP IDE
Enter this command in the command window:
MODIFY COMMAND genhtml
Have a look at the parameter description

Regards
Bernhard Sander

Reply to this Message

Dan Freeman - 28 Jul 2008 16:44 GMT

Take out the COPY TO. Nobody told you to do that.

SELECT into cursor
DO Genhtml with ....

That's all.

Dan

> Thank you for your responce.. however, I'm still lost...
>
[quoted text clipped - 11 lines]
>
> Thanks so much!

Reply to this Message