General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Sorry to ask so many questions on Views...
I am trying to determine how to check and see if a record has already been added to a view.
For example, I have a grid where you key in inventory skus. When the save button is clicked I can use v_MyView in 0 again alias v_MyView2 and then scan through the 2nd view to see if this particular sku already exists. If so pop up error message and don't save. This works fine for skus that were keyed in and committed. But my problem is if they key in the same sku twice in this session. v_MyView2 only has the records that were committed.
I am using table buffering.
Thanks,
Paul
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only