Gray Band

"Bertil Isberg" wrote:
>Is there an answer.tv file in your pribate directory? If there is, delete

>it.
>
>--
>Bertil Isberg - CTECH
>Paradox buglist:
>online: http://hem.bredband.net/bertilisberg/
>
>"Delbert" skrev i meddelandet
>
>>
>> On Query Run, the Answer instead of being fields and records is just a

>> gray
>> band left to right, covering about half of the screen--? (Paradox 8,
>> Windows
>> SE)
>>
>
>
What is the pribate directory?
 >> Stay informed about: Gray Band 

Private Directory


--
------------------------------
Tony McGuire
 >> Stay informed about: Gray Band 

private directory = :PRIV: = the folder where the answer.db is created.

--
Bertil Isberg - CTECH
Paradox buglist:
online: http://hem.bredband.net/bertilisberg/

"Delbert" skrev i meddelandet

>
> "Bertil Isberg" wrote:
>>Is there an answer.tv file in your pribate directory? If there is, delete
>
>>it.
>>
>>--
>>Bertil Isberg - CTECH
>>Paradox buglist:
>>online: http://hem.bredband.net/bertilisberg/
>>
>>"Delbert" skrev i meddelandet
>>
>>>
>>> On Query Run, the Answer instead of being fields and records is just a
>
>>> gray
>>> band left to right, covering about half of the screen--? (Paradox 8,
>>> Windows
>>> SE)
>>>
>>
>>
> What is the pribate directory?
 >> Stay informed about: Gray Band 

"Bertil Isberg" wrote:
>private directory = :PRIV: = the folder where the answer.db is created.
>
>--
>Bertil Isberg - CTECH
>Paradox buglist:
>online: http://hem.bredband.net/bertilisberg/
>
>"Delbert" skrev i meddelandet
>
>>
>> "Bertil Isberg" wrote:
>>>Is there an answer.tv file in your pribate directory? If there is, delete
>>
>>>it

There is no answer.tv in the PRIV: folder. [The machine with the Pdox data
base is in another building and not Online or networked; going there slows
my responses.] The gray band problem is still there; I've done the Query
Run numerous times, and always get the gray band, no rows or columns.

>>>Bertil Isberg - CTECH
>>>Paradox buglist:
>>>online: http://hem.bredband.net/bertilisberg/
>>>
>>>"Delbert" skrev i meddelandet
>>>
>>>>
>>>> On Query Run, the Answer instead of being fields and records is just
a
>>
>>>> gray
>>>> band left to right, covering about half of the screen--? (Paradox 8,
>>>> Windows
>>>> SE)
>>>>
>>>
>>>
>> What is the pribate directory?
>
>
 >> Stay informed about: Gray Band 

And you are sure records are being selected?

--
Bertil Isberg - CTECH
Paradox buglist:
online: http://hem.bredband.net/bertilisberg/

"Delbert" skrev i meddelandet

>
> "Bertil Isberg" wrote:
>>private directory = :PRIV: = the folder where the answer.db is created.
>>
>>--
>>Bertil Isberg - CTECH
>>Paradox buglist:
>>online: http://hem.bredband.net/bertilisberg/
>>
>>"Delbert" skrev i meddelandet
>>
>>>
>>> "Bertil Isberg" wrote:
>>>>Is there an answer.tv file in your pribate directory? If there is,
>>>>delete
>>>
>>>>it
>
> There is no answer.tv in the PRIV: folder. [The machine with the Pdox
> data
> base is in another building and not Online or networked; going there slows
> my responses.] The gray band problem is still there; I've done the Query
> Run numerous times, and always get the gray band, no rows or columns.
>
>>>>Bertil Isberg - CTECH
>>>>Paradox buglist:
>>>>online: http://hem.bredband.net/bertilisberg/
>>>>
>>>>"Delbert" skrev i meddelandet
>>>>
>>>>>
>>>>> On Query Run, the Answer instead of being fields and records is just
> a
>>>
>>>>> gray
>>>>> band left to right, covering about half of the screen--? (Paradox 8,
>>>>> Windows
>>>>> SE)
>>>>>
>>>>
>>>>
>>> What is the pribate directory?
>>
>>
>
 >> Stay informed about: Gray Band 

