Re: Preview Data dialogue demands values for every param in a store pr

First things first. "Empty" is not a very good term to use in regards to the
data, I would guess that you mean either one of two things, either an empty
string or null; since it's possible that not all of your params are strings,
perhaps you mean null? If you have optional parameters in your stored
procedure then they do not require a value. Otherwise you have to either
provide a value or can set them to be null.

"Peter Jones" <PeterJones@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6927AEBE-99C2-4373-B26A-EAE5ABCF3ADF@xxxxxxxxxxxxxxxx
Hi,
If this isn't the correct forum please let me know where I should post.

I'm developing in VS2005 and have a data source based upon a parameterised
stored procedure. I click to preview my data and I'm presented with a very
nice UI that lists all my parameters however, it is the nature of these
paramters that they are mostly left empty - the stored procedures decides
on
how to use them depending upon if they contain values or not.

The problem I have is that the Preview Data dialogue demands that I enter
a
value for every parameter. Is there any way around this?

TIA - Peter


.

Relevant Pages

  • Re: Deletion of Empty Page in the Word Document through VBA
    ... The find string "^b" is not working. ... Regards ... "Kiruthiga" wrote: ... >>> scan each and every page and finding if any empty page is there. ...
    (microsoft.public.word.vba.general)
  • Re: Bug or limitation in the functionality of sp_OAMethod
    ... > using a CHAR data type through a parameter in the ... > execution of sp_OAMethod actually results in an empty ... > string being passed to the COM object instead. ... > I have confirmed that the stored procedure sp_OAMethod ...
    (microsoft.public.sqlserver.programming)
  • Re: Either BOF or EOF is true . . .
    ... >fetches a result set from a SQL Server table using a SELECT statement. ... >stored procedure accepts an input parameter, and may return an empty result ... My program doesn't care if it gets an empty ... I get an exception "Project Outlook.exe raised exception ...
    (borland.public.delphi.database.ado)
  • Either BOF or EOF is true . . .
    ... fetches a result set from a SQL Server table using a SELECT statement. ... stored procedure accepts an input parameter, and may return an empty result ... My program doesn't care if it gets an empty ... I get an exception "Project Outlook.exe raised exception ...
    (borland.public.delphi.database.ado)
  • Re: Processing speed
    ... > include de-referencing variables and releasing unmanaged resources. ... How about using a stored procedure in the database to empty the tables? ...
    (microsoft.public.dotnet.languages.vb)
Loading