Sql Problem

Thread View: borland.public.vdbase.data.sql

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by Scott Fri, 12 Mar 1999 00:00

#187

Author: Scott
Date: Fri, 12 Mar 1999 00:00

18 lines
1067 bytes

I have this SQL statement below

select  a.x_partnum, a.x_serial, a.purorder,  a.psno, a.dte_ret, b.vendnum,
c.vendor, a.val from "&history" a, purorder b, vendor c where a.purorder =
b.purorder and b.vendnum = c.vendnum and dte_ret IS NOT NULL and credit IS
NULL

When I output that to the report that I am doing I don't get any information
but when I leave out

and credit IS NULL

I get some information, but my field for credit, is null because there is
nothing in that field.  So my orginal sql statement should work but I don't
know why it doesn't.  Any help on this would be of great use.  Thanks in
advance.

Scott

Re: Sql Problem

#188

Author: Romain Strieff [TeamB]
Date: Sat, 13 Mar 1999 00:00

27 lines
1436 bytes

In article <7cbefb$o3b10@forums.borland.com>, Scott politely paraphrased 
...
> I have this SQL statement below
> 
> select  a.x_partnum, a.x_serial, a.purorder,  a.psno, a.dte_ret, b.vendnum,
> c.vendor, a.val from "&history" a, purorder b, vendor c where a.purorder =
> b.purorder and b.vendnum = c.vendnum and dte_ret IS NOT NULL and credit IS
> NULL
> 
> When I output that to the report that I am doing I don't get any information
> but when I leave out
> 
> and credit IS NULL
> 
> I get some information, but my field for credit, is null because there is
> nothing in that field.  So my orginal sql statement should work but I don't
> know why it doesn't.  Any help on this would be of great use.  Thanks in
> advance.
> 
Which table format? If used on DBF tables of level 3,4 or 5 for example, 
it will be never NULL.
-- 
Romain Strieff [dBVIPS/TeamB]
Please read this newsgroup guide below before 
posting on the private Inprise newsgroups.
http://www.inprise.com/newsgroups/guide.html
--

Re: Sql Problem

#191

Author: Scott
Date: Mon, 15 Mar 1999 00:00

8 lines
748 bytes

My tables are all in level 7.  So there is anything else I could check, that
would be great.  Thanks in advance
scott


>>
>Which table format? If used on DBF tables of level 3,4 or 5 for example,
>it will be never NULL.

Re: Sql Problem

#192

Author: Romain Strieff [TeamB]
Date: Tue, 16 Mar 1999 00:00

14 lines
859 bytes

In article <7cjjbb$20l18@forums.borland.com>, Scott politely paraphrased 
...
> My tables are all in level 7.  So there is anything else I could check, that
> would be great.  Thanks in advance
> scott
> 
First, check if there really are NULLs in the table, try:
 USE <thetable>
 set filter to credit=null 
 go top
 browse

-- 
Romain Strieff [dBVIPS]

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads