Getting Parameters at runtime

From: Bryce K. Nielsen (bryce_at_sysonyx.com)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 01:29:29 -0600

I have a TADOQuery and I'm setting the SQL at runtime with parameters (i.e.
:ParamName is in the text). I would like the Parameters list to populate
itself, like it does at design time, but can't figure out how to do this. I
tried TADOQuery.Prepared := True, as well as TADOQuery.Parameters.Refresh,
but neither seem to do anything. What am I missing?

-BKN

Relevant Pages

  • Re: Scripting conditional list box
    ... the drop down boxwon't populate. ... Dim SQL as string ... SQL = "SELECT ApptTime FROM AppointmentTimes WHERE ApptTime not in ... except that you called the query "Time". ...
    (microsoft.public.access.formscoding)
  • Re: Re: Inserting large amounts of data
    ... > I'm using DTS to populate a staging table with raw streams of data (a ... I thought about imbedding the SQL ... Doing the substringing in T-SQL is not the ...
    (comp.databases.ms-sqlserver)
  • Re: Populating date into SQL
    ... datetime field in SQL ... Dim trans As SqlClient.SqlTransaction 'Transaction object ... 'Populate sql ... insertCMD = String.Formatvalues ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Please display the table faster in the datagrid
    ... > Thanks Dmitriy, I did find some 3rd party tools but I'm not ready to ... > recommend purchasing them yet. ... > VFP table would I be able to use mySQLCommand.ExecuteNonQuery() with a SQL ... You can't populate a grid with 60 million records (which ...
    (microsoft.public.vb.database)
  • Re: Truncated Blob Field in TADOQuery
    ... I used a TADOStoredProc instead and the problem went away. ... suspect that ti has to do with the manner in which TADOQuery handles ... and pumping it down into a MS SQL db locally. ... > of the parameter in the TADOQuery component before calling the ExecSQL ...
    (borland.public.delphi.database.ado)