×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

HOW TO CALL VISUAL FOXPRO DATA ENTRY FORM & REPORT FORM (.SCX & . FRX ) USING AVFP program

HOW TO CALL VISUAL FOXPRO DATA ENTRY FORM & REPORT FORM (.SCX & . FRX ) USING AVFP program

HOW TO CALL VISUAL FOXPRO DATA ENTRY FORM & REPORT FORM (.SCX & . FRX ) USING AVFP program

(OP)

Hi Sir/Madam,

I have a process program developed from visual foxpro form(.SCX)& Report form (.frx), I just want to know if these form/report is possible to run in URL/iexplorer calling from ActiveVFP/HTML front-end main screen. do you have sample script how to call .scx & .frx using AVFP program.


Please help me. Thanks


RE: HOW TO CALL VISUAL FOXPRO DATA ENTRY FORM & REPORT FORM (.SCX & . FRX ) USING AVFP program

With ActiveVFP you're able to run VFP code, but think extremely simple about it: When a web server receives a request, it mainly has to response with HTML.

ActiveVFP is not for running SCXes. That's not the goal of ActiveVFP, it mainly has to respond with that HTML and secondary it provides images or downloads that HTML references, but that's then done by the web server, you only provide the HTML and maybe Javascript for interactivity.

Your VFP code can do anything non-interactive that includes running a report TO PRINTER without preview, but you need a printer driver installed server-side and the printout also is there, so the only relevant mode would be printing to file, especially PDF and then providing that as result to a client-side user/browser. In the form of HTML providing a download link to that PDF, for example.

The usual way to reuse an application 1:1 as is without anything else is going terminal server. That needs no preprocessing/converting/migrating your VFP code of any kind, you can run your EXE, but you give access to users, they actually log in to desktop sessions running on that terminal server. It takes licenses and usually is a solution for remote work or home office, so for trusted users.

Taking your PJX and turning it into something working on the web is the topic of vfp2iis or foxincloud instead.

Bye, Olaf.

Olaf Doschke Software Engineering
https://www.doschke.name

RE: HOW TO CALL VISUAL FOXPRO DATA ENTRY FORM & REPORT FORM (.SCX & . FRX ) USING AVFP program

(OP)
Hi All,

I have script/program code successfully running(.scx), even converted to prg file was successfully running.
My requirement is I need to include this codes to my html script to be run once I click the option menu in the html script, how can I call these codes from html script.
Can you please help me how can I convert or include these codes to my html front-end option menu. I am now started to learn html scripting, can you share me your samples code running in html using vfp iis, ActiveVFP, IIS7 etc.

---here is my SCREEN design and codes below---

TEXTBOX -- displayed path/folder upon clicking COMMAND BUTTON1 --- with codes to read the files from
target folder

COMMAND BUTTON2 - to read and append all text files to one dbf file

--------------------------------------------
CODES IN COMMAND BUTTON1 AND COMMAND BUTTON2

COMMAND BUTTON1:
PUBLIC mImportTXTFiles,McImportDir,MaryDir,cTXTFile
* --- Get the Import Directory ---
use elixirtabl
append blank
zap
McImportDir = GETDIR()
thisform.Text1.VALUE = McImportDir
* --- Now use it to find the individual TXT files in that directory ---
DIMENSION MaryDir(1)
mImportTXTFiles = ADIR(MaryDir, ADDBS(McImportDir) + "*.txt")
cImportTXTFiles = mImportTXTFiles

------------------------------------

COMMAND BUTTON2:
local cTXTFile
cImportTXTFiles = (mImportTXTFiles)
cImportDir = (McImportDir)
aryDir = (MaryDir)
xtname = space(22)
x = space(8)
z = space(8)
dd = space(2)
mm = space(2)
yy = space(4)
IF cImportTXTFiles > 0
* --- Cycle through the 'found' txt files and Append Each one separately ---
FOR nFileCntr = 1 TO cImportTXTfiles
cTXTFile = ADDBS(cImportDir) + maryDir(nFileCntr,1)
SELECT elixirtabl && The recipient DBF table
* --- Now Import that Specific File ---
y=cTXTfILE

