Dear ,

I have problem in number generation only.

You mistaken by my sentences that I have problem in insertion.

Problem in insertion is due to wrong number generation.

Sujith

Dear Mahesh,

When I get a new number this is for only for first row, for the rest of the row I am incrementing values through the loop.

Sujith

Hi Friend(s),

Here I am Adding My full code for insertion.

First part to Enquiry master details & then to Enquiry Details.

Please see this. Problem in Enquiry detail Section where new board...

Hi,

I dont understand what this procedure is doing and how this one will helpfull in my case??

I have problem in number generation. Proper number generation is not happening because query...

Dear all,

1. Its not a problem of simultaneous transaction. I tested it.

2. Boardno field is not varchar, its numeric.

So its some other problem. Its happening for recently added records. I...

Dear All,

It is not a problem of commmit transaction. I put commit trans statement properly. In most of the cases this code works ok. In some cases only problem occurs....

Hi,

I tried Max(fieldname) also. In this case also same result.

Actually when fetching data query not considering recently added records at all.

Here no error occurs. Query just ignores recently...

1. No problem with function Parameter. I can put tablename directly.

like this,

...