Yes Andy ! The code you provided worked fine in my program.
Mike Lewis: SET PRINTER TO GETPRINTER() just let me choose
the printer but it didn't send anything to the printer !
Thank you all,
Cadeira
Ok Andy, I'll try the commands above.
But could anyone tell me why, the program doesn't obey the chosen printer in the window open with SET DEVICE TO PRINTER PROMPT command ?
It seems to be a bug in VFP 9 !
Thank you.
Cadeira
Dear colleagues:
The program bellow is working correctly if I choose the default printer, but if a choose another printer in the network, it doesn't obey ! It prints in the default printer !
What can be done for the program bellow to really obey the user choice (another network printer) ...
Yes !
It worked properly now with Mike response ("That command requires SET ENGINEBEHAVIOR 70 ...")
Danfreeman had also told me to use it but unfortunatelly I'd changed other commands and got in errors because of other command errors. Lesson learned: Always keep original code when...
Andy:
I think I removed the comma from wrong place. Now I did what you advised me. These are the commands now:
SELECT ;
BILHETES.TKCCLI AS XCODCLI, ;
BILHETES.TKNPOP AS XNOMCLI, ;
BILHETES.TKCIDA AS XCIDCLI, ;
BILHETES.TKSIGL AS XSIGCIA, ;
SUM(BILHETES.TKTRBR) AS...
Good morning !
I did it Andy, so the commands in the programs are exactly:
SELECT ;
BILHETES.TKCCLI AS XCODCLI, ;
BILHETES.TKNPOP AS XNOMCLI, ;
BILHETES.TKCIDA AS XCIDCLI, ;
BILHETES.TKSIGL AS XSIGCIA, ;
SUM(BILHETES.TKTRBR) AS XVRTARI, ;
SUM(BILHETES.TKGCBR) AS...
Please note that in the lines:
WHERE (BILHETES.TKSTAT = "1" OR BILHETES.TKSTAT = "5") ;
AND CLIENTES.CCODI = BILHETES.TKCCLI ;
AND CLIENTES.CNPOP = BILHETES.TKNPOP ;
AND BETWEEN (BILHETES.TKDEMI, YDATAPRI, YDATAULT) ;
the terms 'AND' above do not is exhibited in BLUE color !(as...
Dear Andy:
I removed the comma you pointed, so these are the lines copied from the program:
SELECT ;
BILHETES.TKCCLI AS XCODCLI, ;
BILHETES.TKNPOP AS XNOMCLI, ;
BILHETES.TKCIDA AS XCIDCLI, ;
BILHETES.TKSIGL AS XSIGCIA, ;
SUM(BILHETES.TKTRBR) AS XVRTARI, ...
Dear Stewart:
I inserted the missing comma you pointed above, and also removed SET ENGINEBEHAVIOR 70.
So these lines are from the program:
SELECT ;
BILHETES.TKCCLI AS XCODCLI, ;
BILHETES.TKNPOP AS XNOMCLI, ;
BILHETES.TKCIDA AS XCIDCLI, ;
BILHETES.TKSIGL AS XSIGCIA, ...
Hi Danfreeman:
I used the command SET ENGINEBEHAVIOR 70 in the program, but now other error appeared in the same last line:
"Command contains unrecognized phrase/keyword "
Thank you.
Cadeira
Hello !
These commands used to work in VFP 6, but it is not working in VFP 9:
It breaks in the last line (INTO TABLE TEMPRENT) and presents the error: "Command is missing required clause"
(Exactly the same commands copied from program:)
SELECT ;
BILHETES.TKCCLI AS XCODCLI, ...
gfrlaser:
If you are a legal owner of FoxPro 2.60 you can use a copy of it from:
http://www.mmc.edu.cn/down/
I downloaded it and it works fine !
Addictionally, Microsoft has a patch for FoxPro 2.60 at:
http://support.microsoft.com/kb/102893
Please let me know if you got it OK.
Good luck...
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.