value fetching problem

Question

0.00/5 (No votes)

See more:

SQL-server-2000

dear sir/ma'am

sir i have a problem that i read omr sheets .my processing works well
and form num and barcode also fetch correctly.

but when i open any other window like google chrome or notepad or other then processing become affected and wrong entries fetch fromdatabase.

as i select course then click on processbutton

processing begin as

form no barcode
10 1895
21 1893
32 1855
43 9898

now suppose i open a new window like notepad
when process already started and form no 21 hasbeen processed

the answer become
form no barcode
10 1895
21 1893
322222 11555
322222 11555
this type of output i found but if i donot open any window then processing done correctly

Posted 18-Jun-13 20:07pm

ankur789

Updated 18-Jun-13 20:18pm

v2

Add a Solution

Comments

Christian Graus 19-Jun-13 2:11am

This is an insane question. Chrome or notepad won't stop your DB calls from working. Unless you are screen scraping, you are dead wrong. Either way, no-one can help based on this. Post code, explain your process, etc.

Christian Graus 19-Jun-13 2:20am

Again, this is useless. We need to see your CODE.

Christian Graus 19-Jun-13 2:29am

Honestly, if you think this is a reasonable question, then you really have no idea what you are doing. I am leaving for the day, hopefully someone else can penetrate this mystery with you.

ankur789 19-Jun-13 2:33am

this is also an unwanted condition and i never find such like a problem so i do not understand why this condition occurs

RedDk 19-Jun-13 13:26pm

Both interesting AND bizzare. Here's a question: "this type of output" ??? Meaning: the ssmse output in grid or text or results? Or are you refering to an "output" that you are post-processing using notepad? I see "SQL2000" tag and am baffled asking myself "why no upgrade" ...

ankur789 19-Jun-13 22:37pm

sir output is in grid

and sir my complete database is in the sql server 2000 through which i manage other databases like library ,mess mang etc so i only added certain tables in my previous database and continuous my work

RedDk 21-Jun-13 18:32pm

Ok, grid. Now what about representation:

form_no barcode
~~~~~~~~~~~~~~~~~~
10 1895
21 1893
.
.
.
322222 11555
322222 11555

Is that what you mean? I add the elipsis to show there are missing records.
If so, might you require clause ORDER BY [form_no]?

CHill60 22-Jun-13 8:33am

If opening other applications is affecting your program then you must need focus to be on your application while it is running ... how are you actually populating your grid - try posting the code behind your Process button

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)