database: read NULL values from timestamp

[Pierre_F]

hello

the VI below returns an error when the database field "packaging timestamp" is NULL.

the database field is written like "2017-02-16 11:09:20.000"

and the labview timestamp constant has the properties below (sorry about french):

can you help?

[billko]

---

@Pierre_F wrote:

hello

the VI below returns an error when the database field "packaging timestamp" is NULL.

the database field is written like "2017-02-16 11:09:20.000"

and the labview timestamp constant has the properties below (sorry about french):

can you help?

---

Are those openG DB tools?  I don't have them, but it looks like the icon styling.  I suspect that somewhere buried in there is a LabVIEW string parsing VI that uses RegEx and cannot handle a null character.  The fix?  Make sure you don't send it a null timestamp.  😉

[CyGa]

According to the DB engine the timestamp are not always returned as LV formats them (SQL Server and MySQL timestamp are different for example...).

Have you tried replacing the LV timestamp data by a string and then format the string into a LV timetimestamp using Scan from string function ?