Is there a property that returns me the text of a query with the values of the parameters? How in the example below
Thank you
Example
MyQuery1.SQL.Text := 'insert into bloqueos values(:one,:two,:tree)';
      MyQuery1.ParamByName('one').AsString := 'John';
      MyQuery1.ParamByName('two').AsString := 'Peter';
      MyQuery1.ParamByName('tree').AsInteger := 3;
      Cad := MyQuery1.SQL.Text;
      For i := 0 to MyQuery1.ParamCount-1 do
           Cad := StringReplace(Cad,':'+MyQuery1.Params.Items.Name,MyQuery1.Params.Items.Value,[rfReplaceAll]);
      ShowMessage(cad);
			
									
									
						Myquery.sql.text with params
- 
				cybsistemas
 - Posts: 118
 - Joined: Mon 12 Sep 2005 17:31
 - Location: Argentina
 
Re: Myquery.sql.text with params
Unfortunately, at the moment MyDAC doesn't support this functionality.
If you want us to implement this functionality, please post it at our user voice forum: http://devart.uservoice.com/forums/1046 ... 8913-mysql
If the suggestion gets a lot of votes, we will consider the possibility to implement it.
			
									
									
						If you want us to implement this functionality, please post it at our user voice forum: http://devart.uservoice.com/forums/1046 ... 8913-mysql
If the suggestion gets a lot of votes, we will consider the possibility to implement it.