# ADO Actions: "Parameter object is improperly defined"

**URL:** <https://www.finalbuilder.com/forums/t/ado-actions-parameter-object-is-improperly-defined/4647>\
**Category:** Bugs\
**Created:** [August 3, 2007, 8:36am UTC](https://www.finalbuilder.com/forums/t/ado-actions-parameter-object-is-improperly-defined/4647 "2007-08-03T08:36:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dmirapalheta](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/dmirapalheta/32/67_2.png) [@dmirapalheta](https://www.finalbuilder.com/forums/u/dmirapalheta)\
**Post date:** [August 3, 2007, 8:36am UTC](https://www.finalbuilder.com/forums/t/ado-actions-parameter-object-is-improperly-defined/4647/1 "2007-08-03T08:36:19Z")

</div>

&nbsp;&nbsp;&nbsp; When I have a string representation in the query witch has doble quotes OR&nbsp; ` inner it&nbsp;AND&nbsp;a colon after one of those&nbsp;the action breaks with the&nbsp;following error: "Error : Parameter object is improperly defined. Inconsistent or incomplete information was provided".

&nbsp;&nbsp; Sample query: select&nbsp;column from table where&nbsp;column = 'teste " teste : teste'

&nbsp;

&nbsp;&nbsp;&nbsp;I know this issue is from TParams.ParseSQL (I have already&nbsp;seen&nbsp;it in Borland Quality Central an commented a work around), that misinterpret the doble quote as the and of the string and thinks the next colon is a parameter.

&nbsp;

&nbsp; Tip: As you don't allow us to set parameters in the query a fast correction would be set ParamCheck to False or removing all the params before sending it to the database.

&nbsp;

&nbsp; Best regards,

&nbsp; Daniel Mirapalheta

---

<div class="post-metadata">

**Author:** ![dmirapalheta](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/dmirapalheta/32/67_2.png) [@dmirapalheta](https://www.finalbuilder.com/forums/u/dmirapalheta)\
**Post date:** [September 26, 2007, 6:19am UTC](https://www.finalbuilder.com/forums/t/ado-actions-parameter-object-is-improperly-defined/4647/2 "2007-09-26T06:19:34Z")

</div>

knock knock 😛
