Search Results

Search found 10481 results on 420 pages for 'identity insert'.

Page 237/420 | < Previous Page | 233 234 235 236 237 238 239 240 241 242 243 244  | Next Page >

• fastest way to copy a table in mysql

  - by Anon

  which one is the fastest way to completely copy a table on mysql ? CREATE TABLE copy LIKE original; INSERT INTO copy SELECT * FROM original; or CREATE TABLE copy SELECT * FROM original; ALTER TABLE copy ADD PRIMARY KEY (id); or theres another way ? PS. can't use command-line tools like mysqldump, must be on-the-fly.

  Read the article

• SBJson returning nil causing cocoa window to not show up

  - by Matt S.

  I'm using the example here. If there isn't a value for the key, my application returns -[NSCFArray insertObject:atIndex:]: attempt to insert nil in the console, and my window doesn't show up. How could I preform a check to make sure this doesn't happen?

  Read the article

• REBOL: How to do another task while waiting an alarm to trigger ?

  - by Rebol Tutorial

  So I have created an alarm function: alarm: func[seconds message [string! unset!]][ wav: load %attention.wav sound-port: open sound:// wait seconds do [ insert sound-port wav wait sound-port close sound-port if (value? 'message) [ print message ] ] ] which works like this: alarm 30 "Will trigger in 30 seconds" Now how can I for example show a timer which increments while waiting for the alarm since Rebol doesn't support thread ?

  Read the article

• How to add an UIImage in MailComposer Sheet of MFMailComposeViewController in iPhone

  - by rkbang

  Hi everybody, I am asking this question second time in a different manner. I want to insert UIImages inside the composer sheet of MFMailComposerViewController. Please note I dont want to attach them but I want to place them in a table using HTML code which will be the part of the email body. I am really finding it difficult to find any help online, so if anyone come across any tutorial or any kind of info plz let me know. Tnx in advance.

  Read the article

• sqlite, UPDATE OR REPLACE

  - by acidzombie24

  I do something like UPDATE OR REPLACE someTable SET a=1, b=2 WHERE c=3 I expect if it doesnt exist it will be inserted into the DBs. But nothing happens and i get no errors. How can i insert data, replace it if it already exist and use a where for the condition (instead of replacing BC of a unique ID)

  Read the article

• SQL 2008 GUID column is all 0's

  - by Andy Evans

  I'm hoping this is a simple goof I did on my end ... I have a table in my database set up like so: column name: widget_guid data type: uniqueidentifier allow nulls: false default value: newid() identity: false row guid: true When records are created (via LINQ to SQL) that the values in this field are formatted as a GUID but contain all 0's My assumption was that when a new record was created, that a guid would be autogenerated for that column, much like an auto-incrementing row id. Is this not true? Any help would be greatly appreciated. Thanks.

  Read the article

• How to build a widget for my website

  - by Gublooo

  Hey guys I'm very new to the whole programming - so far I only have experience with building websites, database etc. I currently have a website where users can share their online purchases. I want to build a widget that other websites can integrate on their site. Users should be able to insert their purchases directly through this widget without having to come to my website. Thats the idea but I have no idea how to go about it - can anyone point me in the right direction. Thanks

  Read the article

• PHP ORM's, multiple tables and efficiency

  - by sunwukung

  Let's say I have a data mapper function that aggregates multiple tables and generates an object instance from that data. The mapper has a typical save() method which delegates to update/insert. When the mapper executes save - ideally it isolates object fields that have been modified, thus preventing the code from blanket bombing the database. How would you go about this?

  Read the article

• foreign key and index issue

  - by George2

  Hello everyone, I am using SQL Server 2008 Enterprise. I have a table and one of its column is referring to another column in another table (in the same database) as foreign key, here is the related SQL statement, in more details, column [AnotherID] in table [Foo] refers to another table [Goo]'s column [GID] as foreign key. [GID] is primary key and clustered index on table [Goo]. My question is, in this way, if I do not create index on [AnotherID] column on [Foo] explicitly, will there be an index created automatically for [AnotherID] column on [Foo] -- because its foreign key reference column [GID] on table [Goo] already has primary clustered key index? CREATE TABLE [dbo].[Foo]( [ID] [bigint] IDENTITY(1,1) NOT NULL, [AnotherID] [int] NULL, [InsertTime] [datetime] NULL CONSTRAINT DEFAULT (getdate()), CONSTRAINT [PK_Foo] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] ALTER TABLE [dbo].[Foo] WITH CHECK ADD CONSTRAINT [FK_Foo] FOREIGN KEY([Goo]) REFERENCES [dbo].[Goo] ([GID]) ALTER TABLE [dbo].[Foo] CHECK CONSTRAINT [FK_Foo] thanks in advance, George

  Read the article

• Android asking for unneeded permissions

  - by steveo225

  I have an Android widget that needs internet access, fine and coarse permissions only. However, when I install the apk file, it says it also needs access to read the phone state and identity, and access to storage. It doesn't need access to either, and the only permissions that are in the mainfest are: <uses-permission android:name="android.permission.INTERNET" /> <uses-permission android:name="android.permission.ACCESS_FINE_LOCATION" /> <uses-permission android:name="android.permission.ACCESS_COARSE_LOCATION" /> Any ideas on why this is happening? Thanks for the help.

  Read the article

• Drop Item into Specific Index in ListView in WPF C#

  - by Kirk

  I have a list of files in a ListView in WPF. Users can drag files onto the list view, and right now they are just appended to the end of the list. Is it possible to insert the file into the ListView right where the user dropped it?

  Read the article

• JPA 2.0 Eclipse Link ... Composite primary keys

  - by Parhs

  I have two entities(actually more but it doenst matter) Exam and Exam_Normals Its a oneToMany relationship... The problem is that i need a primary key for Exams_Normals PK (Exam_ID Item) Item should be 1 2 3 4 5 etc.... But cant achieve it getting errors An alternative would be to: I cound use an IDENTITY and a ManyToOne relationship at Exam_Normals but that should be like PK(Exam_Normals_ID) and a reference to Exam and an extra collumn Item to keep an order.. SO 3 collumns But to avoid the alternative tried I tried with @IdClass and got errors Tried @EmbeddedID everything nothing works Any idea??

  Read the article

• Order column in a datatable

  - by superartsy

  I have two tables - Parent table (Clients- ClntID,ClntName) And Child Table ( Orders- ClntID,OrderNumber,OrderDate) - Order Number column has a value equal to how many orders the Client has. It is not an autonumber ClntID ClntName 1 Company A 2 Company B ClntID OrderNumber OrderDate 1 1 11/1/2009 1 2 11/15/2009 2 1 2/12/2008 2 1 7/13/2009 If I have a dataset for these tables, how do I insert the data in the Orders table and increment the OrderNumber value correctly.

  Read the article

• How can I display HTML code on an HTML page?

  - by Azzyh

  Example of what I want to have on my page: To make an title to your website insert <title> and end with </title>. If you want to use a div box then type <div> and end with </div> .. As you can see, I don't want it to interpret the html, but display it.

  Read the article

• Delphi plugin for pasting text constants in source code?

  - by mjn

  Inserting (pasting from clipboard) of text constants in the Delphi code editor requires some manual "postprocessing" ... split up long text into multiple lines (and insert the string concatenation symbol) escape quotes (replace single quotes with double quotes) enclose the string with quotes keep original white space (leadinng blanks, line feeds) Is there a IDE plugin available which helps to reduce these manual steps?

  Read the article

• How to use T-SQL MERGE in this case?

  - by abatishchev

  I'm new to T-SQL command MERGE so I found a place in my SQL logic where I can use it and want to test it but can't figure out how exatcly should I use it: IF (EXISTS (SELECT 1 FROM commissions_history WHERE request = @requestID)) UPDATE commissions_history SET amount = @amount WHERE request = @requestID ELSE INSERT INTO commissions_history (amount) VALUES @amount) Plase suggest the proper usage. Thanks!

  Read the article

