Paradox 5 (Win) Check for emty field

#1

Hi,

Can anyone tell me how to check if field "Text" is empty (within a
query) ?

TIA

MJ

#2

MJ,

Blank

(Kind of a brief response, but should be what you need).

HTH,
Jim Moseley

#3

On Tue, 20 Mar 2007 16:29:39 +0100, question (AT) Hotmail (DOT) com wrote:

Quote:

Can anyone tell me how to check if field "Text" is empty (within a
query) ?

MJ,

Why don't you walk through the Help on queries? It'll answer pretty much
all your questions. I remember version 5 as having excellent printed
manuals as well. The query language is very simple to use once you get used
to it, and very full featured. SQL, however, is the wave of the future. If
you have Pdox version 8 or later, you can use SQL statements as well as the
original query language, and avoid learning a dead language. Pdox's current
version is 11.

Jim Hargan

#4

I have tried =BLANK but that just removes the text field value and
then it shows all the records :-S

Perhaps I should try without the "=" (but think I've allready tried
that.

When I get my fingers on the hinote again, I'll give it another go.

TIA

MJ

On 20 Mar 2007 11:02:52 -0500, "Jim Moseley"
<jmose (AT) mapson (DOT) attglobal.net> wrote:

Quote:

MJ,

Blank

(Kind of a brief response, but should be what you need).

HTH,
Jim Moseley

#5

I haven't used Paradox much (I'm more like a MS Access kind of guy)
:-)

I know it is a very old version (properly the first windows version).
But the guy doesn't have the manuals anymore and it seems that the
help wasn't installed at the time.

I have a Paradox 4 (DOS) book and that is pretty much what I have to
help me though it.

Is it possible to buy Paradox 11 as a standalone or is it only
available in the Pro version of the Office package ?

MJ

On Tue, 20 Mar 2007 12:33:33 -0400, Jim Hargan
<noJimspam (AT) omitThisHarganonline (DOT) com> wrote:

Quote:

On Tue, 20 Mar 2007 16:29:39 +0100, question (AT) Hotmail (DOT) com wrote:

Can anyone tell me how to check if field "Text" is empty (within a
query) ?

MJ,

Why don't you walk through the Help on queries? It'll answer pretty much
all your questions. I remember version 5 as having excellent printed
manuals as well. The query language is very simple to use once you get used
to it, and very full featured. SQL, however, is the wave of the future. If
you have Pdox version 8 or later, you can use SQL statements as well as the
original query language, and avoid learning a dead language. Pdox's current
version is 11.

Jim Hargan

#6

MJ,

Is this a ChangeTo query? If so, sorry about wiping out your data!

You can put in a selection criteria (-ium?) with a ChangeTo command if you
separate them with a comma.

For example, 'blank,changeto "XYZ"' or '_x, > 2000,changeto _x * 1.25'.
The first example will change any blank field to 'XYZ'. The second example
will change any value greater than 2000, increasing it by 125%.

HTH,
Jim Moseley

#7

On Thu, 22 Mar 2007 13:38:19 +0100, question (AT) Hotmail (DOT) com wrote:

Quote:

I haven't used Paradox much (I'm more like a MS Access kind of guy)
:-)

I know it is a very old version (properly the first windows version).
But the guy doesn't have the manuals anymore and it seems that the
help wasn't installed at the time.

I have a Paradox 4 (DOS) book and that is pretty much what I have to
help me though it.

Is it possible to buy Paradox 11 as a standalone or is it only
available in the Pro version of the Office package ?

Well, that explains the questions!

You are right; it's the first Windows version. The Pdox4 manual can get you
started on the query language ok, but the programming and forms changed
utterly.

Alas, Pdox can only be purchased as part of the Pro Version of WP Office.
However, you can buy older versions, which are cheaper and better, from
Steven Green:
Diamond Software Group
http://www.diamondsg.com/main.htm

Jim Hargan

#8

Quote:

You are right; it's the first Windows version.

Well, actually it's the third windows version if I recall correctly (1.0 -
4.5 - 5.0).

Not that it matter today! :-)

Anders

#9

Jim
<<
For example, 'blank,changeto "XYZ"' or '_x, > 2000,changeto _x * 1.25'.
The first example will change any blank field to 'XYZ'. The second example
will change any value greater than 2000, increasing it by 125%.

Quote:

And I have always thought that multiplying a number with 1, would increase
it with 0 %. But now I have been enlightened.

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

"Jim Moseley" <jmose (AT) mapson (DOT) attglobal.net> skrev i meddelandet
news:46027a31$1 (AT) pnews (DOT) thedbcommunity.com...

Quote:

MJ,

Is this a ChangeTo query? If so, sorry about wiping out your data!

You can put in a selection criteria (-ium?) with a ChangeTo command if you
separate them with a comma.

For example, 'blank,changeto "XYZ"' or '_x, > 2000,changeto _x * 1.25'.
The first example will change any blank field to 'XYZ'. The second
example
will change any value greater than 2000, increasing it by 125%.

HTH,
Jim Moseley

#10

On Thu, 22 Mar 2007 15:19:56 +0100, Anders Jonsson wrote:

Quote:

You are right; it's the first Windows version.

Well, actually it's the third windows version if I recall correctly (1.0 -
4.5 - 5.0).

Not that it matter today! :-)

Anders

That 1.0 to 5.0 business confused me at the time. I guess DOS was at 4.0
when Win was at 1.0, then they put them in step with 4.5.

Jim hargan