database update

[AHUPA]

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

[AHUPA]

please,

somebody help me

AHUPA

[Daniel Willer]

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

UPDATE table_name SET column1=value1,column2=value2, WHERE some_column=some_value;

Check the W3schools SQL classes for further information.

Regards Daniel

[AHUPA]

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

[AHUPA]

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

[AHUPA]

Please, somebody help me.

[Daniel Willer]

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!