Hi All,
Have come across something weird and am after some help.
Say i run this query where rec_id is a column of table arlhrl,
select * from arlhrl where rec_id >= 14260
This returns to me 2 records with rec_id's of 14260 and 14261
Then I run this query
select * from arlhrl where rec_id >= 14263
This returns 7 records with rec_ids of 14263 up.
How come the first query doesn't return the records returned by the
2nd query also?
If I select for 14262 no records are returned. It is like this is a
phantom record or has an end of file character in it.
I tried re-creating the indexes but to no avail. If anyone has any
ideas about what could be causing it or how to fix it it would be much
appreciated.
Thanks in advance,
Andrew 5 2623
Andrew wrote: Hi All,
Have come across something weird and am after some help.
Say i run this query where rec_id is a column of table arlhrl,
select * from arlhrl where rec_id >= 14260
This returns to me 2 records with rec_id's of 14260 and 14261
Then I run this query
select * from arlhrl where rec_id >= 14263
This returns 7 records with rec_ids of 14263 up.
How come the first query doesn't return the records returned by the 2nd query also?
If I select for 14262 no records are returned. It is like this is a phantom record or has an end of file character in it.
I tried re-creating the indexes but to no avail. If anyone has any ideas about what could be causing it or how to fix it it would be much appreciated.
Thanks in advance,
Andrew
Hi,
First, stupid question - is the field 'rec_id' of integer type?
Why i am asking is because i had a similar example myself when i started with my new job - i was
quering an id field and got weird results as you do. Then i found that some 'smart ass' made this
comlumn a varchar for no reason - just because she was doing like that in Access all the time before :)
Second, what i'd do when i get into an unexplainable glitch:
SELECT * INTO <new table> FROM <your table>
And try to query the records from the new table without setting any indexes - just as is - as you
know SELECT INTO just copies raw data without any underlying stuff.
See what you'll get.
From my experience there are a of of people who are allowed to mess with SQL databases but don't
have a clue what they are doing, and when you start using their 'smart ideas' sometimes it's just
hard to follow their logic :) So maybe some setting were set a wrong way somewhere, you can never
imagine what another person could do - believe me, i just got quite a few awsome examples within the
last month since i got this job :)
Let me know how it works!
Andrey
Andrey <le*******@yaho o.com> wrote in message news:<7wt3d.787 69$D%.11878@att bi_s51>... Andrew wrote: Hi All,
Have come across something weird and am after some help.
Say i run this query where rec_id is a column of table arlhrl,
select * from arlhrl where rec_id >= 14260
This returns to me 2 records with rec_id's of 14260 and 14261
Then I run this query
select * from arlhrl where rec_id >= 14263
This returns 7 records with rec_ids of 14263 up.
How come the first query doesn't return the records returned by the 2nd query also?
If I select for 14262 no records are returned. It is like this is a phantom record or has an end of file character in it.
I tried re-creating the indexes but to no avail. If anyone has any ideas about what could be causing it or how to fix it it would be much appreciated.
Thanks in advance,
Andrew
Hi,
First, stupid question - is the field 'rec_id' of integer type? Why i am asking is because i had a similar example myself when i started with my new job - i was quering an id field and got weird results as you do. Then i found that some 'smart ass' made this comlumn a varchar for no reason - just because she was doing like that in Access all the time before :)
Second, what i'd do when i get into an unexplainable glitch:
SELECT * INTO <new table> FROM <your table>
And try to query the records from the new table without setting any indexes - just as is - as you know SELECT INTO just copies raw data without any underlying stuff. See what you'll get. From my experience there are a of of people who are allowed to mess with SQL databases but don't have a clue what they are doing, and when you start using their 'smart ideas' sometimes it's just hard to follow their logic :) So maybe some setting were set a wrong way somewhere, you can never imagine what another person could do - believe me, i just got quite a few awsome examples within the last month since i got this job :)
Let me know how it works!
Andrey
Hi Andrey,
Thanks for your reply. I tried as you mentioned, inserting into new
table etc but to no avail. I did figure out what the problem was
though.
This particular table had been upsized from a foxpro table. One of the
columns in the foxpro table had a maximum value of numeric 9999.
Somehow, someone had tried to insert a value large than this so foxpro
put in ****. On the upsize, and I can only assume here, sql must have
thought 'hang on, you must mean infinity here' and put a bit-wise
pattern (1.#INF) for infinity into this particular column for the
record.
This only became evident when using Enterprise Manager and returning
all rows on the given table, it did display the record with the value
1.#INF in the column for the 'missing' record. As to why it displayed
in EM and not Query Analyser is anyone's guess, but surely the queries
that led me to this initial discovery shouldn't have behaved like
this!!??
posting http://groups.google.com/groups?q=%2...gle.com&rnum=1
gives some ideas.
Thanks anyway,
Andrew
Andrew wrote: Andrey <le*******@yaho o.com> wrote in message news:<7wt3d.787 69$D%.11878@att bi_s51>...
Andrew wrote:
Hi All,
Have come across something weird and am after some help.
Say i run this query where rec_id is a column of table arlhrl,
select * from arlhrl where rec_id >= 14260
This returns to me 2 records with rec_id's of 14260 and 14261
Then I run this query
select * from arlhrl where rec_id >= 14263
This returns 7 records with rec_ids of 14263 up.
How come the first query doesn't return the records returned by the 2nd query also?
If I select for 14262 no records are returned. It is like this is a phantom record or has an end of file character in it.
I tried re-creating the indexes but to no avail. If anyone has any ideas about what could be causing it or how to fix it it would be much appreciate d.
Thanks in advance,
Andrew
Hi,
First, stupid question - is the field 'rec_id' of integer type? Why i am asking is because i had a similar example myself when i started with my new job - i was quering an id field and got weird results as you do. Then i found that some 'smart ass' made this comlumn a varchar for no reason - just because she was doing like that in Access all the time before :)
Second, what i'd do when i get into an unexplainable glitch:
SELECT * INTO <new table> FROM <your table>
And try to query the records from the new table without setting any indexes - just as is - as you know SELECT INTO just copies raw data without any underlying stuff. See what you'll get. From my experience there are a of of people who are allowed to mess with SQL databases but don't have a clue what they are doing, and when you start using their 'smart ideas' sometimes it's just hard to follow their logic :) So maybe some setting were set a wrong way somewhere, you can never imagine what another person could do - believe me, i just got quite a few awsome examples within the last month since i got this job :)
Let me know how it works!
Andrey
Hi Andrey,
Thanks for your reply. I tried as you mentioned, inserting into new table etc but to no avail. I did figure out what the problem was though.
This particular table had been upsized from a foxpro table. One of the columns in the foxpro table had a maximum value of numeric 9999. Somehow, someone had tried to insert a value large than this so foxpro put in ****. On the upsize, and I can only assume here, sql must have thought 'hang on, you must mean infinity here' and put a bit-wise pattern (1.#INF) for infinity into this particular column for the record.
This only became evident when using Enterprise Manager and returning all rows on the given table, it did display the record with the value 1.#INF in the column for the 'missing' record. As to why it displayed in EM and not Query Analyser is anyone's guess, but surely the queries that led me to this initial discovery shouldn't have behaved like this!!??
posting
http://groups.google.com/groups?q=%2...gle.com&rnum=1
gives some ideas.
Thanks anyway,
Andrew
Well, EM and QA might show you diferent results because they are using diferent methods of 'talking'
to sql server.
QA is using isql.com, precisely it's isqlw.com version, which is an old DB lib based way of connection.
EM, i guess, is using ODBC or OLEDB connection.
I also had a headache not long time ago, when i used sql console tools to make Python work with sql
server. I had a table with varcha fields which had around couple thousand characters of text each.
When i used isql.com to retreive those text records, text returned truncated, around 300 to 600
characters left.. SO i started using osql.com instead, and no headache.
So resume is - every time you're in doubt, use both EM and QA
PS. BTW, I didn't know sql server can store 'infinity' values. Thanks for the info!
WYGL,
Andrey
Andrew wrote: Andrey <le*******@yaho o.com> wrote in message news:<7wt3d.787 69$D%.11878@att bi_s51>...
Andrew wrote:
Hi All,
Have come across something weird and am after some help.
Say i run this query where rec_id is a column of table arlhrl,
select * from arlhrl where rec_id >= 14260
This returns to me 2 records with rec_id's of 14260 and 14261
Then I run this query
select * from arlhrl where rec_id >= 14263
This returns 7 records with rec_ids of 14263 up.
How come the first query doesn't return the records returned by the 2nd query also?
If I select for 14262 no records are returned. It is like this is a phantom record or has an end of file character in it.
I tried re-creating the indexes but to no avail. If anyone has any ideas about what could be causing it or how to fix it it would be much appreciate d.
Thanks in advance,
Andrew
Hi,
First, stupid question - is the field 'rec_id' of integer type? Why i am asking is because i had a similar example myself when i started with my new job - i was quering an id field and got weird results as you do. Then i found that some 'smart ass' made this comlumn a varchar for no reason - just because she was doing like that in Access all the time before :)
Second, what i'd do when i get into an unexplainable glitch:
SELECT * INTO <new table> FROM <your table>
And try to query the records from the new table without setting any indexes - just as is - as you know SELECT INTO just copies raw data without any underlying stuff. See what you'll get. From my experience there are a of of people who are allowed to mess with SQL databases but don't have a clue what they are doing, and when you start using their 'smart ideas' sometimes it's just hard to follow their logic :) So maybe some setting were set a wrong way somewhere, you can never imagine what another person could do - believe me, i just got quite a few awsome examples within the last month since i got this job :)
Let me know how it works!
Andrey
Hi Andrey,
Thanks for your reply. I tried as you mentioned, inserting into new table etc but to no avail. I did figure out what the problem was though.
This particular table had been upsized from a foxpro table. One of the columns in the foxpro table had a maximum value of numeric 9999. Somehow, someone had tried to insert a value large than this so foxpro put in ****. On the upsize, and I can only assume here, sql must have thought 'hang on, you must mean infinity here' and put a bit-wise pattern (1.#INF) for infinity into this particular column for the record.
This only became evident when using Enterprise Manager and returning all rows on the given table, it did display the record with the value 1.#INF in the column for the 'missing' record. As to why it displayed in EM and not Query Analyser is anyone's guess, but surely the queries that led me to this initial discovery shouldn't have behaved like this!!??
posting
http://groups.google.com/groups?q=%2...gle.com&rnum=1
gives some ideas.
Thanks anyway,
Andrew
And how did you get rid of that infinity value in the in field?
I got rid of the infinity value using EM open table then typed in the
value I wanted.
Andrey <le*******@yaho o.com> wrote in message news:<pir4d.287 70$wV.19066@att bi_s54>... Andrew wrote:
Andrey <le*******@yaho o.com> wrote in message news:<7wt3d.787 69$D%.11878@att bi_s51>...
Andrew wrote:
Hi All,
Have come across something weird and am after some help.
Say i run this query where rec_id is a column of table arlhrl,
select * from arlhrl where rec_id >= 14260
This returns to me 2 records with rec_id's of 14260 and 14261
Then I run this query
select * from arlhrl where rec_id >= 14263
This returns 7 records with rec_ids of 14263 up.
How come the first query doesn't return the records returned by the 2nd query also?
If I select for 14262 no records are returned. It is like this is a phantom record or has an end of file character in it.
I tried re-creating the indexes but to no avail. If anyone has any ideas about what could be causing it or how to fix it it would be much appreciate d.
Thanks in advance,
Andrew
Hi,
First, stupid question - is the field 'rec_id' of integer type? Why i am asking is because i had a similar example myself when i started with my new job - i was quering an id field and got weird results as you do. Then i found that some 'smart ass' made this comlumn a varchar for no reason - just because she was doing like that in Access all the time before :)
Second, what i'd do when i get into an unexplainable glitch:
SELECT * INTO <new table> FROM <your table>
And try to query the records from the new table without setting any indexes - just as is - as you know SELECT INTO just copies raw data without any underlying stuff. See what you'll get. From my experience there are a of of people who are allowed to mess with SQL databases but don't have a clue what they are doing, and when you start using their 'smart ideas' sometimes it's just hard to follow their logic :) So maybe some setting were set a wrong way somewhere, you can never imagine what another person could do - believe me, i just got quite a few awsome examples within the last month since i got this job :)
Let me know how it works!
Andrey
Hi Andrey,
Thanks for your reply. I tried as you mentioned, inserting into new table etc but to no avail. I did figure out what the problem was though.
This particular table had been upsized from a foxpro table. One of the columns in the foxpro table had a maximum value of numeric 9999. Somehow, someone had tried to insert a value large than this so foxpro put in ****. On the upsize, and I can only assume here, sql must have thought 'hang on, you must mean infinity here' and put a bit-wise pattern (1.#INF) for infinity into this particular column for the record.
This only became evident when using Enterprise Manager and returning all rows on the given table, it did display the record with the value 1.#INF in the column for the 'missing' record. As to why it displayed in EM and not Query Analyser is anyone's guess, but surely the queries that led me to this initial discovery shouldn't have behaved like this!!??
posting
http://groups.google.com/groups?q=%2...gle.com&rnum=1
gives some ideas.
Thanks anyway,
Andrew
And how did you get rid of that infinity value in the in field? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Duncan Smith |
last post by:
Hello,
I'm not very experienced in SQL and I need some advice. I have a
comma separarated values file containing around 20 million records and about
20 fields. There are many missing values (blank). I am only directly
interested in 2 fields (1 & 4), but need to use two other fields (2 & 3) for
imputing values for Field 1 (if missing). If Field 4 is missing I must
delete / ignore the record. The (Python) types are,
Field1 (string) ...
|
by: Lars Eighner |
last post by:
I am trying to force my pages into the skidoo_two three-column
layout. Evidently I am breaking some of the hacks as I do so.
In Opera 7.54 (FreeBSD) I see phantom underlines, starting about
where the picture of the man an the dog is, and going through
the rest of the page and the links in sidebars. If I scroll
down and back up, most of these underlines disappear.
<http://www.io.com/~eighner/index.html>
|
by: omyek |
last post by:
I'm essentially trying to do what a lot of users seem to want when
using the above classes, and that's POST to a webpage.
Well, I'm golden when it comes to POSTing, I've been able to post to
websites using both the webrequest/response and webclient methods.
However, the problem I'm running into with both options is I seem to
"lose" my connection/session.
Let me try to explain a little better. I connect to a website which
|
by: memememe |
last post by:
I see weak reference on the .net api, but I do not see soft or phantom, are
they supported on .net?
|
by: Rod Billett |
last post by:
The included html contains 3 divs. One primary Div, with 2 nested divs.
the second nested DIV contains an empty table.
Problem 1: Phantom Space. When viewed within the browser, the div 'action
panel' is spaced a picel or two lower than the div 'ItemsPanel' even though
both are the same height. Oddly enough, if you remove the table (ID
Removemetowork) this phantom space dissappears and everything is fine with
the world
Problem 2:...
| |
by: Justin Emlay |
last post by:
I'm hopping someone can help me out on a payroll project I need to
implement.
To start we are dealing with payroll periods. So we are dealing with an
exact 10 days (Monday - Friday, 2 weeks).
I have a dataset as follows (1 week to keep it short):
Employee 1 - Date 1
Employee 1 - Date 2
|
by: Dave |
last post by:
Apologies if this has come up before, but I can't find it if it has. I
am fairly new to .Net and am having problems with ghosts in the
datagrid.
Basically I have a find screen that accepts search criteria, then
interrogates a database to find all matching records. These are put
into a dataset, which has a dataview that is used as the datasource of
my datagrid, which is read only. The idea is that the user selects
which record they...
|
by: Fred Chateau |
last post by:
Still working on my XML DataSet...
Having moved on past difficult and complex problems, resolved with the
assistance of everyone here, I find myself facing yet another problem. My
XML document breaks the schema. There are missing tags everywhere, on
purpose I'm told, because we don't need them.
I'm getting a "System.Data: There is no row at position <row number>" error.
Hopefully I can workaround this issue. I need to find a way to...
|
by: jayhart |
last post by:
Im having an issue with a database where Im missing tables and
forms............but they still seem to be present (but not
displayed).
When Im looking at the table list, the table is not listed (table name
"tblMain"), but Im able to run an existing query (and I get results)
off this "phantom" "tblMain" table. It's as if the query is running
off a table that doesn't exist. But if Im receiving results, the
table has to be somewhere,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |