New data not showing

[Laura K]

Hi I have a strange problem

I just upgraded to MS SQL from access and one of my tables does not show the
new data when it is added.

My database is attached to a web site. There is a table that has
information already in the rows. When that info is updated it does not show
on the site. When I look in the table the newly updated data is there. The
page does show the old data just not the new.

This worked just fine in access.

Now I am stumped.


Any suggestions?

Laura K

 

[Laura K]

nevermind.

Got it!

Laura K

 

[jACK]

-----Original Message-----
Hi I have a strange problem

I just upgraded to MS SQL from access and one of my tables does not show the
new data when it is added.

My database is attached to a web site. There is a table that has
information already in the rows. When that info is updated it does not show
on the site. When I look in the table the newly updated data is there. The
page does show the old data just not the new.

This worked just fine in access.

Now I am stumped.


Any suggestions?

Laura K


.
iT SOUNDS LIKE YOU DO NOT HAVE A PRIMARY KEY SELECTED ON

YOUR TABLES

 

[Laura K]

Nope I was adding info to a table and then viewing it in a query. When I
upgraded the query it did not upgrade to a view but instead to a table.
This meant that the new info did not add to the view in SQL. When I changed
the query to a view it worked.

Laura K