Thanks!!!
Thanks,Bill - Your code got me started on the right track!
Thanks, JRB-Bldr - I found information that I have used to enhance the flexibility and correct an error.
I feel that I am a better programmer because of your willingness to help.
Background Info:
The program extracts data from a database for reporting on several criteria. The tables are then copied to EXCEL files. I have an EXCEL workbook that contains graphs with links to these created worksheets. Since the files with the data need to be opened before the graph...
ramani,
Thanks!! Your suggested code change works when I run the view from inside Visual Fox. I changed my code to:
SELECT *
FROM {oj PMPPD Pmppd LEFT OUTER JOIN PMDBFA.PMPPR Pmppr ;
ON Pmppd.PDSEQ = Pmppr.PRSEQ };
WHERE Pmppr.PRPOID = Pmppd.PDPOID;
AND (Pmppd.PDCO = ' 2'...
I want to pass variable from my program to a remote view.
public beg_dte_sql
beg_dte_sql = 37884
OPEN DATABASE l:\pur\dbC\por.dbc SHARED
USE POR!pur_por AGAIN IN 0
SELECT pur_por
The above remote view has the following code. As you can see, I have hard coded a value so that I don't get the...
That did it! Our standard config.fpw does not have this line of code. But you got me thinking, I checked the directory from which the program runs and found another project had created a config.fpw that had that line of code. Removing it did the trick.
Thanks!!
I should have added that the copied files did contain VFP runtimes. I will furnish the list. They were added to both c:\windows\system and c:\windows\system32 directories...
Problem running vfp6.0 application
Copied vfp6r.dll and vfp6renu.dll to c:\windows\system32
Recomplied the exe in vfp7.0.
Ran a setup.bat file --
c:
md avhdnc
f:cd f:\configfp
f:\configfp\editauto.exe
adds SET FOXPROWCFG=C:\CONFIG.FPW to c:\windows\system32\autoexec.nt
copy...
I made this change. It works GREAT when I send only one attachment. When I attempt to send two attachments in the same email, the second one attaches as a shortcut to the actual file. Due to network security, some receipents cannot read the doc.
Thanks for all the help,
DHart
Is there code that can be added to my Visual FoxPro program so that the mail server will send an email notification that the email was deliveried?
procedure deliver_mail
if empty(m.subject) .or. empty(m.text) .or. empty(m.recipient)
wait window "Missing Email Header Data... Program Will...
Recently, I received the below code as a solution to emailing word documents created in VisualFoxPro from existing reports.
Also let me say thanks to danceman, mgagnon and rgbean for their quick reponse and help.
MAPI control
with MAPIMessages1
.AttachmentIndex = 0
.AttachmentPosition = 0...
I need to send two different reports together in one email.
One report was actually a fox report that was originally printed.
The other one was really a word document. I created a database with memo fields and an input screen and a new report to accomplish the same effect without having to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.