All Questions
87
questions
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.
...
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 ...
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
votes
1
answer
36
views
NodeJS Service, the group I created is updated but not stored in databse
I wrote this service and when I call it, the JSON response is the group is updated but when I check the group details it is not updated, the old details are still present. I don't know where or what ...
1
vote
1
answer
188
views
Updating SQLite database when app shipped with database for releasing new version
I am shipping the database file with our android application. For that I followed How to ship an Android application with a database? answered by Danny Remington - OMS.
Now I have to provide the new ...
0
votes
2
answers
1k
views
How can I be notified in ASP.NET when a certain update happens in my database?
I need to be notified of specific changes that happen in my database, e.g. when a specific value becomes null or when an integer changes to a value between a certain range. I was looking into using ...
0
votes
1
answer
189
views
Update listview with custom adapter and database handler
I can't update listview with custom adapter and database handler.
Items are updated in the database handler, but listview is updated only when I leave the fragment and come back. I would like to see ...
-2
votes
1
answer
55
views
mysql updates not working
I have a mysql insert function that works whenever I insert data into a database, but my mysql update function for some reason doesn't seem to work... it doesn't return any data... just zilch... not ...
0
votes
1
answer
81
views
Recommended order of updating a database
Granted that while updating a database, there are DELETED records, UPDATED records and INSERTED (new) records. What would be the recommended order for performing the updates?
I currently do DELETE, ...
-3
votes
3
answers
1k
views
update rawQuery in to database is not working on android
In my project i'm updating the searchtag in the database by using this query
public void updatesearchtag(){
SQLiteDBHelper sqLiteDBHelper = new SQLiteDBHelper(context....
0
votes
1
answer
1k
views
SQL Update a column dependent on other two columns
I need help finding out how to properly execute an Update query that will update a column depending whether another column has the newest information.
My Table looks like so:
Document# | Revison# | ...
0
votes
1
answer
612
views
syntax for check debug in php codeigniter
I want to ask. why my update script doesn't work or doesn't fit with what I want. strangely this script doesn't save to the database when I click the update button but the pages move like this script ...
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 ...