"Bertil Isberg" wrote:
>And you are sure records are being selected?

The Query strip has First Name, Last Name, Company, and so on to Zip code--a
check mark in each field box. Then, when I click on Query Run I get the
the gray band, not records, though the Field names show.
>
>--
>Bertil Isberg - CTECH
>Paradox buglist:
>online: http://hem.bredband.net/bertilisberg/
>
>"Delbert" skrev i meddelandet
>
>>
>> "Bertil Isberg" wrote:
>>>private directory = :PRIV: = the folder where the answer.db is created.
>>>
>>>--
>>>Bertil Isberg - CTECH
>>>Paradox buglist:
>>>online: http://hem.bredband.net/bertilisberg/
>>>
>>>"Delbert" skrev i meddelandet
>>>
>>>>
>>>> "Bertil Isberg" wrote:
>>>>>Is there an answer.tv file in your pribate directory? If there is,
>>>>>delete
>>>>
>>>>>it
>>
>> There is no answer.tv in the PRIV: folder. [The machine with the Pdox

>> data
>> base is in another building and not Online or networked; going there slows
>> my responses.] The gray band problem is still there; I've done the Query
>> Run numerous times, and always get the gray band, no rows or columns.
>>
>>>>>Bertil Isberg - CTECH
>>>>>Paradox buglist:
>>>>>online: http://hem.bredband.net/bertilisberg/
>>>>>
>>>>>"Delbert" skrev i meddelandet
>>>>>
>>>>>>
>>>>>> On Query Run, the Answer instead of being fields and records is just
>> a
>>>>
>>>>>> gray
>>>>>> band left to right, covering about half of the screen--? (Paradox
8,
>>>>>> Windows
>>>>>> SE)
>>>>>>
>>>>>
>>>>>
>>>> What is the pribate directory?
>>>
>>>
>>
>
>
 >> Stay informed about: Gray Band 

Are you entering any criteria to limit the records returned?

If so, drop ALL criteria and run the query. Do you get any different
result?



--
------------------------------
Tony McGuire
 >> Stay informed about: Gray Band 

Delbert, your latest comment leads me to the same conclusion as Tony's..
sounds like a query where the parameters leave you with an empty answer
table.. or a query of a table that was empty to start with..

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

"Tony McGuire" wrote in message

>
> Are you entering any criteria to limit the records returned?
>
> If so, drop ALL criteria and run the query. Do you get any different
> result?
>
>
>
> --
> ------------------------------
> Tony McGuire
>
>
 >> Stay informed about: Gray Band 

"Steven Green" wrote:
>Delbert, your latest comment leads me to the same conclusion as Tony's..

>sounds like a query where the parameters leave you with an empty answer

>table.. or a query of a table that was empty to start with..
>
>--
>Steven Green - Myrtle Beach, South Carolina USA
>
>Diamond Software Group
>http://www.diamondsg.com/main.htm
>Paradox Support & Sales
>
>Diamond Sports Gems
>http://www.diamondsg.com/gemsmain.htm
>Sports Memorabilia and Trading Cards
>
>"Tony McGuire" wrote in message
>
>>
>> Are you entering any criteria to limit the records returned?
>>
>> If so, drop ALL criteria and run the query. Do you get any different

