Using ParseSQL Command for ADO Parameters Cause Invalid Parameter DataType

Question

I have some SQL Command that contains a parameter such:(Note that myID has "int" type in SQL)

vSqlString :='Select * From myTable Where myID= :paramID';

and Use ParseSQL Command to execute this command:

myADOQuery.Parameters.ParseSQL(vSqlString , True);

Now myADOQuery.Parameters.ParamByName('paramID').DataType is smallint Type and it can't accept negative integer values.

I can exactly show to compiler that my Parameter[0].DataType is ftIneteger and it works properly, but what is a good solution for this problem?

Have you tried changing the datatype: myADOQuery.Parameters.ParamByName('paramID').DataType := ftInteger; — Keith Miller
– Keith Miller, Commented Dec 28, 2013 at 10:59
Alternatively you can set up the parameters manually rather than by calling ParseSQL. — Keith Miller
– Keith Miller, Commented Dec 28, 2013 at 11:00
what is your DB backend? Smallint type is rather weird for an identity column? — whosrdaddy
– whosrdaddy, Commented Dec 28, 2013 at 11:17
@MohammadGohari I think that is the best solution. The compiler cannot query the DB to see what the column datatypes are so you have to tell it. Personally I don't use ParseSQL, I set up the parameters in code so I have full control. — Keith Miller
– Keith Miller, Commented Dec 29, 2013 at 9:36
see this article [ADOQuery.ParseSql][1] [1]: stackoverflow.com/questions/21194122/… — imanShadabi
– imanShadabi, Commented Jan 21, 2014 at 5:47

Community · Accepted Answer · 2017-05-23 12:03:46Z

3

+50

My question is asked by Mr. imanShadabi Here: Using TAdoQuery.ParseSql and has resolved by user1008646

edited May 23, 2017 at 12:03

CommunityBot

11 silver badge

answered Jan 21, 2014 at 8:10

Mohammad Gohari

3513 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

David Dubois Over a year ago

Glad I could help. I wonder how I'd go about collecting the bounty.

TLama Over a year ago

@user1008646, don't worry. You'll get one :-)

pariasdev · Accepted Answer · 2014-01-21 07:54:35Z

0

Hope this will help.

If you want to create in runtime parameters, you can use something like this:

ADOQuery1.Close;
ADOQuery1.SQL.Text := vSqlString;
ADOQuery1.Parameters.Clear;
ADOQuery1.Parameters.CreateParameter('paramID', ftInteger, pdInput, 10, vIntegerValue);
ADOQuery1.Open;

Or you can concatenate values to the query. For example:

//For Integer values:
vSqlString: = 'Select * From myTable Where myID =' + IntToStr (vIntegerValue); 

//For String values:
vSqlString: = 'Select * From myTable Where myID =' + QuotedStr (vStringValue); 

//For float values: 
//Be careful with this, usually in a query, the comma is separator values, 
//so make sure that the decimal separator is '.'
vDS := DecimalSeparator; //I keep the value it had 
DecimalSeparator := '.'; 
try
  ADOQuery1.close;
  ADOQuery1.SQL.Text := 'Select * From myTable Where myID='+FloatToStr(vFloatValue);
  ADOQuery1.Open;
finally
  DecimalSeparator := vDS; //Restore the value that had
end;

The third option is to set the parameters at design time. But I think this is not what you want.

answered Jan 21, 2014 at 7:54

pariasdev

5815 silver badges4 bronze badges

1 Comment

Mohammad Gohari Over a year ago

thanks aljarafe. but I wanna use ParseSQL and know this command bug

Collectives™ on Stack Overflow

Using ParseSQL Command for ADO Parameters Cause Invalid Parameter DataType

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related