in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine

Display output of prepared query?

Last post 03-05-2010 7:55 AM by langenscheidts. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 03-05-2010 7:55 AM

    Display output of prepared query?

    Hello

    I need to check the output of a prepared query:

                         HashOutput = ReadFile(path)
                        'WARNING: Can hash contain a single quote?
                        SQLcommand.CommandText = "SELECT id,name,hash FROM files WHERE hash='@hash'"
                        SQLcommand.Parameters.AddWithValue("@hash", HashOutput)
                        SQLcommand.Prepare()
                        SQLreader = SQLcommand.ExecuteReader()
                        'If first occurence of this file, save hash for later
                        If Not SQLreader.HasRows Then
    
    
    

    Is there a way to tell SDS to display how it massaged the query before or after running it?

    Thank you.

Page 1 of 1 (1 items)
Powered by Community Server (Commercial Edition), by Telligent Systems