Stack Overflow
Stack Overflow

Questions tagged [updatable-views]

30 questions
0
votes
1 answer

primary key on update-able view in MySQL

Is it possible to create primary key on update-able view in the MySQL. If so how we can create it?
Ananth Duari
  • 2,859
  • 11
  • 35
  • 42
0
votes
2 answers

Postgres: updatable view (where in) with check option

I try to create updatable views with check option. When I have joins in the filtering criteria, I use a where in clause to simplify the queries. However if I declare the view with both check option and where in, data validation doesn't seem…
Kiruahxh
  • 1,276
  • 13
  • 30
0
votes
0 answers

ipywidgets updatable text area scrollbar

Using ipywidgets, I need to create an output text box which will display alert messages. The box should include a scroll bar to be able to read previous messages. ipywidgets comes with Layout, Textarea and Text functionalities but I could not figure…
bl00mb3r8
  • 1
0
votes
1 answer

Ajax form submit problem with refreshing

I have an ajax form for settings in my site. The user presses an img and then the ajax script calls a php file called set.php. In this file I have a form
If the user updates…
MayTheSchwartzBeWithYou
  • 1,181
  • 1
  • 16
  • 32
0
votes
1 answer

Can not update view

I am using PgAdmin 4 with PostgreSQL 12. Below is a simple tabledefinition vocabulary and a view vocabulary_input. When I use the SELECT - statement from the vocabulary_input in the Query-tool screen, I can update and add rows. However, when I…
cvz
  • 139
  • 1
  • 7
0
votes
2 answers

Can't update column in sql table

I created a view CREATE VIEW `distance` AS SELECT `rv`.`id` AS `id`, `rv`.`TIMESTAMP` AS `TIMESTAMP`, `rv`.`name` AS `name`, `rr`.`distance` AS `distance`, `false` AS `new_name` FROM …
J. Doe
  • 1
  • 2
0
votes
1 answer

Segueing with a reusable table view

I am working on a directory listing application. Specifically, the app I am working on is called iEngineering. It would probably be best to drive home the purpose of my question if you download or look at the application on the AppStore. It is…
Tony Pendleton
  • 358
  • 1
  • 11
0
votes
2 answers

use of views to protect the actual tables in sql

how do views act as a mediator between the actual tables and an end user ? what's the internal process which occurs when a view is created. i mean that when a view is created on a table, then does it stands like a wall between the table and the end…
sqlchild
  • 8,754
  • 28
  • 105
  • 167
0
votes
3 answers

difference in simple insert query and inserting through a view into a table

i am studying about views in sql and somewhat confused and having the following query : i have a table 'item' and need to insert data into it. am using two ways, one without view and the other using a view. CREATE VIEW vw_item SELECT * FROM…
sqlchild
  • 8,754
  • 28
  • 105
  • 167
0
votes
0 answers

Result Set not updateable when I use updateable field

I am running this code but I don't know what is wrong in this code. I define the statement with field SENSITIVE & UPDATABLE but when I run the code this error message appears in the console: Result Set not updatable.This result set must come from a…
Hamid Matin
  • 1
  • 1
0
votes
0 answers

Access view linked to SQL Server is not updatable, though it worked fine with ADP

I am in the process of converting an ADP (Access Data Project) to an ACCDB. So far, it has gone pretty well, except that the views no longer seem to be updatable now that they are actual links into the SQL Server database. Specifically, the…
UhClem
  • 129
  • 3
  • 10
0
votes
1 answer

updatable view gives runtime error in visual basic

I am trying to convert an old visual basic program which is using legacy database tables into a more modern and robust implementation. It uses a lot of varchars when it should have used floats to give a concrete example, it makes the code very hard…
Philip Stuyck
  • 7,344
  • 3
  • 28
  • 39
0
votes
0 answers

How to Update Data Without Button

I need a help how to update data through the website in android application. I have fetched the data through a website, but I have no any idea or example for changing the data automatically. The Data Change On Restarting Application Or Onclick…
aarif khan
  • 21
  • 1
  • 2
0
votes
1 answer

Instead of Trigger on View using Merge doesn't apply table default values

I have an updateable view using an instead of trigger for insert/update. That trigger uses Merge. I'm finding that the Merge statement isn't applying the default constraints from the underlying physical table, although the merge documentation…
winnt93
  • 43
  • 1
  • 6
-3
votes
3 answers

How To Show The Current Time in TextView in Widget

I want to show the current time in updatable textView I can't find the true way to make it I want it to be updated every minute Please anyone can help me ? Thanks
Muaz Kadan
  • 18
  • 1
  • 7
1
2