Tagged Questions

A mixed flavour of data entry mode and data modification mode. It can be used when insert is required for case of non-existing data and modification if data exists.

learn more… | top users | synonyms

0
votes
0answers
3 views

How to update embedded document?

How to update the text of second comment to "new content" { name: 'Me', comments: [{ "author": "Joe S.", "text": "I'm Thirsty" }, { "author": "Adder K.", ...
-3
votes
0answers
13 views

how can I decode one table of db(mysql)

I need to know How can I decode a table or if it can't do it the form to encode the data when is insert it with pdo. I am working in a project of one client with this type of db...and to be honest I ...
0
votes
0answers
28 views

Excel VBA - “insert into” the field with numeric or integer format

I'm trying to run a SQL command to insert into the worksheet. The procedure executes correctly. But the column ID_FIELD is inserted as text, not as an integer or numeric. SQLRun("INSERT INTO ...
0
votes
1answer
22 views

Update and Insert statements in one stored Procedure and only one works

I have a table from which the data cannot essentially be removed. So whenever I update a record, I have to preserve the previous record and copy the new details in a new row. I have created a stored ...
0
votes
0answers
12 views

Update - Select on same table creating deadlock

I am finding it difficult to find solution for this deadlock. The select query is taking shared lock over index I_SEM_AGENT_COMPUTER_ID_PLUS, at the same time update query updates a record (say r1) in ...
0
votes
0answers
17 views

Cannot update the data values in new column

I faced a strange problem with a database when trying to add new column(nullable bit) to existing big table. After creating it, I was not able to update the values of the new column for any of the ...
0
votes
0answers
21 views

MySQL How to update updated_by field only when new data is saved or inserted

I have a frontend PHP application which will save data in a MySQL database. The updated_by value will change since it will be the user who is updating the record. I would like to update the updated_by ...
0
votes
2answers
53 views

LINQ To SQL Include existing object in insert

In this method, I am inserting a new item (Room) into the database. That process functions as expected. But, in addition to that, each time I add a room, I want to add a piece of furniture as the ...
-3
votes
2answers
42 views

ORA-01779 canon modify a column which maps to a non key-preserved table [closed]

create or replace view cv_vallist_all as select S.BRN_ID, S.CODE, S.CONSTVAL, S.GENMODE, S.CONSTCODE, substr (nvl(L.SHORTNAME,S.SHORTNAME), 1, 10) as SHORTNAME, S.ARCFL, substr ...
0
votes
1answer
16 views

Update user's email in Orchard

I want to allow users to update their email, so I have controller : [HttpPost] public ActionResult ChangeEmail(string newEmail) { IUser user = _services.WorkContext.CurrentUser; if ...
0
votes
3answers
36 views

can not word with the insert query to insert id using php

i have 2 tables district district_id district_name and village id village _name district_id i want to insert values to the table .. the query work well with insert the value of the village ...
1
vote
1answer
31 views

Error in my SQL statement (UPSERT)

I'm trying to do an UPSERT (since that's what it appears to be called) and I'm getting an error: Microsoft JET Database Engine error '80040e14' Syntax error (missing operator) in query expression ... ...
1
vote
1answer
16 views

MongoDB - Dynamically update an object in nested array

I have a document like this: { Name : val AnArray : [ { Time : SomeTime }, { Time : AnotherTime } ...arbitrary more elements } I need to update "Time" ...
2
votes
1answer
45 views

MySQL ON DUPLICATE KEY UPDATE while inserting a result set from a query

I am querying from tableONE and trying to insert the result set into tableTWO. This can cause a duplicate key error in tableTWO at times. So i want to ON DUPLICATE KEY UPDATE with the NEW determined ...
0
votes
1answer
25 views

insert values in 3 table if the values do not exist or update it if ixist

i have 3 table governorate district village and i want to be able to insert in each one of them values ... but i need to check first if the user input is not empty for the governorate field to be able ...

1 2 3 4 5 … 23
15 30 50 per page