Re: Printing Problem

"John" <johndipeco@rogers.com> wrote in message 
news:YEbwsm4XIHA.1308@news-server...
> My apologies for not being clear in previous attempts to explain this...
>
> Situation:  Purchase Order program created with dBase Plus 2.21 / 
> peer-to-peer network (one station used as a file server and about 10 
> workstations, all using Windows XP Pro)
>
> On occasion, when printing a purchase order, the "Printing Page
1" 
> dialogue box appears and the program freezes (... not responding).  The 
> program print for days without a problem, then out of the blue, this 
> situation happens.
>
> I have altered various settings in the BDE init with no success.  The data

> file in question contains thousands of records.  Is the "so-called
server" 
> not capable of allocating resources properly with the stated number of 
> workstations?
>
> Thank you for your assistance, in advance.


Are you creating any temp tables?

Greg Hill

I am not creating any temp tables for this printing routine.  I am using a Query
sql statement to select the items for the purchase order.

Greg Hill Wrote:

> "John" <johndipeco@rogers.com> wrote in message 
> news:YEbwsm4XIHA.1308@news-server...
> > My apologies for not being clear in previous attempts to explain
this...
> >
> > Situation:  Purchase Order program created with dBase Plus 2.21 / 
> > peer-to-peer network (one station used as a file server and about 10 
> > workstations, all using Windows XP Pro)
> >
> > On occasion, when printing a purchase order, the "Printing Page
1" 
> > dialogue box appears and the program freezes (... not responding). 
The 
> > program print for days without a problem, then out of the blue, this 
> > situation happens.
> >
> > I have altered various settings in the BDE init with no success.  The
data 
> > file in question contains thousands of records.  Is the
"so-called server" 
> > not capable of allocating resources properly with the stated number of

> > workstations?
> >
> > Thank you for your assistance, in advance.
> 
> 
> Are you creating any temp tables?
> 
> Greg Hill
> 
> 
> 

In article <Nl#yglFZIHA.1904@news-server>, johndipeco@rogers.com says...
> I am not creating any temp tables for this printing routine.  I am using a
Query sql statement to select the items for the purchase order.
> 

John,

What does that SQL statement look like?

-- 
Geoff Wass [dBVIPS]
Montréal, Québec, Canada

.|.|.|        dBASE info at http://geocities.com/geoff_wass       |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.

This is in my report form...

this.PURCHASEORDERITEMS1 = new QUERY()
   this.PURCHASEORDERITEMS1.parent = this
   with (this.PURCHASEORDERITEMS1)
      onOpen = class::ITEMS_ONOPEN
      left = 4.073
      top = 0.2708
      sql = 'select * from "purchaseorderitems.dbf" where
ponumber=:pnum and projectcode=:prjcode'
      requestLive = false
      params["pnum"] = _app.purchaseordernumber
      params["prjcode"] = _app.projcode
      active = true
   endwith

Geoff Wass [dBVIPS] Wrote:

> In article <Nl#yglFZIHA.1904@news-server>, johndipeco@rogers.com
says...
> > I am not creating any temp tables for this printing routine.  I am
using a Query sql statement to select the items for the purchase order.
> > 
> 
> John,
> 
> What does that SQL statement look like?
> 
> -- 
> Geoff Wass [dBVIPS]
> Montréal, Québec, Canada
> 
> .|.|.|        dBASE info at http://geocities.com/geoff_wass       |.|.|.
> .|.|.| ---------------------------------------------------------- |.|.|.
> .|.|.|             IT Consultant http://Geoff_Wass.com            |.|.|.

In article <$7W057SZIHA.940@news-server>, johndipeco@rogers.com says...
> This is in my report form...
> 
<snipped>


John,

Perhaps one of your your _app variables is null OR undefined.

What you could do is log information to a text file (use the FILE 
object) and record those values just before the report is instantiated.

-- 
Geoff Wass [dBVIPS]
Montréal, Québec, Canada

.|.|.|        dBASE info at http://geocities.com/geoff_wass       |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.