>> result?
>>
>>
>>
>> --
>> ------------------------------
>> Tony McGuire
>>
>> Tony & Steven, the database I'm working from has about 400 records, all
apparent & freely accessible.. it's a mystery to me why all this should come
up "empty." The selection I'm making from the database is for people who
get the bulletin, about 110 records.. There is a field named bul (for bulletin)
in which, at the query level, is a "b".. any record with a "b" in the bul
field gets a bulletin in the mail.. from where I sit, THE MATERIAL LOOKS
THERE, and Query Run should produce 110 labels and not a smooth gray band..
Obviously there is something wrong with what I'm doing or the way I'm thinking..
evidently the nice gray band is just saying, mister, you asked for nothing
and that's what you got, or you asked for something out of nothing, & I
can't help you do the impossible.. I appreciate the help, let's plug on..

Delbert

>
 >> Stay informed about: Gray Band 

> There is a field named bul (for bulletin) in which, at the query level, is
> a "b"..

OK.. pull up the query form.. hit the CHECK thing.. no "b" or any other
parameter.. execute the query.. do you get ALL of the records in the answer?

if so.. now go back to the query form.. type in exactly what I'm putting on
the next line

b or B

that'll capture capital B and small b.. execute the query.. do you get ALL
of the records with a B or b in the answer?


--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards
"Delbert" wrote in message

>
> "Steven Green" wrote:
>>Delbert, your latest comment leads me to the same conclusion as Tony's..
>
>>sounds like a query where the parameters leave you with an empty answer
>
>>table.. or a query of a table that was empty to start with..
>>
>>--
>>Steven Green - Myrtle Beach, South Carolina USA
>>
>>Diamond Software Group
>>http://www.diamondsg.com/main.htm
>>Paradox Support & Sales
>>
>>Diamond Sports Gems
>>http://www.diamondsg.com/gemsmain.htm
>>Sports Memorabilia and Trading Cards
>>
>>"Tony McGuire" wrote in message
>>
>>>
>>> Are you entering any criteria to limit the records returned?
>>>
>>> If so, drop ALL criteria and run the query. Do you get any different
>
>>> result?
>>>
>>>
>>>
>>> --
>>> ------------------------------
>>> Tony McGuire
>>>
>>> Tony & Steven, the database I'm working from has about 400 records, all
> apparent & freely accessible.. it's a mystery to me why all this should
> come
> up "empty." The selection I'm making from the database is for people who
> get the bulletin, about 110 records.. There is a field named bul (for
> bulletin)
> in which, at the query level, is a "b".. any record with a "b" in the bul
> field gets a bulletin in the mail.. from where I sit, THE MATERIAL LOOKS
> THERE, and Query Run should produce 110 labels and not a smooth gray
> band..
> Obviously there is something wrong with what I'm doing or the way I'm
> thinking..
> evidently the nice gray band is just saying, mister, you asked for nothing
> and that's what you got, or you asked for something out of nothing, & I
> can't help you do the impossible.. I appreciate the help, let's plug on..
>
> Delbert
>
>>
>
 >> Stay informed about: Gray Band 

Might try

b..

or even

...b..

just for demonstration purposes.



--
------------------------------
Tony McGuire
 >> Stay informed about: Gray Band 

Delbert

a) What happens if you open any table? Do you see any records or just a grey
band?

b) When you run a query and create an answer table, the Paradox statusbar
says Record 1 of 55 (number of records selected). What do you see on the
statusbar?

--
Bertil Isberg - CTECH
Paradox buglist:
online: http://hem.bredband.net/bertilisberg/

"Delbert" skrev i meddelandet

