Article View: borland.public.vdbase.data.sql
Article #1832 Sql Problems
From: Kris
Date: Thu, 11 Mar 1999 00:00
Date: Thu, 11 Mar 1999 00:00
19 lines
1437 bytes
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-mailShow 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