Stack Overflow
Stack Overflow

Questions tagged [onupdate]

74 questions
0
votes
0 answers

Which sqlAlchemy can be used to apply onupdate function and not to wait for session to be closed?

Hi I've seen that onupdate function is not applied until the session is closed and I would like if there is any way to update db and use the onupdate function in the middle of a process. I've tried with commit and flusk but no results... created =…
Sergi Garriga
  • 1
0
votes
0 answers

onUpdate is running but not updating the Widget graphically

I currently have the most basic widget possible for attempting to force an update on a button press, a single button which updates its own label from "old text" to "new text". This has worked exactly once, and then never again. According to the logs…
Luke Mills
  • 1
  • 1
0
votes
0 answers

ON UPDATE doesn't trigger on column with TYPEORM/NestJS

When a record is updated in database from TypeORM the date timestamp doesn't get updated. alter table qae_dashboard.test_suite add column `lastUpdated` DATETIME default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP NestjS/TypeORM return await…
Shreyas Murali
  • 329
  • 1
  • 2
  • 17
0
votes
1 answer

Gestrure Addlistner to get translateY into another component. React-native

I am trying to get the translateY.value into a state or some other way to control other component. This is inside a "bottomSheet" but in my Main where i import the bottomSheet i want to use the y value it is at while it is moving to control other…
KLK
  • 49
  • 7
0
votes
2 answers

cakePHP - creating new user account, several problems

I have two tables, users and tokens. Each user have a activated field and each token have the {id, token, user_id, created} fields. The way the app should work is: On the creation, the app will - make sure that the activated field is empty (to…
yossi
  • 3,090
  • 7
  • 45
  • 65
0
votes
1 answer

Mysql trigger if only x field changed

I want to check in a mysql event (onupdate) if only a specific field has changed. For example: only x field value has changed? Then do nothing. The problem is that the table contains about 150 fields...
user3459444
  • 21
  • 3
0
votes
1 answer

MariaDB native UTC time on update

I’m searching for a value that changes the value of a column to the current UTC time when the row is updated, but UTC_TIMESTAMP and GETUTCDATE only works as default value, not when used in ON UPDATE. Is there a solution or do I have to give the…
NS - Not the train
  • 302
  • 3
  • 10
0
votes
1 answer

Google Sheet Script onEdit(e) if H2=Yes then make Column I (Checkbox) pressable

I'm trying to find a specifc conditional format for a scenario on google sheet but I was unable to find anything regarding this (than changing color, format text etc). Is it possible to write an onEdit(e) script that conditions if column Hn==Yes…
MrrrDude
  • 21
  • 1
  • 7
0
votes
0 answers

How to determine if a row is going to be updated within an update query not using trigger or table definition

I want to update a column in MySQL only if the row is updated. (meaning all the other values trigger mysql to update the row.) It's a concatenated text-field, so automatic calculation using ON UPDATE in the table definition won't work. A trigger…
nïkö
  • 89
  • 2
  • 10
0
votes
1 answer

iOS app crashing on launch screen due to core data migration

This is the code: lazy var persistentStoreCoordinator: NSPersistentStoreCoordinator? = { // The persistent store coordinator for the application. This implementation creates and returns a coordinator, having added the store for the application…
rohit
  • 1
  • 1
0
votes
1 answer

Doctrine ORM: Validate schema with manually added fk with option on update cascade

I have two related PostgreSQL tables: persons(.., person_department_id,..) and departments(department_id, ..) with foreign keys properties "ON UPDATE CASCADE". I can't change this behavior, because data comes from external database by a script, i.…
Vitalijus Trainys
  • 31
  • 3
0
votes
0 answers

Unknown Column Error On TRIGGER

I have created a trigger in my MySQL database, which is meant to set the column named "gps_coordinates" to equal the column named "previous_gps_coordinates" before updating it with the new values. The problem is on testing, I get the following error…
Leon Claassen
  • 183
  • 3
  • 12
0
votes
1 answer

Update Wicket Text Field on onUpdate event

I have a component that extends TextField where a user can type an web address. I want that after the user type something (for example www.example.org) to change that value to something else (for exemple http://www.example.org) I have tried…
Alex
  • 2,213
  • 4
  • 32
  • 44
0
votes
0 answers

Android Widget - How can I start activity without clicking on widget?

I have an Widget and activity which will configure widget. I want to start this activity when widget calls onUpdate method. How can I make this ? I tried this code and it doesn't work: Intent intent = new Intent(context,…
remes
  • 67
  • 2
  • 8
0
votes
1 answer

ON UPDATE MySQL with doctrine DBAL

I use doctrine DBAL 2.5.2 with MySql 5.5 I have created a field with timestamp type and an ON UPDATE CURRENT_TIMESTAMP extra. When I change the content from phpMyAdmin the field is updated and change to the current timestamp, but when I update the…
Intuitisoft
  • 1,390
  • 1
  • 9
  • 18
1 2 3
4
5