The logic is gone..
-
So here i am at work, thinking i can finish my project today, only thing i had to do was writing a simple screen which shows some data from the database. I finished all of my code, only when testing i realized that the data displayed on the screen, is not the same as the data in my database. I started debugging checking where i made a mistake in my code.. no mistakes to be found. It seems that the moment i fill my datatable in my program, the data is all wrong. So i doublechecked my sql, my connectionstring.. well everything. Everything seems to be right, the only difference is: executing the sql from my program gives other results than executing the sql from sql developer :sigh: it's going to be a loooong day it's always amusing reading the posts here when people have strange problems, knowing that i have none of my own, seems te be the other way around today :laugh:
-
So here i am at work, thinking i can finish my project today, only thing i had to do was writing a simple screen which shows some data from the database. I finished all of my code, only when testing i realized that the data displayed on the screen, is not the same as the data in my database. I started debugging checking where i made a mistake in my code.. no mistakes to be found. It seems that the moment i fill my datatable in my program, the data is all wrong. So i doublechecked my sql, my connectionstring.. well everything. Everything seems to be right, the only difference is: executing the sql from my program gives other results than executing the sql from sql developer :sigh: it's going to be a loooong day it's always amusing reading the posts here when people have strange problems, knowing that i have none of my own, seems te be the other way around today :laugh:
Do not forget to let us know what the problem was.
-
-
Do not forget to let us know what the problem was.
-
So here i am at work, thinking i can finish my project today, only thing i had to do was writing a simple screen which shows some data from the database. I finished all of my code, only when testing i realized that the data displayed on the screen, is not the same as the data in my database. I started debugging checking where i made a mistake in my code.. no mistakes to be found. It seems that the moment i fill my datatable in my program, the data is all wrong. So i doublechecked my sql, my connectionstring.. well everything. Everything seems to be right, the only difference is: executing the sql from my program gives other results than executing the sql from sql developer :sigh: it's going to be a loooong day it's always amusing reading the posts here when people have strange problems, knowing that i have none of my own, seems te be the other way around today :laugh:
Check the carburetor. If that's not it, blame Windows.
I wanna be a eunuchs developer! Pass me a bread knife!
-
so apparently sql developer and sql plus give different results with the same sql :confused: this ought to be fun to solve.... i need a beer
mSh1985 wrote:
so apparently sql developer and sql plus give different results with the same sql this ought to be fun to solve.... i need a beer
FTFY :beer:
Panic, Chaos, Destruction. My work here is done.
-
Check the carburetor. If that's not it, blame Windows.
I wanna be a eunuchs developer! Pass me a bread knife!
I thought it was blame Windows then check the carb.
Panic, Chaos, Destruction. My work here is done.
-
I thought it was blame Windows then check the carb.
Panic, Chaos, Destruction. My work here is done.
No, because if it is the carb, you can fix it, then blame Windows anyway. Saves time for the fix.
I wanna be a eunuchs developer! Pass me a bread knife!
-
So here i am at work, thinking i can finish my project today, only thing i had to do was writing a simple screen which shows some data from the database. I finished all of my code, only when testing i realized that the data displayed on the screen, is not the same as the data in my database. I started debugging checking where i made a mistake in my code.. no mistakes to be found. It seems that the moment i fill my datatable in my program, the data is all wrong. So i doublechecked my sql, my connectionstring.. well everything. Everything seems to be right, the only difference is: executing the sql from my program gives other results than executing the sql from sql developer :sigh: it's going to be a loooong day it's always amusing reading the posts here when people have strange problems, knowing that i have none of my own, seems te be the other way around today :laugh:
are you accessing the right database each time? :)
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
-
So here i am at work, thinking i can finish my project today, only thing i had to do was writing a simple screen which shows some data from the database. I finished all of my code, only when testing i realized that the data displayed on the screen, is not the same as the data in my database. I started debugging checking where i made a mistake in my code.. no mistakes to be found. It seems that the moment i fill my datatable in my program, the data is all wrong. So i doublechecked my sql, my connectionstring.. well everything. Everything seems to be right, the only difference is: executing the sql from my program gives other results than executing the sql from sql developer :sigh: it's going to be a loooong day it's always amusing reading the posts here when people have strange problems, knowing that i have none of my own, seems te be the other way around today :laugh:
Okaaaaay... So i found out that when i did a "select count(*)" from a certain table sql plus said: no rows selected, sql developer: 416 rows selected I closed my connection in sql developer, reconnected, still the same problem Tried opening sql developer on another pc, no rows selected... I closed my sql developer on my own pc, opened it again, still 416 rows Tried again on the other pc, also 416 rows Tried with sql plus, 416 rows.. Something went seriously wrong with sql developer which resulted in problems everywhere except in sql developer, still don't know what happened, i'm just happy everything is normal again :-D
-
Okaaaaay... So i found out that when i did a "select count(*)" from a certain table sql plus said: no rows selected, sql developer: 416 rows selected I closed my connection in sql developer, reconnected, still the same problem Tried opening sql developer on another pc, no rows selected... I closed my sql developer on my own pc, opened it again, still 416 rows Tried again on the other pc, also 416 rows Tried with sql plus, 416 rows.. Something went seriously wrong with sql developer which resulted in problems everywhere except in sql developer, still don't know what happened, i'm just happy everything is normal again :-D
Moons go I had a problem with an Oracle DB connection over the network when it became overloaded. Mr Oracle, AFAIR Larry's assistant's assistant said it wasn't their fault but the networks. I replaced the compliminated query with something like:
SELECT 1 FROM SYS.CONFIG;
It still went t!ts up and they dispatched a fire fighter to sort out the problem. At the end of the day, the tracing software they had to make sure everything worked, rather than allowing TCP/IP to do its job, was causing locks that resulted in lost packets.
Panic, Chaos, Destruction. My work here is done.
-
are you accessing the right database each time? :)
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
I did that once. Forgot to change the connection string and thought I had. What a headache. :)
-
Okaaaaay... So i found out that when i did a "select count(*)" from a certain table sql plus said: no rows selected, sql developer: 416 rows selected I closed my connection in sql developer, reconnected, still the same problem Tried opening sql developer on another pc, no rows selected... I closed my sql developer on my own pc, opened it again, still 416 rows Tried again on the other pc, also 416 rows Tried with sql plus, 416 rows.. Something went seriously wrong with sql developer which resulted in problems everywhere except in sql developer, still don't know what happened, i'm just happy everything is normal again :-D
mSh1985 wrote:
select count(*)
A potential disaster, waiting to happen. :) Try this instead
select count(ROWID)
:cool:
Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
-
So here i am at work, thinking i can finish my project today, only thing i had to do was writing a simple screen which shows some data from the database. I finished all of my code, only when testing i realized that the data displayed on the screen, is not the same as the data in my database. I started debugging checking where i made a mistake in my code.. no mistakes to be found. It seems that the moment i fill my datatable in my program, the data is all wrong. So i doublechecked my sql, my connectionstring.. well everything. Everything seems to be right, the only difference is: executing the sql from my program gives other results than executing the sql from sql developer :sigh: it's going to be a loooong day it's always amusing reading the posts here when people have strange problems, knowing that i have none of my own, seems te be the other way around today :laugh:
Sounds like something a sledge hammer could fix quickly. :) Good luck and let us know what happened!
CQ de W5ALT
Walt Fair, Jr., P. E. Comport Computing Specializing in Technical Engineering Software