how do i update the current time to the database ?

[ChongKit]

Hi guys...

How do i connect the "Date/Time string" to the DB Tools Update Data.vi ??? Is it connect it to the point/pin called "condition" of DB Tools Update Data.vi ?

I am kind of confuse of how do i connect...

Thanks in Advance.

[Silver_Shaper]

Hi 

Check this

 

You can do the same with DB Execute query vi 

[ChongKit]

Hi.... I try this method....but why the "Date and Time " will not display on the table ???  Where went wrong ???

[ChongKit]

I try your method but it keep giving errors...

[Silver_Shaper]

Hi 

What kind of error are you getting? - Let me know clearly your Db columns details and things you want to do.

[ChongKit]

This is the error i get...{    NI_Database_API.lvlib:Cmd Execute.vi->NI_Database_API.lvlib:DB Tools Update Data.vi->FYP_3.1.vi<ERR>ADO Error: 0x80040E14
Exception occured in Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. in NI_Database_API.lvlib:Rec Create - Command.vi->NI_Database_API.lvlib:Cmd Execute.vi->NI_Database_API.lvlib:DB Tools Update Data.vi->FYP_3.1.vi  }

When u scans a card, it will show you your information with the Current Time/Date on the table. and update it on the database....

I try the example of DB tools update data vi .. it make me more confuse :l