data base insert data missing

[GokulGKM]

hi,

      i am inserting the data continually in while loop using data base toolkit.missing some data insert table.and also form inserting data in array it will correct.

[GokulGKM]

hi,

       here i attached my programing image.

[dkfire]

There are some issues with your code.

• The output of the Execute Query vi is not a connection reference, it is a recordset reference.
• You need to close the recordset reference that is comming from the Execute Query vi.
• You have output tunnels on the case structure and event structure set to "Use Default If Unwired". You will loose your connection to the database. You need to be sure to wire the output tunnels with the correct wires.

Do you get any errors on the error wire??

How does your sql queries to the database look like? could they have wrong/illigal values/format?

[GokulGKM]

hi,

       my quary form and code working fine...no error message come.only problem insert some data missing in table (ex i am insert 1 to 10 data but actually inserted 1,2,3,5,8,9,10) and  insertted in array  data 1 to 10 correct..

[dkfire]

Make the changes that I have pointed out.

Then try again.

What type of database are you connecting to ?

[GokulGKM]

hi,

        this is sub vi.i will closed connection in main vi.

          using sql server connection.

[dkfire]

It is okay that you close the connection to the database in the main vi, but you need to close the recordset that the Execute Query is generating.

You are not getting all errors that is happening in the while loop, only the last value of the error cluster is going out of the while loop.
If any errors has happend in one of the iterations of the while loop, that error will be overwritten in the next iteration, and you will loose the information about the error.
You can fix this by

• Changing the error tunnels to a Shift Register.
• Or changing the output tunnels to Indexing and the use a Merge Error, to get only the first error/one error out.

[GokulGKM]

ya correct, the following error will come.

                1).DB Tools Close Connection.vi->Untitled 1<ERR>Open recordset object.

          so don't know how to close recordset object.but i closed main vi DB tool closed connections.

[dkfire · Accepted solution]

You can do that with the "DB Tools Free Object.vi"