Posts by debasisdas

4 9 6

496.

496

496

496

That version is de-supported and is not available commercially anymore.

use them to make a new data

What exactly you are trying to do ?
are you trying to implement some encryption algorithm ?

Please read more here.

Please check your connection string.

As you mentioned regarding "latest version of .net + SQL Server". Is that VB 2010 or other language of .net version and My SQL Server or MS SQL Server or both of them?

better to go for 2010 version with latest MS SQL Server.

Knowledge of other databases and languages will be plus.

And regarding technical education, will MCA be sufficient?

yes, that should.

Let your tears wash away the pain in your lovers heart.

Go to

User Control Panel > Edit Email & Password

and change the settings.

494

Welcome to Daniweb.

yes that sky rocketed a couple of days back and yesterday nose dived back to where it was

you need to capture value from any control using variable and later use the same in your SQL statemnet.

Yes those are system tables.

that will depend on the schema through which you have logged in into the DB.

Welcome to daniweb.

492

try installing from another CD.

512

Hi jerodev,

Welcome to Daniweb.

516

The happiness of your life depends on the quality of your thoughts.

You need to show some effort to get any sort of help here.

i need your help

we help those who help them selves.

to make a webbrowser work automaticly

nothing works automatically, you have to make it do that by writing some code.

BTW- What is the code that you are working on ?

474

474

478

Glad to learn that being an arts graduate you have hands on experience in Programming language. Your posts shows you have spend some time on programming. Even though there are few companies who are still working on VB, you need to accept that it is an outdated technology.
Believe me, i understand the education system and the job market in the country better than others here. The harsh reality is you do not have enough educational qualifications for a technical job.
Since you are good in VB better to go in for latest version of .net + SQL Server. Along with that what you need to do is register yourself for some technical degree. Currently since you do not have any technical degree it will be practically impossible for you to get an interview call from any standard company.

Lets see what is the code that you are working on to get the desired output.

Welcome aboard.

478

478

482

486

There is no rule of thumb to follow to optimize a query.

and what you are trying to do is not optimization, but removing some requirements.

490

488

488

Hi Rik,

Nice Intro.

Welcome to daniweb.

You need to go and read books and then complete your own assignment by yourself only.

488

yes, now use suggestion by smantscheff

i.e.---commit after every transaction.

as per your situations

User 1 executes Step C (the order with billnumber 51 is inserted)
commit
User 2 executes Step C (the order with billnumber 51 will not be insert as it is duplicate and 52 will be inserted.

the second order would simply not be inserted and be lost.

that is when my previous solution will come handy

Why not check for existence of the value generated (using +1 technique) once before inserting. If it exists increment the same further (+1) and insert.

The error message is displayed to maintain REFERENTIAL INTEGRITY.

While deleting records from a table you need to ensure that that there is no dependent child record in any other table, values of which are dependent on the records of the current table.

You need to alter the table.

Please read more here and here.

486

490

490