LabVIEW communication between SQL server and LabVIEW

[Robinm76]

The format look like "01-01-00 00:00:00" in the database

Hm, that's not looking really great, first this "date/time" is the Execution Date of the Card test and second I am in internship, the more I can do with LabVIEW better it is so if I can transmit my "Execution Date that I have created in another Sub-VI and transform that string in "date/time" format it would be great, or just use the DB Tools Fromat Date Time String...

I have tried with a value "%d" and transmit it in the same format at TestTime in my DataBase, and it's doing good, that's why I want to transform the String it is the easiest way with LabVIEW commands, LabVIEW can only transform strings into other format? not in the other way?

[Robinm76]

It works, I just changed the format to string in Excel, then Load it in my SQL code it is looking like "datetime" but I send a string that looks like "00-00-00 00:00:00" so it's all ok now.

About BSTP_Version -> The guy that created the nvarchar make the MAX nchar to 10... So to test with "BSTP_Version" or "BSTPVersion" well it is more than 10 characters, stupid error but well I forgot about that

I am going to close the topic is solved. Really a big thanks to you guys, you helped me a lot, for little things that unlock my big problems about databases.

Anyone have some good documents about "How to send the answer of a request / command and transform it to a string" Then I could start about ComputerName / UserName and other things like that.

It will be ok now I am sure.

Best Regards,

Robin.

[Robinm76]

Ok it was easy to find, just for the others that have to send it to their databases:

http://digital.ni.com/public.nsf/allkb/03F7257B337CC63E8625754D0082FDE4 Username

http://digital.ni.com/public.nsf/allkb/4B3877DB13370AA586257542003945A9 Computername.

Best Regards,

Robin.