Results 1 to 8 of 8

Thread: Problem with ADO Parameter value [resolved]

Threaded View

  1. Apr 21st, 2004, 10:25 AM #1
    ahara
    ahara is offline

    Thread Starter
    Fanatic Member ahara's Avatar
    Join Date
    Nov 2003
    Location
    Toronto
    Posts
    531

    Problem with ADO Parameter value [resolved]

    Anyone out there know how to pass a sql statement as a parameter value?

    Code:
    Set para = cmdCommand.CreateParameter("estimate_id", adNumeric, adParamReturnValue, 20, "SELECT NVL(MAX(estimate_id) + 1,1) FROM time_estimates")
cmdCommand.Parameters.Append para
    I'm sure there is a way to do this - maybe with the right data type and parameter type combination (2nd and 3rd arguments in CreateParameter method)....I'll keep checking the web, but if anyone has done this before, please demonstrate. Thanks.
    Last edited by ahara; Apr 22nd, 2004 at 04:09 AM.
    "Knowledge is gained when different people look at the same information in different ways"

    - Louis Pasteur
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width