General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Getting an empty View
I have a table with an existing paramatised view against it.
I need to add a record into the table and want to do it via the view (in case app is upsized)
As such I need to start off with the view empty ready for me to do the single insert into it I need.
At present I just change the view parameters to something that I know will not return any data.
ie clMyParam='zxx##xxz' or something.
Does anyone know of a better way because this technique is not very elegant.
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