All Questions
87
questions
4
votes
3
answers
590
views
Automatically update or delete record(s) after x time in coldfusion
I've searched all over the net for this. Hope that someone's got something.
How would a record in a database be updated automatically after x time n coldfusion?
I know how to manually do it by ...
4
votes
4
answers
4k
views
Keep track of database column value changes
I am working on a web based application using Zend framework.
I am looking for a way to keep history of updates made to a bunch of columns.
Use-case:
User can add an item with 5 properties. The ...
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 ...
2
votes
2
answers
3k
views
How can I replace (overwrite the entire file) a sqlite database provided by SQLiteAssetHelper?
I have a database file in my app's src/main/assets/databases directory. I want to download a new copy of the entire database (no data needs to be retained), and overwrite the old one. How can I do ...
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 ...
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
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:...
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
2
votes
0
answers
3k
views
Laravel 4 - A four digit year could not be found Data missing
I'm trying to update some data and I'm having the next message:
A four digit year could not be found Data missing
In this form, I have some data that I want to update in my 'Actividad', so I have ...
2
votes
0
answers
1k
views
How to update production database with development one?
I have built a web app using MySQL and php and I'm at the moment trying to figure out the best approach to make a script to automatically update the customers based on the new changes on my ...
2
votes
1
answer
687
views
Starting an update checker thread, checking for new entries in a database
I need some suggestions for approaches to take...
Here's some background info:
Right now I have an Android app and a separate java program running on my server.
The java program continuously go out ...
1
vote
2
answers
6k
views
updating data in database using datagridview C#
I have a problem with my code regarding editing data in database using a DataGridView.
I have an error at da.update(dt); It says,
Dynamic SQL generation for the UpdateCommand is not supported ...
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 ...
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
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:
...