sql query parameter syntax

Comments

• AlexTZ

  June 2009 edited 1:48PM

  Hello,
  
  You can't supply several values using one sql parameter. You may try to build sql clause dynamically, in the report script. For example, write the following code in your report's StartReport event handler:
  

      private void _StartReport(object sender, EventArgs e)
      {
        Table1.SelectCommand = "select * from MyTable where MyColumn in (" + your_dynamic_clause + ")";
      }
  

  
  To create this event handler, select "Report" item in the "Properties" window's combobox, click "Events" button and double-click the "StartReport" event.
• cohalloran

  June 2009 edited 1:48PM

  Thanks,
  
  I'm getting this error
  
  Error CS0117: 'FastReport.Table.TableObject' does not contain a definition for 'SelectCommand'
• AlexTZ

  June 2009 edited 1:48PM

  In my example, Table1 is the name of your data table (you can see it if you select the table in the "Data" window).
• cohalloran

  June 2009 edited 1:48PM

  Thank You,
  
  Yes I had the incorrect name.
  
  There is 'Tablename' in the Data Properties and 'Name' in the Design Properties and they were different.
  I changed Name in the Design Props to Table1
• pinbot Texas

  June 2009 edited 1:48PM

  hmm.
  
  I can't get this to work.
  
  I have an added Query that I added through "Add SQL Query". Named it Table1 but when I try to access it via script, I get the error "Table1 does not exist in the current context"
  
  Bryan
  

  Table1.png 39.1K

  Table2.png 11.5K
• AlexTZ

  June 2009 edited 1:48PM

  To access a datasource, use the following code:
  
  TableDataSource datasource = Report.GetDataSource("YourDataSource_Alias") as TableDataSource;
• pinbot Texas

  June 2009 edited 1:48PM

  
  That's what I ended up doing and it's working fine.
  
  Found it in an earlier post of mine.
  
  Thanks.
  
• Magezi Sagesse DRCONGO

  December 2013 edited 1:48PM

  I have the same problem I don't know how to pass a parameter to my query.
  
  I have a problem with passing a custom sql command, I don't know how to pass parameters to tabledatasource selectcommand as it can be done with oledbcommand.parameters.add(.....), working without that is handling error when I the where condition data has an apostrophy.
  
  Example: table.selectcommand="select * from listetous where objsup='l'homme'" with oledbcommand it works when I use parameter :
  oledbcommand.commandtext= ="select * from listetous where objsup=a"
  oledbcommand.parameters.add("a",oledbvarchar,255).value= "l'homme"
  
  Can someone help me showing me how to use parameters with tabledatasource?
  
  thank you!!!