Why advanced sql generation option disabled

I just put in a primary key into table and all working fine. Does that mean you cant insert into any table without it having a primary key.

NET 2. So I have a background in the general priciples. I am having a problem with using one of my existing access databases with the advanced SQL tools in the gridview tool, and the others for that matter but I have mainly tested with gridview tool. I connect to the database using the wizard but when I get to the part where I can "Configure the Select Statement" depending on what table I am trying to get the data from, if I click on the advanced button to allow the gr However, both of the options are disabled.

Any idea why? I'm using VS Is this one of those bugs in VS08? Hi, this can be caused by many reason: 1- your seelct statement span many tables use joins , union Regards,Anas Ghanem. Note:Please Don't hesitate to click "Report Abuse" link if you noticed something wrong on the forums like duplicate ,Off-topic,offensive,or a I was just running him through a way of creating a database this database was converted from Access to SQL using the upsize wizard.

I then created a database from scratch and same problem occured - any reason why or did i miss something out? Thanks Whooooooooooooops all i need Is there a setting or something I need to do to get this to option working. I tryied it with Formsview and Dataview with no luck. Hi, Most likely the reason generating Insert, Update, and Delete statements option is grey out because the table you're using doesn't has a primary key. Achieve the next productivity level. SQL Complete.

Download Buy now. Download Buy Now. View SQL Complete in action. Key Features. Learn more. T-SQL Refactoring This feature allows you to improve code readability by giving meaningful and self-explaining names to tables, columns, temporary tables and columns, views, stored procedures, and functions. Productivity Boost your productivity when creating, refactoring, modifying, and beautifying the code using a rich set of features: Capabilities: Data Grid commands Grid aggregates Jump between queries Tab coloring.

SQL Code Formatting Create new formatting profiles or customize the existing ones to meet your needs. Capabilities: Formatting profiles Formatting settings Formatting in files and directories Disabling formatting for a certain part of the code Bulk formatting With the SQL script formatter, you can work with either new or existing code.

See the differences in code before and after formatting SQL Complete helps users create, customize, and switch between formatting styles, share them with their colleagues, as well as manage and easily format SQL scripts by applying various formatting options. Explore all features. Much faster work SQL Complete is designed to increase productivity. Coding standards Have you ever faced a problem when developers within your team invent their own SQL coding standards? Why SQL Complete is worth trying.

Show more Show less. Does that mean you cant insert into any table without it having a primary key. NET 2. So I have a background in the general priciples. I am having a problem with using one of my existing access databases with the advanced SQL tools in the gridview tool, and the others for that matter but I have mainly tested with gridview tool.

I connect to the database using the wizard but when I get to the part where I can "Configure the Select Statement" depending on what table I am trying to get the data from, if I click on the advanced button to allow the gr Advanced SQL Generation Options Hi all I have seen a couple of posts of how to fix this problem but I dont have a clue what they are talking about, I cannot find the screens and such.

Any one have a clear way of correcting this bug? I have Visual web developer express installed on three computers and they are all the same way. I have tried to uninstall and reinstall but all of the old settings are still there. Is there a way to revert to the original settings. I have watched the videos from visualstudio. I have the grasp or programing, its not hard. But I cannot update the or add anything new My problem is that this screen is all greyed out.

Why is that so? Could it be my connection string? Love your help on this. I cannot update my db without this screen fixed. During configurating the sql source right, when I am at the advanced sql generalisation options, I am unable to mark a tick on the Generate Insert, Update and Delete statement. I would like to knoiw how can i solve this prob: Thanks! You need to set a primary key for your table and select it to see the advanced options active. Remove From My Forums. Asked by:.

Archived Forums. Windows Forms Data Controls and Databinding. Sign in to vote. Hi, I am using Visual Studio Thanks, Keith. Sunday, January 22, AM. I have the same problem, hopefully someone can help with this. Proposed as answer by i am a engineer, i am working in a software compan Sunday, July 18, AM. Monday, January 23, PM. Hi- Here's a link to a blog that goes into this search for "advanced", it's almost halfway down a long page.

Apparently far and away the biggest cause is that there is no primary key for the table defined in the db my problem too. I had a unique key, but not a primary.