>
> "Steven Green" wrote:
>>Delbert, your latest comment leads me to the same conclusion as Tony's..
>
>>sounds like a query where the parameters leave you with an empty answer
>
>>table.. or a query of a table that was empty to start with..
>>
>>--
>>Steven Green - Myrtle Beach, South Carolina USA
>>
>>Diamond Software Group
>>http://www.diamondsg.com/main.htm
>>Paradox Support & Sales
>>
>>Diamond Sports Gems
>>http://www.diamondsg.com/gemsmain.htm
>>Sports Memorabilia and Trading Cards
>>
>>"Tony McGuire" wrote in message
>>
>>>
>>> Are you entering any criteria to limit the records returned?
>>>
>>> If so, drop ALL criteria and run the query. Do you get any different
>
>>> result?
>>>
>>>
>>>
>>> --
>>> ------------------------------
>>> Tony McGuire
>>>
>>> Tony & Steven, the database I'm working from has about 400 records, all
> apparent & freely accessible.. it's a mystery to me why all this should
> come
> up "empty." The selection I'm making from the database is for people who
> get the bulletin, about 110 records.. There is a field named bul (for
> bulletin)
> in which, at the query level, is a "b".. any record with a "b" in the bul
> field gets a bulletin in the mail.. from where I sit, THE MATERIAL LOOKS
> THERE, and Query Run should produce 110 labels and not a smooth gray
> band..
> Obviously there is something wrong with what I'm doing or the way I'm
> thinking..
> evidently the nice gray band is just saying, mister, you asked for nothing
> and that's what you got, or you asked for something out of nothing, & I
> can't help you do the impossible.. I appreciate the help, let's plug on..
>
> Delbert
>
>>
>
 >> Stay informed about: Gray Band 

"Bertil Isberg" wrote:
Delbert

a) What happens if you open any table? Do you see any records or just a grey
band?

a) I see all the records in the table, the latest count being 319. No gray
bar.

>b) When you run a query and create an answer table, the Paradox status bar
says Record 1 of 55 (number of records selected). What do you see on the
>statusbar?

b)I After filling in the checks on the Query bar and doing a Query Run I
see " 0 records" (zero records) on the status bar. When it's working right
it says 1 of about 115 records, 115 being the number of people getting a
bulletin, that is, the number of mailing labels being made to send out the
monthly bulletin. Evidently the way I do the Query doesn't order up any
records at all. In a previous post I told how I thought I was covering
all the bases for getting records. Guess I was wrong.

Delbert


>--
>Bertil Isberg - CTECH
>Paradox buglist:
>online: http://hem.bredband.net/bertilisberg/
>
>"Delbert" skrev i meddelandet
>
>>
>> "Steven Green" wrote:
>>>Delbert, your latest comment leads me to the same conclusion as Tony's..
>>
>>>sounds like a query where the parameters leave you with an empty answer
>>
>>>table.. or a query of a table that was empty to start with..
>>>
>>>--
>>>Steven Green - Myrtle Beach, South Carolina USA
>>>
>>>Diamond Software Group
>>>http://www.diamondsg.com/main.htm
>>>Paradox Support & Sales
>>>
>>>Diamond Sports Gems
>>>http://www.diamondsg.com/gemsmain.htm
>>>Sports Memorabilia and Trading Cards
>>>
>>>"Tony McGuire" wrote in message
>>>
>>>>
>>>> Are you entering any criteria to limit the records returned?
>>>>
>>>> If so, drop ALL criteria and run the query. Do you get any different
>>
>>>> result?
>>>>
>>>>
>>>>
>>>> --
>>>> ------------------------------
>>>> Tony McGuire
>>>>
>>>> Tony & Steven, the database I'm working from has about 400 records,
all
>> apparent & freely accessible.. it's a mystery to me why all this should

>> come
>> up "empty." The selection I'm making from the database is for people
who
>> get the bulletin, about 110 records.. There is a field named bul (for

>> bulletin)
>> in which, at the query level, is a "b".. any record with a "b" in the
bul
>> field gets a bulletin in the mail.. from where I sit, THE MATERIAL LOOKS
>> THERE, and Query Run should produce 110 labels and not a smooth gray

>> band..
>> Obviously there is something wrong with what I'm doing or the way I'm

>> thinking..
>> evidently the nice gray band is just saying, mister, you asked for nothing
>> and that's what you got, or you asked for something out of nothing, &
I
>> can't help you do the impossible.. I appreciate the help, let's plug
on..
>>
>> Delbert
>>
>>>
>>
>
>
 >> Stay informed about: Gray Band