# Multi Row Data results issue **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [April 5, 2010, 8:52am UTC](https://forums.toadworld.com/t/multi-row-data-results-issue/6182 "2010-04-05T08:52:43Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Kimberly](https://avatars.discourse-cdn.com/v4/letter/k/f4b2a3/32.png) [@Kimberly](https://forums.toadworld.com/u/Kimberly)\ **Post date:** [April 5, 2010, 8:52am UTC](https://forums.toadworld.com/t/multi-row-data-results-issue/6182/1 "2010-04-05T08:52:43Z")
I’m using Toad as a trial product seeing if we’d like to purchase this software for query use. Currently we use Excel to query the data. So far I LOVE the interface. it has a lot more bells and whistles than just Excel. HOWEVER… My problem is that I’m getting a ton of rows back that are blank or with garbage data. I have compared the SQL syntax to that of excel and it’s exactly the same. WHY is this happening. I’m connecting to the DB with ODBC. And the “blank” results vary – sometimes I get like 50 per real item or just 25. I’m sure I’m missing something simple – Please help!!! Here is an example of the garbage I’m getting back: INVOICE CRUISE 555555 XXX100910 ---
**Author:** ![MichaelG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/michaelg/32/92_2.png) [@MichaelG](https://forums.toadworld.com/u/MichaelG)\ **Post date:** [April 5, 2010, 9:07am UTC](https://forums.toadworld.com/t/multi-row-data-results-issue/6182/2 "2010-04-05T09:07:45Z")
What database are you connecting to? ---
**Author:** ![Kimberly](https://avatars.discourse-cdn.com/v4/letter/k/f4b2a3/32.png) [@Kimberly](https://forums.toadworld.com/u/Kimberly)\ **Post date:** [April 5, 2010, 9:11am UTC](https://forums.toadworld.com/t/multi-row-data-results-issue/6182/3 "2010-04-05T09:11:19Z")
I’m connecting to a SQL server DB via ODBC. I’m also getting this error at times: System.FormatException Input string was not in a correct format. Stack Trace: at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt) at Quest.Toad.NativeOdbc.UnManagedColumnDescriptor.GetBufferDataAsDecimal(UInt16 rowOffset) at Quest.Toad.NativeOdbc.OdbcDataReader.GetValue(Int32 i) at Quest.Toad.Db.Connection.ReadRow(IDataReader reader, FastTable datatable, FastReadOptions options, PrePostProcessHandler prePostProcessHandler) at Quest.Toad.Db.ToadDataAdapter.InternalReadBackground() ---
**Author:** ![MichaelG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/michaelg/32/92_2.png) [@MichaelG](https://forums.toadworld.com/u/MichaelG)\ **Post date:** [April 5, 2010, 9:43am UTC](https://forums.toadworld.com/t/multi-row-data-results-issue/6182/4 "2010-04-05T09:43:03Z")
Can you go into the connection properties and click on the advanced tab and change the block cursor size option to “1” and let me know if that helps? Can I ask why you are using the ODBC connection to SQL Server over the [ADO.NET](http://ADO.NET) based connection? Let me know if this exception still occurs after changing the block cursor size. Thanks. ---
**Author:** ![Kimberly](https://avatars.discourse-cdn.com/v4/letter/k/f4b2a3/32.png) [@Kimberly](https://forums.toadworld.com/u/Kimberly)\ **Post date:** [April 5, 2010, 9:49am UTC](https://forums.toadworld.com/t/multi-row-data-results-issue/6182/5 "2010-04-05T09:49:41Z")
That worked!!! THANKS!! um… this might be a dumb answer… but i’m using ODBC because that’s what my IT department set up for me to connect the DB. Is there a better way to connect??? FYI I have some DBs located onsite and other is another state and I have to use Terminal Server to connect – does this product work on TS? ---
**Author:** ![Kimberly](https://avatars.discourse-cdn.com/v4/letter/k/f4b2a3/32.png) [@Kimberly](https://forums.toadworld.com/u/Kimberly)\ **Post date:** [April 5, 2010, 9:52am UTC](https://forums.toadworld.com/t/multi-row-data-results-issue/6182/6 "2010-04-05T09:52:17Z")
Another question… Is there a way to make the tables auto link on keys and save any that I have to create because the field names that are different but that is how the tables link? ---
**Author:** ![MichaelG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/michaelg/32/92_2.png) [@MichaelG](https://forums.toadworld.com/u/MichaelG)\ **Post date:** [April 5, 2010, 11:06am UTC](https://forums.toadworld.com/t/multi-row-data-results-issue/6182/7 "2010-04-05T11:06:08Z")
Glad to hear it worked. When creating a connection you should be able to select “SQL Server” (non Freeware edition) instead of “ODBC”. Using the SQL Server connection will generally give you much better performance over the equivalent ODBC connection. I don’t normally run TDA in a Terminal Services environment but I suspect it will run without issue. Please give it a try and if you have any issues please feel free to post a comment or contact me directly. Thanks. ---
**Author:** ![MichaelG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/michaelg/32/92_2.png) [@MichaelG](https://forums.toadworld.com/u/MichaelG)\ **Post date:** [April 5, 2010, 11:19am UTC](https://forums.toadworld.com/t/multi-row-data-results-issue/6182/8 "2010-04-05T11:19:45Z")
If you are using the Query Builder and you have foreign keys setup on the tables that you pull in, the QB should automatically create the join between those tables. If you create the relationships manually, saving the QB file will retain the relationships that you create for that query. Let me know if that answers your question. Thanks. ---
**Author:** ![Kimberly](https://avatars.discourse-cdn.com/v4/letter/k/f4b2a3/32.png) [@Kimberly](https://forums.toadworld.com/u/Kimberly)\ **Post date:** [April 5, 2010, 11:30am UTC](https://forums.toadworld.com/t/multi-row-data-results-issue/6182/9 "2010-04-05T11:30:47Z")
I’m using the QB and when I pull the tables in it isn’t automatically joining on the primary key… is there a step I’m missing before I run the query? Example: Table one: Sales Field Cruise Field Agent Table two: Cruise Field Cruise (pk) Table three: Agent Field Agtcode (pk) Shouldn’t it link the cruise fields automatically? Now the Agent and Agtcode fields – I would expect to have to link separately as they don’t have the same name. Thanks… 😃 ---
**Author:** ![MichaelG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/michaelg/32/92_2.png) [@MichaelG](https://forums.toadworld.com/u/MichaelG)\ **Post date:** [April 5, 2010, 11:43am UTC](https://forums.toadworld.com/t/multi-row-data-results-issue/6182/10 "2010-04-05T11:43:32Z")
Does table one have foreign key relationships to the other two tables? ---
**Author:** ![Kimberly](https://avatars.discourse-cdn.com/v4/letter/k/f4b2a3/32.png) [@Kimberly](https://forums.toadworld.com/u/Kimberly)\ **Post date:** [April 5, 2010, 11:57am UTC](https://forums.toadworld.com/t/multi-row-data-results-issue/6182/11 "2010-04-05T11:57:22Z")
No they do not. So I guess that answers the overall question. Now… is this something that the developer would have to do or can I build something in toad to keep these relationships without affecting the actual DBs. Also, is there a way to lock down toad so that it doesn’t allow the user to “edit” the data just view it and so on… ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [April 5, 2010, 12:51pm UTC](https://forums.toadworld.com/t/multi-row-data-results-issue/6182/12 "2010-04-05T12:51:52Z")
If you use the ER Diagram and manually draw the relationships these are retained in the Annotation Cache. This cache can be shared by a team(See Help File). The ER Diagram can then be sent to the Query Builder as a template to start a Query and automatically adds the tables and relationships. Regarding “edit”: You can accomplish this is two ways. You can install the application as Read-Only. There is an option when installing and this can be done on the command line as well. If you want to implement Read-Only differently for each user and server, we have Toad Security so you can set this up. Most users like to just use the Read-Only install. This prevents grids from updating as well as preventing execution of any insert, update, delete or Create statement. If you truly only want a non-editable grid, there is a read-only option for just grids in the Options. Search for ‘Read-Only’ and you will find it. Debbie ---
**Author:** ![MichaelG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/michaelg/32/92_2.png) [@MichaelG](https://forums.toadworld.com/u/MichaelG)\ **Post date:** [April 5, 2010, 12:54pm UTC](https://forums.toadworld.com/t/multi-row-data-results-issue/6182/13 "2010-04-05T12:54:11Z")
It would be something that the developer would have to do. Yes, when installing the application there is an option for “read only” mode. You can read more about it on this thread: [http://tda.inside.quest.com/thread.jspa?threadID=9929&tstart=-2](http://tda.inside.quest.com/thread.jspa?threadID=9929&tstart=-2) Thanks.