I am trying to alter some SQL to use parameters. I bypassed this earlier as it was just not working but am now heading back to tidy up. For some reason I cannot get this to work, keep in mind I am using Odbc:

SQLString = "SELECT * FROM Stories WHERE StoryID=?"
  'cmdSelectStory.Parameters.Add( "?StoryID", OdbcType.BigInt )
  'cmdSelectStory.Parameters.Add( "?StoryID" ).Value = strStoryID

Anyway I try, I cannot get the parameters to add to the SQL string. In the Odbc database, this column is BigInt(20). I have just been adding it directly into the SQL string, but am now converting that to parameters but cannot figure how. Any help would be appreciated!

10 Years
Discussion Span
Last Post by SheSaidImaPregy

Sorry, after looking at it I realized that I added the parameters before calling it from the command. Therefore, an error arised. fixed.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.