Search Results

Search found 18489 results on 740 pages for 'key'.

Page 114/740 | < Previous Page | 110 111 112 113 114 115 116 117 118 119 120 121  | Next Page >

• How to Auto-Increment Non-Primary Key? - SQL Server

  - by user311509

  CREATE TABLE SupplierQuote ( supplierQuoteID int identity (3504,2) CONSTRAINT supquoteid_pk PRIMARY KEY, PONumber int identity (9553,20) NOT NULL . . . CONSTRAINT ponumber_uq UNIQUE(PONumber) ); The above ddl produces an error: Msg 2744, Level 16, State 2, Line 1 Multiple identity columns specified for table 'SupplierQuote'. Only one identity column per table is allowed. How can i solve it? I want PONumber to be auto-incremented.

  Read the article

• Can I set ignore_dup_key on for a primary key?

  - by Mr. Flibble

  I have a two-column primary key on a table. I have attempted to alter it to set the ignore_dup_key to on with this command: ALTER INDEX PK_mypk on MyTable SET (IGNORE_DUP_KEY = ON); But I get this error: Cannot use index option ignore_dup_key to alter index 'PK_mypk' as it enforces a primary or unique constraint. How else should I set IGNORE_DUP_KEY to on?

  Read the article

• Easiest way to get Enum in to Key Value pair.

  - by vijay.shad

  Hi, I have defined my Enums like this. public enum UserType { RESELLER("Reseller"), SERVICE_MANAGER("Manager"), HOST("Host"); private String name; private UserType(String name) { this.name = name; } public String getName() { return name; } } What should be the easiest way to get a key-value pair form the enum values?

  Read the article

• Is there a standard way to run a x509 key server?

  - by chotchki

  Does anyone know of a project / product that has standardized how to access/download x509/SSL certificates over HTTP? I have seen RFC 4387 but haven't found anyone who implements it. Basically, I am trying to setup a key server for an internal application. So short of implementing my own, does anyone have any suggestions?

  Read the article

• How do you send a key command using an NSTimer to a hidden application?

  - by Magician Software

  I am trying to write an app for Toontown that will send the "end" key when the application is minimized or hidden. How do I do this. I cant figure it out Thanks

  Read the article

• How to reassign a missing shortcut key to a new one?

  - by Raghu

  Hi All, Previously Ctrl + D was assigned to an application by a shortcut on Desktop. The shortcut is now deleted but shortcut key is still assigned to the same application. I need to reassign Ctrl + D to a new application. Regards and Thanks,

  Read the article

• how can I do something before current activity go background by Back key?

  - by backspace7

  When back key is pressed, current activity goes background. I'd like to show a popup and let user choose really close this activity, before current activity go background. I tried to override onStop(), but it's called after activity goes back. Please somebody explains me how to do that?

  Read the article

• (Database Design) why in the database tables most of the times primery key name is: <tablename_id> a

  - by meyosef

  Hi, why in the database tables most of the times primery key name is: tablename_id and not id? example: user_id and not just id. Thanks

  Read the article

• How can I set a default sort for tables in PHPMyAdmin (i.e. always "Primary key - Descending")

  - by jeremyclarke

  Even though its obnoxious in a lot of ways I use PHPMyAdmin all the time to debug database issues while writing PHP. By default it sorts tables by primary key ascending. 99% of the time I would rather have the newest data (my test data) shown at the top by default rather than the useless first few records ever saved. Is there a way to configure PHPMyAdmin to show the newest records by default? To alter similar behavior?

  Read the article

• How do you fix a MySQL "Incorrect key file" error when you can't repair the table?

  - by Wayne M

  I'm trying to run a rather large query that is supposed to run nightly to populate a table. I'm getting an error saying Incorrect key file for table '/var/tmp/#sql_201e_0.MYI'; try to repair it but the storage engine I'm using (whatever the default is, I guess?) doesn't support repairing tables. how do I fix this so I can run the query?

  Read the article

• Are there special key events in Windows I can't handle?

  - by Orit

  Are there any key events I cannot handle in my C# program? For example, can I implement differently Windows's events: Ctrl+Alt+Del, Alt+Tab, WindowsKey+D, etc.

  Read the article

• In a given Json, search for the particular given string based on key, return true if found, else false Using jQuery/Javascript

  - by NaanuManu

  Given JSON String/object {"selectAll":false,"include":{"country_197":{"id":"197","data_type":"country","name":"Singapore","desc":"","parent_key_id":"all_all","status":""},"country_100":{"id":"100","data_type":"country","name":"India","desc":"","parent_key_id":"all_all","status":""}},"exclude":{"state_2":{"id":"2","data_type":"state","name":"Andhra Pradesh","desc":"","parent_key_id":"country_100","status":""}}} Given search string is: country_100 Required : Have to search for country_100 in Given JSON String/object by key parent_key_id Ex: searching country_100 is found : {"selectAll":false,"include":{"country_197":{"id":"197","data_type":"country","name":"Singapore","desc":"","parent_key_id":"all_all","status":""},"country_100":{"id":"100","data_type":"country","name":"India","desc":"","parent_key_id":"all_all","status":""}},"exclude":{"state_2":{"id":"2","data_type":"state","name":"Andhra Pradesh","desc":"","parent_key_id":"**country_100**","status":""}}} So return True, else return false please help me in finding a solution.

  Read the article

