Hi I'm new in Ventuz, I have in my project a access database connected to a slide in Ventuz, but as I have doubts is how I can make the data it shows me my database can be updated directly from Ventuz, ie if I change the name of a field in Ventuz this is reflected in actual access database (mdb).
cheers,
AHUPA
Hello Ventuzians!
THE FORUMS ARE CLOSED!
Please join our discord server HERE!! << click me
We are shutting our Ventuz Forum, but don't worry, it will all be archived for you to search in if you have a query. From now on, please add all your comments, questions or observations into our Discord Server
Thanks for the great time - see you on discord!!
Dee, Karol, Daniel and the whoooole Product and Support team!
THE FORUMS ARE CLOSED!
Please join our discord server HERE!! << click me
We are shutting our Ventuz Forum, but don't worry, it will all be archived for you to search in if you have a query. From now on, please add all your comments, questions or observations into our Discord Server
Thanks for the great time - see you on discord!!
Dee, Karol, Daniel and the whoooole Product and Support team!
database update
Moderator: Support
- Daniel Willer
- Posts: 309
- Joined: 06 Jan 2012, 18:12
Re: database update
Hi there
Welcome to the ventuz forum.
As far as I understood you get the database connection done in ventuz, did you? If yes the update of database from ventuz is common SQL syntax.
You can use an Query node and add an UPDATE command that should look like that
Check the W3schools SQL classes for further information.
Regards Daniel
Welcome to the ventuz forum.
As far as I understood you get the database connection done in ventuz, did you? If yes the update of database from ventuz is common SQL syntax.
You can use an Query node and add an UPDATE command that should look like that
UPDATE table_name SET column1=value1,column2=value2, WHERE some_column=some_value;
Check the W3schools SQL classes for further information.
Regards Daniel
Re: database update
Thanks Daniel
But sorry, NOT ME EXPLAIN WELL, I HAVE MADE MY Query's AS BOTH CONNECTION ISSUE. My database and connects fine, but the problem I have is that I add a keyboard (text field input), I add scene event to start when you type something, with this only add data to the table but not the database. I do not want to add more data, I want to update an existing one in the DB. My query update its correct, run on the same data base. but the connection with Ventuz it´s my problem.
Cheers AHUPA
But sorry, NOT ME EXPLAIN WELL, I HAVE MADE MY Query's AS BOTH CONNECTION ISSUE. My database and connects fine, but the problem I have is that I add a keyboard (text field input), I add scene event to start when you type something, with this only add data to the table but not the database. I do not want to add more data, I want to update an existing one in the DB. My query update its correct, run on the same data base. but the connection with Ventuz it´s my problem.
Cheers AHUPA
Re: database update
This is my connection and query's,
My database table and query displays the information I want, what I need is that information can be modified. I have included a TextField input and the scene of events (start the event with the update query), connect my texfield to replace chain and what it does is add the data, but do not select a specific text and replaces as Ventuz and my database. I don't know how this connection is all I need. I would appreciate your help.
Cheers,
AHUPA
My database table and query displays the information I want, what I need is that information can be modified. I have included a TextField input and the scene of events (start the event with the update query), connect my texfield to replace chain and what it does is add the data, but do not select a specific text and replaces as Ventuz and my database. I don't know how this connection is all I need. I would appreciate your help.
Cheers,
AHUPA
- Daniel Willer
- Posts: 309
- Joined: 06 Jan 2012, 18:12
Re: database update
Hmm in the screenshot you attached the outgoing Query node is not connected to a DataBase node in that case there is no connection possible. The other thing I questioned myyself is what the SceneEvent is doing in between the TextfieldInput node.
I guess it triggers the execute command but what is written OnExecute? I can't see a binding from the outgoing string of the TextfieldInput node into the Query.
Cheers!
I guess it triggers the execute command but what is written OnExecute? I can't see a binding from the outgoing string of the TextfieldInput node into the Query.
Cheers!