Search results for query: *

I did it it 2 commands like Paul said and it works. Thank you.

nope, syntax error and I need it where the table bell_lns HAVING COUNT('custno')>1 :(

Hi all, I'm having an issue with a "DELETE FROM... HAVING"... How can I make this command work please? delete * FROM bell_lns where newtob = .T. and HAVING COUNT('custno')>1 and custno in (sele custno from test1) Thanks, FOXUP

looks good, I'll give a star to zazzi and Paul. Thanks guys.

do I have to put a default value in "cast" ?

Hi All, I can't seem to remember the numeric equivalent of space () in a select. Here is my command: SELECT custno, SPACE(3) as type, SPACE(10) as bill_stat from test123 WHERE resto='5103' I need to add another field as numeric in there, so something like: SELECT custno, SPACE(3) as...

It did turn out to be the ""Save Printer Environment" in the report". I had it checked, then unchecked but never saved it. When I recreated the report it was giving me the same result so I unchecked it in the new report and it worked. Then I unchecked it in the old report and it worked...

I've tried a bunch of things and it seems to be an Adobe PDF driver bug. I'm gonna re-create the VFP Report from scratch and hopefully that'll work. I appreciate and thank everyone for your time end efforts. FOXUP

I changed the resolutions and the zoom in the system settings. My screen icons became bigger. So, I putzed around with that and unfortunately I'm getting the same result in the end :confused:

I just noticed that adobe acrobat uses it's own program to create PDF. It's called Distiller. Does that help in any way?

what should dpi be in adobe settings?

It's not a zoom level difference. It seems to be an Acrobat Print to PDF issue. It's almost like it's a driver issue :unsure:

Here is a print screen of the difference in the results:

Set it as default. PaperSize in Adobe is set to Letter and uncheck the "save printer environment" . Sadly, same result :(

Hi, I have a strange behavior in a VFP Report that I never encountered before. Basically, when I do a print to "Microsoft Print to PDF" it comes out fine. When I do a print to "Adobe PDF" it comes out enlarged/magified and it's cut off. Am I missing something. Is there a setting in print...

Hi Gerrit, I had SPF setup as DNS TXT records in the mail server. All required records (SPF, DKIM, DMARC) were setup as DNS TXT records on mail server. I hope that helps. Thanks, FOXUP

Chriss and Mike, Thank you all for your help guys. I managed to send out all the emails since we were sending less than 2,500 per day, the requirement from Google is that SPF OR DKIM (one or the other) be functional. It all worked out since I had SPF working. I did note...

OK, I just re-checked and the TLS is working. Let me check the other 2 (DMARC and SPF). I hope this works.

Hi Chriss, OK, your code: oOutlook = CreateObject("Outlook.Application") oitem=oOutlook .createitem(0) oitem.subject="Email From VFP" oitem.to="someone@example.com" oitem.body="This mail was sent from vfp using Outlook" * for HTML mail there is simply oItem.HTMLBody to put in any HTML...

What do the changes from CDO to Outlook look like exactly? Can you give me an example of what the code would look like in Outlook script? Also, which mailserver software automatically apply DKIM signing of mails?