It is important to always give the destination filename a ".pdf" extension, otherwise 4D may spool the file to a printer, regardless of SET PRINT OPTION command.

For example:

SET PRINT OPTION(Destination option;3;"MyDisk:MyFolder:myfile") PRINT RECORD([MYTABLE];*)

The above code will try to print on printer.

However the following code that includes the .pdf extension in the destination filename...

SET PRINT OPTION(Destination option;3;"MyDisk:MyFolder:myfile.pdf") PRINT RECORD([MYTABLE];*)

...will create a PDF file on disk.