• how to use Foreign key in L2E or EF when needs insert?

  - by 5YrsLaterDBA

  I know during the retrieve, I can use Include() to load related Entities (http://stackoverflow.com/questions/2632323/how-to-use-foreign-key-in-l2e-or-ef). but when I want to save or insert data, how to handle those reference Entities?

  Read the article

• Is there a clever way to pass the key to defaultdict's default_factory?

  - by Paul Oyster

  A class has a constructor which takes one parameter: class C(object): def __init__(self, v): self.v = v ... Somewhere in the code, it is useful for values in a dict to know their keys. I want to use a defaultdict with the key passed to newborn default values: d = defaultdict(lambda : C(here_i_wish_the_key_to_be)) Any suggestions?

  Read the article

• SQL Server: Deleting Rows with Foreign Key Constraints: Can Transactions override the constraints?

  - by Mark Redman

  I have a few tables where Foreign Key constraints are added. These are used with code generation to set up specific joins in generated stored procedures. Is it possible to override these constraints by calling multiple deletes within a transaction, specifically "TransactionScope" in C# or is cascaded deleting absolutely required?

  Read the article

• WPF Binding to Items within a dictionary by key?

  - by Sonic Soul

  ok.. so i noticed (by trial and error) that i can bind to a collection item using index: <TextBlock FontStyle="Italic" Text="{Binding Path=Exchanges[0].Name}" /> but what about using a dictionary key? Path=Exchanges['AMEX'].Name

  Read the article

• How does Dictionary<T> work with key objects that don't implement Equals and GetHashCode?

  - by DayOne

  If I place a key object in an Dictionary that doesn't implement Equals and GetHashCode how does the Dictionary ContainsKey work? By checking the references are equal? Thanks

  Read the article

• Can "Distinct" key Word be used twice in a single Select Query?

  - by OM The Eternity

  Can "Distinct" key Word be used twice in a single Select Query? like wise: select DISTINCT(trackid), DISTINCT(table_name) from jos_audittrail where live = 0 AND operation = UPDATE Thanks

  Read the article

• Why single primary key is better than composite keys?

  - by piemesons

  Why is the rejection of composite keys in favor of all tables using a single primary key named id. Cause generally all ORM follow this..???

  Read the article

• c# Using WPF and .net 3.5, how can i register a global hot key to say CTRL+SHIFT+(LETTER)

  - by dubayou

  Im building an app in c# using WPF and i need it to bind to some keys. Ive found some links but not work well with my setup. Anyone done this before? also if i could bind to the windows key would be great.

  Read the article

• How can I make the Tab key move focus out of a NSTextView?

  - by Steve McLeod

  I'm using an NSTextView to allow multi-line input. However, due to the nature of my app, users will be more comfortable moving to the next input element when they press TAB. How can I make TAB exit the NSTextView, while keeping the newline behaviour of the Enter key?

  Read the article

• MYSQL Insert: How to save Query in the database only one time - duplicate key doesn't work!

  - by elmaso

  hello, I want to save a query only one time in the database, this is my code: $querystat = mysql_real_escape_string($_GET['q']); $datetime = time(); if( ($querystat != $_SESSION['prev_search']) OR ( ($datetime - $_SESSION['datetime']) > 60) ) { $insertquery = "INSERT INTO `query` ( `searchquery` , `datetime`) VALUES ( '$querystat' , '$datetime') ON DUPLICATE KEY UPDATE searchquery='$querystat';"; mysql_query($insertquery, $db); } maybe something with == 0 ?

  Read the article

• INSERT ... ON DUPLICATE KEY UPDATE with WHERE?

  - by Raven

  Hi! I'm doing a INSERT ... ON DUPLICATE KEY UPDATE but I need the update part to be conditional, only doing the update if some extra condition has changed. However, WHERE is not allowed on this UPDATE. Is there any workaround for this? I can't do combinations of INSERT/UPDATE/SELECT since this needs to work over a replication.

  Read the article

• Maximum Length for a foreign key in DB2? (SQL0107N)

  - by IronGoofy

  We have two installations of DB2. When defining a foreign key with a long name, it works fine on one instance, but not on the other (we get a SQL0107N Name too long - max length is 18). What is causing this different behaviour? Is there a parameter we can change or is it version dependant?

  Read the article

• Is there a way to convert a Non-Clustered Index on a Primary Key to a Clustered one? (sql-server 200

  - by Lieven Cardoen

  With Management Studio I can't alter the index. Dropping it doesn't work because it's being used as a foreign key in a lot of other tables. Can I somehow alter it? Or how would you do this?

  Read the article

< Previous Page | 110 111 112 113 114 115 116 117 118 119 120 121  | Next Page >