InfoPath Dev

Add me to the list of people who feel stupid.   I was working with InfoPath 2007 in my old job, and we had edited the SQL query in order to sort the results.  Now that I'm at a new job, with InfoPath 2013 on my desktop, I lost access to my old notes.  So I was going to come here to find how to modify the query so ...

I am creating a data connection to an SQL server. The stock data connection tools works fine, except the table I'm connecting to has 48K rows, and grows constantly. I'd like to filter the amount of data that is sent. As such, I have a couple of questions.  I don't want to use code in my solution. I don't control the ...

 I don't know if this is your issue, but when I was querying a SharePoint list, it only returned the number of items in the default view.  See if the default view for that list displays everything on the first screen.

 I am creating a data connection to an SQL server. The stock data connection tools works fine, except the table I'm connecting to has 48K rows, and grows constantly. I'd like to filter the amount of data that is sent. As such, I have a couple of questions.  I don't want to use code in my solution. I don't control ...

I should haven noticed when I first read your answer, but it looks like an InfoPath 2010 answer, not a InfoPath 2007 answer.  There is no ribbon for me to use. When I go to Default Values, I don't have any options that give me a certain number of rows.  I'm going to go into more detail as to what I want. I want a table with X ...

I like it, except it's hardly elegent.  (I was brought up in the bad days, when code had to be elegent.  Developed bad habits.) Is there a way to zero out the data columns in the hidden rows?  I'm considering the possibiity that data is entered in a row, and then one of the days changes, hiding the row.

I've been wracking my brain trying to do this without code, but have failed.  So I'm here, asking for help.  (If it can only be done through code, VB would be preferable. But beggars can't be choosers.) I am attempting to create a repeating table with a specific number of rows.  In the first column of the repeating ...