🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.vdbase.data.sql
Article #183

2 Sql Problems

#183
From: Kris
Date: Thu, 11 Mar 1999 00:00
19 lines
1437 bytes
The first sql problem is when I create a tempory table  and link it up with
2 other tables.  When I execute the query and look for infomation in my
report there is none.  It seems that It can't find any data, yet I have
checked and double checked the conditions just to make sure that they are
right which they are.  Any help with this problem would be appreciated.

The next problem that I have is in one of my conditions.  I select
everything from a certain table which has the following conditions:

batch >= " ' + Start + ' " and batch <= " ' + end + ' " '

there is also a few more conditions but they work right.  So when I run my
query without the above condition, I get all of my data, but when I use the
condition above, I get no data showing up.  As for the values that I use for
it, I use the lowest number for the start and the highest number available.
So I should get data, but I don't.  Any help with this problem would be of
some great use too.  Thanks in advance.

Scott
Technical Details
Message-ID: <7c8okk$llc13@forums.borland.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,701822d6c568995c,start
X-Google-Attributes: gidff5a1,public
From: "Kris" <free_style @ yahoo.com>
Subject: 2 Sql Problems
Date: 1999/03/11
Message-ID: <7c8okk$llc13@forums.borland.com>
X-Deja-AN: 453831736
Organization: Another Netscape Collabra Server User
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Newsgroups: borland.public.vdbase.data.sql