Posts by debasisdas

When your house is on fire, its not the time to talk about the politics of the fire brigade.

As i have already mentioned you can write log into another table.

590

590

590

594

as per the rule of referential integrity.

1. No child record can exist without a parent record
i.e.--Parent record must be created first and then the child record.

2. Parent record can't be deleted till there exists a dependent child record
i.e.-- Child record must be deleted first and then the parent record.

But where is the code that you are working on, not Google search provided code.

Have you created anything of your own ?

598

Read this and this for Exporting of mysql

602

you it can be, you need a way to establish a request response functionality between the client ans the server.

After all the links I have provided, just want to know what you have codes so far.

1. Learn how to behave in a public forum like this.
2. Learn English before that, at least standard 3 level.
3. Learn to respect those who volunteer to help you.

With this attitude no one will help, does not matter which ever forum you join.

598

598

does this work ?

select CHARINDEX('-', TestNoName), CHARINDEX('-', TestNoName)-1 
from
.....

602

try this

SELECT SUBSTRING(QCTEST.TESTNAME, 1, CHARINDEX('-',CTEST.TESTNAME)-1)
FROM
....

Read here and here.

If the length and format is always consistent, you can manipulate the same using some basic string functions SUBSTRING.

Is it the case that data will be always consistent as per format in that column ?

Yes.

Using the select statement you need to check if the ID already exist.

If not --insert it.
If already exist---try a new ID.

The issue I have is in the VLP_QC_Results_Batch1000 has the testNo within a field called TestNoName and is separated by a “-“
I need to link these so that we can show the upper and lower limit for each test and the test results

I really did not understand this block.

608

what about reading this or this.

Lets see the code that you are working on.

1. Read what ever is in XML.
2. Clean up the data (in this case Trim should do) and store in DB.

Hi Welcome,

Hope you have a nice time here and enjoy sharing all your valuable knowledge and experience.

Could not you find any in the provided links ?

i believe there are enough code there.

and all of them are custom made.

Then you need to write log of each and every transaction.

This is possible if number of tables are less and is highly impractical for a big database with hundreds of tables.

612

i was asking you about the code that you are working on and which part you are struck with .

May be you are looking for this.

I think you need to ignore the white spaces while reading from XML and storing in DB.

I don't think there will be any difference in performance as per the above mentioned queries if the Joins are proper.

no..is standalone..if i can't browse using asp, can i make that system as server & client?

what browse you are talking about ?

you need to pass more information.

What the application is all about
is there any database ....

You simply need to apply the algorithm on the desired data.

lets see what you are working on.

618

Why not make the ID field an auto number .

620

622

Is that a web application and designed to run using a Browser ?

622

I think the suggestion was keeping the future in sight. Mainly because of data growth in future which you may not be able to produce now (with less data). Do not forget data size is one of the key factor for calculating performance. Usually expression version is used for testing / learning purpose not for fully grown application and it comes free. And if there is no difference why there would be two different versions express and enterprise.

1st one is conventional style SQL.
2nd is as per ANSI SQL.

626

630

634