Recent content by allserve

I create a procedure where I set a printer for special documents, but the print-output will not change to an other printer as my default printer. It founds the criteria, but nothing happens to my printer settings. What do I wrongly? proc SetSpecialPrinter lnprinters = Aprinters(laPrinters) If...

Please let me know how to use: Visual Foxpro V7 OLE automation MailMerge in Office XP MS-Word instead of Office 2000 MS-Word On which URL site's can we find the correct OLE methods for OFFICE XP, so that we can use Mailmerge All works fine with Office 2000 and older, but gives problems with...

Error in following code set fields to ; fieldname1 , ; LOOKUP(tab1.descr, tab2.code, tab1.code) as Description, ; fieldname2, ; fieldname3 COPY TO xxxxxxxxx TYPE XL5 set fields to We got every time the following error for the LOOKUP()function "Invalid use of a Visual Foxpro function as...

Pete, you say as alternative: "sending the report output to file instead. " Yes that sounds like what we need. What we have found in the Help is that you can save a spool file for later printing. However we are not interested in the report layout, we just want to have all the...

It is indeed the last. All Fields also from the other tables because the cursor only contains for the user meaningless keys to be able to retrieve the real data from the other tables. I'm sorry but when you say: "I'd just save the query string instead" what code do you...

Pete, we have a cursor, not a table and it is related to fields from other tables thru the relations but this is not active earlier than in the report itself. How can we use the COPY TO in this case? Marcel AllServe

Ramani Thanks! So is it a good working method always to create a view first and always make reports only from views? This also solves another problem we had: To change our report field definition we had to go to diferent tables and when a field was changed we could not see which it was and...

Hi colleague, I have following VFP code. This is the end of filter steps. We keep the project keys in cursor crsTemp7. Then we set relations to the other tables to find other fields and call the breport. Our wish is now to store all the fields that are used on the report (or even all the...

35 / 55 gives results 0.62 Set decimal to 4 Str(34 / 55) gives results 1 How to solve this?