• how to generate primary key values while inserting data into table through pl/sql stored procedure

  - by thulasi policherla

  hi friends, I am trying to insert data into particular table through pl/sql stored procedure,my requirement is while inserting i should generate PRIMARY KEY values for particular column and also i should return that PRIMARY KEY value to output and one more thing is that for another column i should validate my string such that it should contain only characters not integers. please help me in writing code for the above requirement Thanks and regards thulasi policherla

  Read the article

• combobox inserting consecutive variables

  - by asli

  Hi,I have a question about combobox.I use visual c# and I want to insert consecutive numbers (1 to 100) in combobox.How can I do this?

  Read the article

• Java - creating an oracle date field

  - by llm

  I have an Oracle Date type to which I need to insert the current date. I am using Java to generate this date but everything I've tried so far yeilds the following error: java.sql.SQLException: ORA-01843: not a valid month Can anyone suggest java code to generate a proper date?

  Read the article

• LINQ parent child relation

  - by Shane Km

  I'm working on the BLOG functionality in MVC. I need to be able to create 'blog comments'. So each comment may have a parent comment etc. Given table "Comments": CommentId - int - identity autoincrement PostId - int ParentId - int Comment - string Is there a way to get a list of comments for a given article ordered by CreateDate and ParentId? Or maybe there is a better table design you may suggest. What is the best design when inserting Post comments like this? I'm using Entity framework. thanks

  Read the article

