All Questions
87
questions
0
votes
1
answer
120
views
2 tables in one gallery but view different titled columns
Morning all,
I am creating an app from 2 SPL. The fist list is an action item tracker, and the second list contains all the updates for those items. (this is to keep all historic updates and not loose ...
-1
votes
1
answer
31
views
How do I import updated Wordpress product descriptions?
I have a CSV file with 500 rows and two columns: product id and description. How would I go about updating the descriptions in Wordpress with SQL? I am pretty decent with SQL but not sure what fields ...
- 291
0
votes
0
answers
98
views
Two duplicate rows | Laravel BUG
it is possible that there are two duplicate rows of my database, exactly identical.
In the function I used for its creation I called once $ resource-> save () and a few times $ resource-> update ...
0
votes
1
answer
173
views
Migrate database from hybris version to another hybris updated version
i've just finished upgrade in my local env (hybris 1811 to 2105). After compiling and deploy the new version in qas, we've noticed that some things don't work as they should. When i deploy in the ...
0
votes
0
answers
28
views
Symfony existing table error when updating database
I have the database entities in my Symfony application, I have created another table in the database and I want to download it as an entity in my program. When I execute the following line I get that ...
- 43
0
votes
2
answers
239
views
How to update the value to the nested object array in mongodb document?
I have following document on which the update needs to be done.
{
"_id": "Colorcode_1",
"Combination": [
{
"color&...
- 321
0
votes
0
answers
66
views
How to tackle this error Microsoft.EntityFrameworkCore.DbUpdateConcurrencyException?
Message:
Database operation expected to affect 1 row(s) but actually affected 0 row(s).
I am trying to update user info in the database but I get this error.
public IActionResult OnPost()
{
if (!...
- 1
0
votes
0
answers
75
views
Updating my JFrame when database is updated
I am developing 2 application who are reliated to the same database.
I use java swing and I want to update my Frame when the database is updated from the other application.
I tried to write my code in ...
1
vote
0
answers
1k
views
Android database (Room) not updating after application update
I'm kind of new to Android development, but I'm taking over some project somebody more experimented than me did.
I'm making an application that retrieves data from the internet at startup and creates (...
- 379
0
votes
2
answers
211
views
Updating and reverting changes with JPA persistence
I have questing regarding JPA persistence. I want to change values of specific column (for e.g. 1 to 2), and fetch corresponding rows further (which are having column value 2). If other service gives ...
- 121
2
votes
1
answer
541
views
Oracle Update Query On Select Query | Error ORA-01733 Virtual Column Not Allowed Here
update(
select id, word, status
case when sm = 1 and status = 'Renew'
then coalesce(lgst, 'Add')
else status
end as status1,
...
- 2,795
0
votes
1
answer
110
views
Convert Select Oracle Query To Updte for specific scenario
we are using Oracle v12+
we have a situation where we need to update status column to previous value whenever we have first RENEWAL for every code (it is functional ID and has many rows against one ...
- 2,795
-1
votes
2
answers
105
views
Increment my variable in a database with UPDATE in PHP
I get the variable 'stock' from my database. I would like increment my variable with an update with this code:
$stock = $_POST['stock']
$nom = 'salade';
$req=("UPDATE ingredients SET stock=$stock+1 ...
- 160
0
votes
1
answer
411
views
'Index 1 is either negative or above rows count.' error
I have a form with a datagridview that is connected to a access database. I am having issues to get my update button and my delete button to function properly. I can click a row in the datagridview ...
1
vote
1
answer
137
views
Laravel : How to update boolean value using foreign key in a table
here is my database table I want to work with I want to update the participation column of form_submissions table with boolean 1 by using the user_id
here is mycontroller
public function update($...
3
votes
1
answer
5k
views
Is there a way to check the database version in a flutter app using sqflite?
I am pretty new to flutter and I have some questions about how database version control works for these apps with sqflite.
I have made a database file in my assets folder that is copied onto the ...
- 157
0
votes
2
answers
2k
views
Update multiple hyperlinks at once in Microsoft Access
I have thousands of rows in my Microsoft Access DB and I would like to update all values in the column "Documento_Digitalizado". Values in this column are raw text that must be updated to be an ...
- 447
0
votes
2
answers
84
views
How to update field in database from controller
I have a user who must complete a field without to be logged in. The field is a email_field.
The database have two field : user email and a user_id the user_id is received it from a webhook so I need ...
- 15
-2
votes
1
answer
43
views
getting issue in update query in laravel
Guys i am facing an issue in laravel on update i want to update 2 values in single column but its update only one value i want to update both values please help also please see my code and image link ...
- 37
1
vote
1
answer
463
views
Database migration with kubernetes helm deployement
I have a problem with my database migration inside kubernetes.
Actually, i execute an initcontainer script when my pods started.
But this process is very long (10minutes).
When i kill my pod, this ...
- 61
1
vote
1
answer
3k
views
How to pass table name a parameter in Azure data factory
I'm a new user in the Azure data factory. I tried to perform copy activity in between Azure database as the source and Azure data warehouse as a target . In that, I am not able to perform an update ...
- 125
0
votes
0
answers
38
views
How do I update the filed of date while I have an text view in activity
My question is I need to update an entry from the database which is of type "date". When i created a new activity called update activity in which I used edittext as to stored the updated date.
Now I ...
- 21
0
votes
0
answers
525
views
Real time data update with postgresql
I want to make multiple query in a database at the same time in same database with real time update. Like, google map the location of person update all time. Is it possible with postgresql?
1
vote
2
answers
107
views
How to update an entity in Entity Framework?
When I update this entity I get this error:
My Class for database is different with my class in viewmodel
but I convert it.
Please help me and send me the correct code.
Thanks
My error:
...
- 180
0
votes
0
answers
35
views
Issues with Access Database 2000 using Access 2016
First of all, I'm really a begginer to Access. I have basic knowledge about databases ( running on SQL mostly ), so thanks for dumbing down the answers a bit.
The company I work for created a ...
- 41
2
votes
1
answer
2k
views
What will happen when i update table with same values again and again?
What will happen when i update table with same values again and again?
Ex :
update tblExample set Col1 =1214 where Id=17
lets assume i keep updating this record with same value without changing ...
1
vote
1
answer
160
views
Identity server 4- Programmatically create clients & resources using the config
I follow this tutorial from Scott which worked, until the point when I change in my Config file some user details but those are never update in my database.
What should I do in order that all my ...
1
vote
1
answer
2k
views
How do I refresh a tab control page after a database update
Using Visual Studio community 2017, winforms, C# and MySql DB.
I have a tab control page that displays the playlists created from the DB.
When I delete a playlists, it's removed from the DB, but is ...
1
vote
2
answers
72
views
JOIN and UPDATE a MySQL record with an ID from another table?
AdminTable
----------------------------
ID | Start Date | LoginID
----------------------------
3 | 10/11 | 28
4 | 12/12 | 89
5 | 13/13 | 74
---------------...
1
vote
0
answers
372
views
how to update data in sqlite database in android
I have a problem in the database program please guide me.
I created a database manually and copied it to the assets folder and runs all parts of my program, but I do not know how to complete the ...
2
votes
1
answer
896
views
Timeseries database with concurrent update of historical data
I need to store timeseries data, and have special requirements. Lets say that I want to store the turnover for my business for every 5 minute-interval. E.g one timeseries
Store#1
1/12–2016 10:00–10:...
- 623
0
votes
1
answer
147
views
How can i update my database column name from laravel 5.3 artisan
i tried with this
php artisan make:migration update_username_field_to_users_table
but it didn't work and give an error.Let me now about the process i should follow.
- 33
0
votes
2
answers
744
views
Updating record in phpmyadmin with php code
I have a reservation form where once it is filled out, the rooms available for a certain building are decreased by one. I am using Cloud9 ide with php to update the record for that building in the ...
- 19
0
votes
2
answers
1k
views
Excel VBA to Access database: Decimal number issue
I am working on a small Access DB where I add row values as 1.1, 2.1, 3.1 from an Excel file. When I update, this is getting updated as 1.0999999999, 2.0999999999,3.1000000000000001 in the Access DB. ...
- 213
-1
votes
1
answer
79
views
how to write a c# form application that can be updated in future(by instaling updated code or file)
Let say i have publish an Windows form application which has 2 labels and 2 text field(Name, Email) ,a SAVE button and a button name UPDATE (file selector).Again let say i have two method in my ...
user5715279
0
votes
1
answer
76
views
What is the best database solution to store large often updated datasets?
I have a MySQL table with dataset > 50 M rows and counting.
There are many updates and inserts that are taking more and more times (data set is increasing) so I am worried that it will be a ...
- 976
0
votes
0
answers
67
views
Postgres - go - how to find last updated database in Postgres?
I am having more than 100 database. Each database contains some tables. After performing some operation tables in database got updated. Currently am running a thread which will connect each database ...
- 644
0
votes
2
answers
81
views
Django - Update each field in the database that have this value
Let's say I have two tables:
table#1: Space
table#2: Students
If I want to change the prom_name form table#1, I'd like to automatically update the prom_name in my table#2 as well
My model Students ...
- 769
0
votes
3
answers
118
views
How to efficiently store temporary userdata
I'm fairly new to Java and I need help with something. Is there an (efficient) solution to the following problem:
I have a bot where players can "roll" to gain coins. Right now, after every single ...
- 862
1
vote
2
answers
90
views
Django: Update or Change previous saved model data
I have this code in my forms.py
ref_user = User.objects.get(
username=form.cleaned_data['referrer']
)
user = User.objects.create_user(
username=form.cleaned_data['username']
)...
- 133
2
votes
4
answers
74
views
UPDATE and SELECT
Why do I need the SELECT privilege on this:
UPDATE Sailors S SET
S.rating = S.rating - 1
While I don't need it for this query:
UPDATE Sailors S
SET S.rating = 8
1
vote
2
answers
270
views
Store user data in database separately
What is the best practice to store user data separately from the actual app data? The user data is a statistic and it will be collected during app usage. The database must be always updated but I have ...
- 450
1
vote
2
answers
32
views
Sql Server Update Rows where like '%#186;%'
Hello I have in my database a bunch of table rows that contain the following values:
Street Number 1095 - 4º Esqº
and I am trying to remove
º
from all the rows that ...
- 121
0
votes
1
answer
73
views
Couchbaselite update operation leads to inconsistent behavior
I am using Couchbase Lite SDK for android and saving an object instance of MyClass as a document in the database. MyClass has an attribute that stores the date in the java.util.Date. During run time, ...
- 1,991
0
votes
1
answer
135
views
Is it safe to append some data at end of the binary firebird database file?
My main intent is to add some version information to a Firebird database file, since I will use Firebird as embedded database and installers/update mechanism will need this information.
The ...
- 1,850
0
votes
1
answer
147
views
files and data base lost after a c# application update
I installed a desktop application on a pc that i developed by c# that use an SQL database. After few months, i published a new version of the application (using clickonce) and put it on an FTP server.
...
- 341
0
votes
1
answer
682
views
Update Extended Properties of a Stored Procedure
Dummy in SQL here needing to update an extended property of a stored procedure. Can only find info on updating table contents, not properties.
Needing to send a query to a database from a C# function....
0
votes
1
answer
106
views
update database value stored by using specific spinner value - android
The task given to me is to "change the state(Spinner) value", for which I used spinner to select the specific state and it "directly stores its value in database".
Now I need to "Update the state" ...
1
vote
1
answer
201
views
Error Code : 1064 on MySQL update query
Table: immunization
id vac_id vaccine_id
1 5 0
2 5 0
3 3 0
4 4 0
5 4 0
Table: vaccine
id vac_id
8 1
9 2
10 3
11 4
12 5
I have two ...
- 207
0
votes
1
answer
80
views
Updating a foreign key only when primary key exists
I have the following piece of code. I want to update a foreign key
if the corresponding primary key exists.
Please look at Query No : 2 and Query No : 3.
DROP SCHEMA IF EXISTS s CASCADE;
CREATE ...
- 1,063