Results 1 to 3 of 3

Thread: [RESOLVED] Get completed parameterized query string

  1. Feb 8th, 2012, 07:14 AM #1
    Madcat1981
    Madcat1981 is offline

    Thread Starter
    Lively Member
    Join Date
    Mar 2007
    Posts
    84

    Resolved [RESOLVED] Get completed parameterized query string

    Hi all,

    Quick question. When using parameters with query strings, is it possible to see what the completed string using those is?

    Many thanks,
    Last edited by Madcat1981; Jan 6th, 2016 at 10:08 AM.
    Reply With Quote Reply With Quote
  2. Feb 8th, 2012, 07:52 PM #2
    jmcilhinney
    jmcilhinney is online now
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    110,348

    Re: Get completed parameterized query string

    No, because the values aren't substituted into the query on the application side, which is the whole point. It is the database that does that. If you're using a database with a tracing tool, e.g. SQL Server, then you can see what the database is actually executing that way.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB (Sorting AlphaNumeric Strings Logically NEW, Binding a Data Reader in Windows Forms NEW) | C# (Sorting AlphaNumeric Strings Logically NEW, Binding a Data Reader in Windows Forms NEW)
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL
    Reply With Quote Reply With Quote
  3. Feb 9th, 2012, 03:48 AM #3
    Madcat1981
    Madcat1981 is offline

    Thread Starter
    Lively Member
    Join Date
    Mar 2007
    Posts
    84

    Re: Get completed parameterized query string

    Ah ok, that makes sense.

    Many thanks!
    Last edited by Madcat1981; Jan 6th, 2016 at 10:08 AM.
    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