Search results for query: *

Thank you very much, it works great now! I guess my VB is a little rusty... :-)

Okay, but now i get an 'invalid character' error: Function GetSql(ByVal strFileType As String, ByVal strSearchRange As String, ByVal strSearchValue As String) As String Dim strSql, strFilestr, strSearchstr As String strSql = "SELECT bunch, of, columns" strSql += "FROM table " strSql...

... or do i just add another string parameter to the custom code function?

Ah. I think this will work, but there is just one more thing: how do i refer to the value of 'anotherparam' in custom code?

Yes, and it works fine in the stored procedure, but i also have need of this code within the report. BTW, i am using the MS OLE DB provider for Oracle in the data source... don't know if that affects it significantly...

I've also noticed that in certain circumstances, data sources will repeatedly ask for credentials if you are not the owner of the .rds file. You may be able to get around this if you have more permissions granted on the file, but i haven't been able to test that theory...

I'm trying to figure out how to change the comparison operator in my select statement based on the value of a parameter. Pseudocode: if (chooseparam = 'like') then select column from table where column like 'anotherparam%' else select column from table where column =...