xtname = right(cTXTFILE,21)

x=substr(xtname,1,8)
Z=substr(xtname,10,8)

yy = substr(xtname,10,4)
mm = substr(xtname,14,2)
dd = substr(xtname,16,2)
zdate = trim(dd)+"-"+trim(mm)+"-"+trim(yy) && original

xdate =ctod(mm+"/"+dd+"/"+yy)
smon = cmonth(xdate)
xsmon = substr(smon,1,3)
Yzdate =trim(dd)+"-"+trim(xsmon)+"-"+trim(yy)

set talk on
if (cTXTfILE) <> " "
append blank
replace column1 with 'Bank_'
replace column2 with ": "+alltrim(x)
replace termnum with alltrim(x)
replace tran_date with alltrim(Yzdate)
APPEND FROM (cTXTFile) type sdf
endif
?aryDir
ENDFOR
ENDIF
CLEAR
DO prg_ejtermi && Calling the module program



Thanks, Highly appreciate your response..



RE: HOW TO CALL VISUAL FOXPRO DATA ENTRY FORM & REPORT FORM (.SCX & . FRX ) USING AVFP program

That's not possible to run neither in a browser nor in server side ActiveVFP.

You can run VFP code only server side and it can't be interactive, it just can create HTML code that then is interactive.

And I see no easy migration tool to convert SCREEN PRG code to HTML&JS.

Indeed Fox In Cloud will take a project with an SCX in it to convert it to HTML&JS code and server side logic that can run, but not a PRG you create from an SCX.

Bye, Olaf.

Olaf Doschke Software Engineering
https://www.doschke.name

RE: HOW TO CALL VISUAL FOXPRO DATA ENTRY FORM & REPORT FORM (.SCX & . FRX ) USING AVFP program

(OP)
Hi Olaf,
you mean that these code are only possible to run in a browser if we're using Foxincloud /Foxweb/ VFP2IIS, So no available tools use for conversion of scx/prg to html code? even there were many useful tools, functions ,commands in the xbase programming language.

RE: HOW TO CALL VISUAL FOXPRO DATA ENTRY FORM & REPORT FORM (.SCX & . FRX ) USING AVFP program

>no available tools use for conversion of scx/prg to html code?

You listed the available tools to do so, mainly FoxInCloid and VFP2IIS. FoxWeb is just like ActiveVFP a tool that allows to run some noninteractive code serverside and redo the interaface in HTML.

I don't see anything that converts the very specific type of interactions a screen PRG is with it's defined steps of sequentialiszing the workflow to HTML at all.

As you say you have an SCX I would go to FoxInCloud or VFP2IIS and try it there.

Bye, Olaf.

Olaf Doschke Software Engineering
https://www.doschke.name

RE: HOW TO CALL VISUAL FOXPRO DATA ENTRY FORM & REPORT FORM (.SCX & . FRX ) USING AVFP program

(OP)

HI Sir/Ma'am,

I have downloaded vfp2iis installer and i installed on my local pc but when I run the scx prg using internet explorer got an error messages "HTTP Error 404.0 - Not Found The resource you are looking for has been removed".

just want to know if downloaded installer files are incompleted. can you please help me how to configure and run given sample program/scx/pjx from vfp2iss installer or how to call visual foxpro data entry form in the internet explorer/browser using VFP2IIS

see the ff. installed files/folder appeared on drive c after installing VFP2IIS. Can you please explain if installer is not completed or guide me how to test run sample demo programs inside the installed files.

C:\vfp2iis\
apps folder contains more sample forms and demo programs
complus folder
web folder
gdiplus.dll
msvcr71.dll
vfp2iis.dll
vfp2iis.tlb
vfp2iis.vbr
vfp9r.dll
VFP9RENU.dll
vfp9t.dll



Thanks. your support will be most appreciated.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close