Link to home
Start Free TrialLog in
Avatar of austin123
austin123

asked on

Rows Are Automatically Moved Here And There In A Random Fashion In SQL

Hello Experts,

In the starting I thought there is some problme in my VB Coding, I debugged it a lot but to no results.

Suddenly I thought let me try entering Rows from MS-SQL Enterprise Manager only before looking into the VB Module Code.

In my Database Table, there is no primary field, all fields Allow Nulls is checked. Table consists of 18 fields of char,varchar, date etc.

After Moving to the last row, When I enter Records say 3 at a go and then closes the table and again open it I found that that out of three, 2 are placed in between and 1 in the last.
It is happening everytime and whatever I enter, sometimes 1 is placed in the last, 1 is placed somewhere and another 3rd somewhere else.

I have nothing as such defined on the table. According to me it should be like the records should come the way I am entering, the order should be like this only.

Why this is happening, please tell, if you have any ideas.

Best Regards
Austin

ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial