SQL database

Hot Topic

What about Datarepaeter?
Newbe question, incrementing a value
Serial Port Read Hangs
Quest about compiling string content
textbox_gotfocus event to event handler
How to get and/or set IP address?
External Tools
Benefit Portal
Resource file
Music in my game in C# EE

VS Express Editions

stupid newbie needs help with serial port communication
notepad
windows services
Filling remote web form fields with C#
Setting printer paper size? Please...
How can I make text flash using Graphics.DrawString
Form close and BackgroundWorker
Connecting to FTP server
[Resolved] Completing Installation for Visual Web Dev.?
Looking for a good c++ book.

SQL database

hey guys,

im just learing how to program...im working through bob tabors tutorials for visual basic 2005 express edition. im on lesson 8 which starts to deal with SQL databases.

the problem comes when ive added a new database and when i add a new table and start uptting in information, i cant set a "primary key". the button for doing this is greyed out, as are all the other buttons in the "table designer" toolbar. does anyone have any ideas why all the buttons are greyed out

thanks for any help!

Answer this question

SQL database

  • slawekr

    What build are you using

  • ShadowChaser

    hey lance,

    what you suggested partially helped. right clicking did allow me to set the primary key. but when the right-click menu was open the buttons in the top left of the screen in the "table designer" toolbar became coloured, but when the right click menu was closed the buttons became grey again.

    i dont understand this at all. any help would be great!

  • Hong bo Dai

    Hi,

    is you datatype integer of the column that shall be your primary key


  • JonPom

    It's most likely that you have something other that the row you want to set as the primary key selected.  In order for the button to be highlighted, you must select the row in the table designer which will be the primary key.  Then, the button should highlight.  In addition to the button, you can also use the menu or right click.  The simplest way to do it is to right click on the column you want to set as the primary key.  That will bring up a context menu.  The top menu item will be "Set Primary Key".  Simply select it and then it should show the row as the primary key.  Hope this helps.

  • jumpingjahelziphat

    If you have set focus inside the table designer, then, the icons should be enabled.  I'm not exactly sure what is going on since I can't see.  However, I suspect that somehow you must be setting focus outside the table designer once you right click and set the primary key. 

  • Roland Hasenöhrl

    hey,

    ive tried all data types. but the problem isnt just the primary key button, NONE of the buttons in the table designer toolbar are clickable. so idont know whats wrong with it.
  • SQL database
Answer this question