Query not picking up records

Marten

unread,

Aug 31, 2004, 12:52:29 PM8/31/04

to corel.wpoffice.paradox-old_version

This is in Paradox 7/32. I think I know what has happened but I would
like to confirm it.

I have a form that generates thank you form letters. Suddenly it has
decided not to continue doing what it had done before. On the form is
a picklist from which I pick a name to generate a letter to be sent
to. That name is passed to a query:

q= query
answer: :priv:QRYmemoryletter.DB

This then calls a print process to print from the query's table. Am I
correct that if ~memselect contains a comma, such as "Last, First"
(without quotes), then the query won't find the match?

Marten

Dennis Santoro

unread,

Aug 31, 2004, 12:56:58 PM8/31/04

to corel.wpoffice.paradox-old_version

It will treat the comma as an and and the names as separate conditions.

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and non-profits
since 1982

Steven Green

unread,

Aug 31, 2004, 1:05:21 PM8/31/04

to corel.wpoffice.paradox-old_version

Marten wrote:

> Am I correct that if ~memselect contains a comma, such as "Last, First"
> (without quotes), then the query won't find the match?

yes.. and the way to get around that is to put it all in quotes.. then
it's treated as an alpha string, no matter what it contains..

a simple example.. you want all the people in Oregon.. so you type into
the [State] field in the query

OR

and it goes "or what?" <g>.. so you type in

"OR"

and it works..

--
Steven Green - Waldorf Maryland USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales - Corel CTech Paradox
---------------------------------------------------
Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Trading Cards and other Sports Memorabilia
---------------------------------------------------

Marten

unread,

Aug 31, 2004, 4:24:06 PM8/31/04

to corel.wpoffice.paradox-old_version

On Tue, 31 Aug 2004 13:05:21 -0400, Steven Green
<gre...@diamondsg.com> wrote:

>yes.. and the way to get around that is to put it all in quotes.. then
>it's treated as an alpha string, no matter what it contains..
>

Thanks for the reply.

Can I use something to the effect of: memselect = """ + memselect +
""" (or whatever the proper /n syntax is to embed the quote) and
then use ~memselect in the query to get the quotes in use?

Marten

Steven Green

unread,

Aug 31, 2004, 4:27:40 PM8/31/04

to corel.wpoffice.paradox-old_version

Marten wrote:

> Can I use something to the effect of: memselect = """ + memselect +
> """ (or whatever the proper /n syntax is to embed the quote) and then
> use ~memselect in the query to get the quotes in use?

yes.. you use the backslash to tell pdox that a backslash or quote is part
of the string.. like this..

"\"" + whatever + "\""

Marten

unread,

Aug 31, 2004, 4:37:01 PM8/31/04

to corel.wpoffice.paradox-old_version

Thanks for the confirmation. I'm going to write a filter for the
input field. What other characters should be avoided?

Marten

Steven Green

unread,

Aug 31, 2004, 4:52:30 PM8/31/04

to corel.wpoffice.paradox-old_version

Marten wrote:

> I'm going to write a filter for the input field.

to trap for the commas and stuff? then just wrap it all in quotes all the
time, so you don't have to worry about it..

> What other characters should be avoided?

you always have to treat backslashes and quotes like I showed you, in any
string context.. that's what the "double-backslash" is when you're using
directory names..