Subject Re: Preview.wfm and report printing
From trevor <bob@bob.com>
Date Wed, 01 Nov 2023 14:18:20 -0400
Newsgroups dbase.getting-started

Mervyn Bick wrote:

.
>
> Mm, it looks as if  the reportviewer object only had it's ref
 > property surfaced in dBASE Plus 2.5.  This means you can't use the
 > latest version of preview.wfm. :-(
That's not great, thanks for all your help and suggested code for temp
table.
I had already started to think on those lines and thought the following
code should work. Just a simple form with on pushbutton as a test.

function PUSHBUTTON1_onClick
                                
      q = new QUERY()    

          fdat1 = {10.09.2023}
      q.sql = 'select * from "transfers.DBF" where transfer > fdat1'
                      
      active = true
            ?q.sql      

       u = new UpdateSet()
       u.source =q.rowset
       u.destination  = "temptransfers.dbf"
        if _app.databases[1].tableExists("temptransfers.dbf" )
       u.append()
        else
        u.copy()
        endif                
    
       * save to  temptransfers.dbf                    
      return

?q.sql return the correct select, although not sure how to see the
rowset or if it exists.

I get an error with U.append() or U.copy()
"Operation not applicable both calls. The update  set() is an example
from dBase Help.
Also if I use the " save to... " I get a table but can't view it & get
corrupt table/index header.

Any insight would be helpful [ other than use my(your) sugggstion :) ]

Trevor