Search DaniWeb - hints

Error: 'CITY' is not a recognized optimizer lock hints option 16 Years Ago by bajanpoet … get the error ''CITY' is not a recognized optimizer lock hints option. 'CITY' is one of the strings that would be… vRegion. How do I get rid of this Optimizer lock hints option error? :icon_confused: 'CITY' is not a recognized optimizer lock hints option 16 Years Ago by bajanpoet … get the error ''CITY' is not a recognized optimizer lock hints option". I'm trying to populate a datagrid with… @CustTable. How do I get rid of this Optimizer lock hints option error? (BTW - the original request was placed in the… Re: Error: 'CITY' is not a recognized optimizer lock hints option 16 Years Ago by rapture Maybe the others will have more info 1. Please use code tags when supplying code (it's easier to read) 2. Appears to be a SQL problem - try searching "is not a recognized optimizer lock hints option" and there is a ton out there Comparing Hints 18 Years Ago by hari_bk Hi How to see the diffrence in terms of resources or response time between ALL_ROWS and FIRST_ROWS hints? Can we track the diffrence anywhere? Thanks Re: Comparing Hints 18 Years Ago by jim mcnamara First off, hints can be overridden by the Oracle optimizer. Just so you … Hw-hints 17 Years Ago by koketa … daniweb. I was hoping that someone would give me some hints on where to put the running total and how to… Designing website as a graphic - any hints? 17 Years Ago by Labby77 … handle on this. Can any one offer a few tips, hints or references? Some of my initial questions would be: - is… Firefox 2 Showing Odd Search Hints 17 Years Ago by linux …" gives me "trishakrishnan", and some other weird hints. When I press search, it searches fine. It's just… Any hints on how to do this? 16 Years Ago by Q8iEnG … ) I've stopped :\ didn't know what to do!! Any hints on how to do it? Thanks :) What should I do first ?need some Hints 14 Years Ago by joss23 … Java has a class Could you guys give me some hints.. Any helpful hints or nudges on Array decoding for a frustrated newbie? 13 Years Ago by tabbyheart … be doing. What I would hopefully like would be some hints or nudges in the right direction to go with this… Hints about Java Telephony API ! 16 Years Ago by knowledgelover Hi there, have anyone experience with the Telephony API, and can help please?, I have googled about it, and I get downloaded all possible files but I still having problem in understanding some of the connectivity issues, should the PBX I am using in system be compatible with the JTAPI, I am using Asterisk, phones in the telephony system … Re: Error: 'CITY' is not a recognized optimizer lock hints option 16 Years Ago by bajanpoet Sorry about the code tags... I tried using them, but I guess they didn't come out as I expected.... I'll do some more digging on this error. Thanks. Re: Error: 'CITY' is not a recognized optimizer lock hints option 16 Years Ago by rapture let us know if you get stuck, you might also try the SQL thread. If you fix it let us know that as well and mark the thread as solved when you do get it. to do code tags in the future its [] with code in the middle at the start and /code in the middle at the end Re: Error: 'CITY' is not a recognized optimizer lock hints option 16 Years Ago by bajanpoet Thanks. I'll check out the SQL thread too. Thanks a lot Re: Error: 'CITY' is not a recognized optimizer lock hints option 16 Years Ago by bajanpoet [QUOTE=bajanpoet;788338]Thanks. I'll check out the SQL thread too. Thanks a lot[/QUOTE] Could someone help me find where to place the SQL question? I don't see a specific SQL forum... Re: 'CITY' is not a recognized optimizer lock hints option 16 Years Ago by Ramy Mahrous If you traced the SQL Command sent, you'll find it doesn't surround the state within single quotes [B]'[/B] What you need is to modify it [icode]Dim SQLComm = New SqlCommand("SELECT * FROM ViewCustomers('" & vRegion & "')", conn)[/icode] Re: Error: 'CITY' is not a recognized optimizer lock hints option 16 Years Ago by Ramy Mahrous If you traced the SQL Command sent, you'll find it doesn't surround the state within single quotes [B]'[/B] What you need is to modify it [icode]Dim SQLComm = New SqlCommand("SELECT * FROM ViewCustomers('" & vRegion & "')", conn)[/icode] Re: 'CITY' is not a recognized optimizer lock hints option 16 Years Ago by bajanpoet wow... I didn't see that... you're right! I'll modify it and get back to you... give me a sec... Re: 'CITY' is not a recognized optimizer lock hints option 16 Years Ago by bajanpoet I seem to have gotten past that problem... now it says [code] InvalidCastException Unable to cast object of type 'System.Data.SqlClient.SqlDataReader' to type 'System.Data.SqlClient.SqlDataReader[]'.' [/code] looking at the same ExecuteReader command [icode] r = SQLComm.ExecuteReader()[/icode] Re: Error: 'CITY' is not a recognized optimizer lock hints option 16 Years Ago by Salem Asked here - [url]http://www.daniweb.com/forums/thread171525.html[/url] Re: Error: 'CITY' is not a recognized optimizer lock hints option 16 Years Ago by bajanpoet Thanks, Salem... I was encouraged to ask it in the SQL forum... didn't remember to update this thread. Sorry!!! *embarrassed* Re: Error: 'CITY' is not a recognized optimizer lock hints option 16 Years Ago by rapture Ramy's code fixed the problem? Re: Error: 'CITY' is not a recognized optimizer lock hints option 16 Years Ago by bajanpoet sorta... now I got another one. The original problem is fixed, but now I'm getting another... here's a quote... [QUOTE=bajanpoet;789210]I seem to have gotten past that problem... now it says [code] InvalidCastException Unable to cast object of type 'System.Data.SqlClient.SqlDataReader' to type 'System.Data.SqlClient.SqlDataReader[]'.' [/code… Re: 'CITY' is not a recognized optimizer lock hints option 16 Years Ago by Ramy Mahrous It works fine [code=vb.net] Dim r As SqlClient.SqlDataReader r = SQLComm.ExecuteReader() dgCustomers.DataSource = r [/code] Re: Error: 'CITY' is not a recognized optimizer lock hints option 16 Years Ago by Ramy Mahrous It works my friend, I just put the answer here too because it's also related to VB.NET [code=vb.net] Dim r As SqlClient.SqlDataReader r = SQLComm.ExecuteReader() dgCustomers.DataSource = r [/code] Re: 'CITY' is not a recognized optimizer lock hints option 16 Years Ago by Ramy Mahrous Please mark both threads as solved, if it's :) Re: Error: 'CITY' is not a recognized optimizer lock hints option 16 Years Ago by bajanpoet It works! Thanks! But why???? lol I already have the [icode]Imports System.Data.SqlClient [/icode] at the top of my code... so isn't using the [icode]Dim r As SqlClient.SqlDataReader[/icode] redundant? I'll mark it as solved now, but I'm asking for future reference Re: 'CITY' is not a recognized optimizer lock hints option 16 Years Ago by bajanpoet I will... thanks! Should I post another question concerning why the datagrid isn't showing up the data from the function, or should I ask it here? Re: 'CITY' is not a recognized optimizer lock hints option 16 Years Ago by Ramy Mahrous Another thread because we can made a reference to this if anyone has a problem calling UDF in VB.NET