Skip to content
← Delphi Data Access Components

How can we improve our Delphi Data Access Components?

Delphi Data Access Components: Common

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Forced sending queries to the server without parameters

Queries may be with or without parameters:

select *
from test_table
where id = :ID

or

select *
from test_table

However some database servers execute queries without parameters faster than the same queries with parameters. An option (for example, AllowParams) may be added; if this option is set to False, all queries will be sent to a server as text.

45 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
AdminDevart (_, Devart) shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Dorin Marcoci commented  ·   ·  Report

    This is more a "parameter by value" replacement feature.
    It may lead in sql injections.
    Also different DBMSes handle parameters in different way. Quoted/unquoted, date format, etc...

  • Francesco commented  ·   ·  Report

    This is a SDAC only suggestion in my opinion

  • Flavio commented  ·   ·  Report

    This feature is very important because the queries with "exec sp_executesql" are very slow. As with plain text is very fast.