Params Problem

Comments

• thenicespider

  January 2006 edited 7:02PM

  use this code:
  
  var param1 string;
  
  param1 := '(1,4,5,9,11)';
  sql_msg= 'select * from tbl a where a.fld in ' + param1
  
  then execute it!
• mam

  January 2006 edited 7:02PM

  thenicespider thank's a lot
  
  I tried this code
  
  var param1 string;
  
  param1 := '(1,4,5,9,11)';
  sql_msg= 'select * from tbl a where a.fld in ' + param1
  
  and this
  sql_msg= format('select * from tbl a where a.fld in %s ',<var1>)
  
  its runnig good from report desiner but its not when you try to load report from delphi whith variables such as
  
  frxrep1.variables := '(1,4,6)';
  
  important note a.fld is integer field
  
• gordk St.Catherines On. Canada.

  January 2006 edited 7:02PM

  try adding extra quotes
  frxrep1.variables := ''''+'(1,4,6)'+'''';
  
  
• mam

  January 2006 edited 7:02PM

  thank's for all
  
  when i try to add extra quotes
  
  frxrep1.variables := ''''+'(1,4,6)'+'''';
  
  i eceived this error mssage
  could not convert variant (string) into type (double)
• gordk St.Catherines On. Canada.

  January 2006 edited 7:02PM

  since it works when you hard code the value in the variable
  "sql_msg= format('select * from tbl a where a.fld in %s ',<var1>)
  its runnig good from report desiner"
  the problem is usually in the code where we pass the value from delphi to the variable, delphi strips the '
  here is a tip on how to find, it look at the hardcoded value (that works) in the variable and note how it appears, now go to delphi and where you load the report and set the variables value instead of calling showreport call design report when the designer comes up look at the variable and see what has been placed in the variables expression if it doesnt match what you would have hardcoded go back out to delphi and adjust delphi code, repeat untill you get it correct.
  
• mam

  January 2006 edited 7:02PM

  gordk.
  thank for value advice
  yes i found the problem and fix it