Recent content by foxup

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...