• How to set a cell value = to whats looping?

  - by digitalgavakie

  I have this code below. How can I set a cell value to = whats looping through that value? Sub Test2() ' Select cell A2, *first line of data*. Range("A2").Select ' Set Do loop to stop when an empty cell is reached. Do Until IsEmpty(ActiveCell) ' Insert your code here. ' Step down 1 row from present location. ActiveCell.Offset(1, 0).Select Loop End Sub

  Read the article

• i have problem to get new inserted columnID using sql

  - by newBie

  hi I have an identity column defined as int in sql . I use SCPOE_IDENTITY () to get the new inserted column id. this is sample of my code: Dim sql As String = "insert into infoHotel (nameHotel, knownAs1, knownAs2, knownAs3, knownAs4, streetAddress) values (N" & _ FormatSqlParam(hotel) & ",N" & _ FormatSqlParam(KnownAs(0)) & ",N" & _ FormatSqlParam(KnownAs(1)) & ",N" & _ FormatSqlParam(KnownAs(2)) & ",N" & _ FormatSqlParam(KnownAs(3)) & ",N" & _ FormatSqlParam(StreetAddress) & _ "SELECT CAST(scope_identity() AS int)")" Dim objCommand1 As New SqlCommand(sql, conn) Dim infoID As Integer = objCommand1.ExecuteScalar() my problem here is, i cant get the infoID's value..is my code wrong?..some help plzz.. im using vb.net n sql

  Read the article

• Best Practice for Accessing SharePoint List Item through Object Model

  - by Kusek

  I would like to know the best Practice that you guys follow when it comes to access the SharePoint List Items / Doc Lib using Object Model. To start let me share few things I have found. Limit the number of Items Per container to 2K items. Use ProcessWebData method of SPWeb to do Update/Insert of Large items

  Read the article

• MySQL: LOAD DATA reclaim disk space after delete

  - by Michael

  I have a DB schema composed of MYISAM tables, i am interested to delete old records from time to time from some of the tables. I know that delete does not reclaim the memory space, but as i found in a description of DELETE command, inserts may reuse the space deleted In MyISAM tables, deleted rows are maintained in a linked list and subsequent INSERT operations reuse old row positions. I am interested if LOAD DATA command also reuses the deleted space? UPDATE I am also interested how the index space reclaimed?

  Read the article

• C: How to convert a string of ints into actual ints and store them in an array?

  - by Srinivasa Varadan

  I have a string "14 22 33 48". I need to insert each of the values in the string into the respective location in the array: int matrix[5]; so that matrix[0] = 14; matrix[1] = 22; matrix[2] = 33; matrix[3] = 48; How do I do this?

  Read the article

< Previous Page | 233 234 235 236 237 238 239 240 241 242 243 244  | Next Page >