I am building an application that uses SQL Server. Soon this will change to Oracle but that is not my biggest concern. My main concern is about a view.
This view has the following select statement:
Select t$hfdl, t$date, t$wrko, t$beur from ttirbh016700 where t$uitv = 1 and t$afgm = 1 and t$odat <> 0 and t$dctb = 0
The table this is selected from, should be different depending on a value my Visual Basic application reads from an INI file
the '700' part should be dynamic.
I am not the most frequent user of SQL Server or Oracle, but as far as I know, views are static. Anyone that knows a way to pass my INI value to the view? Or am I right and is this simply not possible. If it isn't...what is the way to go? Stored Procedures? Please someone advice..I need this as soon as humanly possible..