Re: Date format while writing to database using database toolbox

2004-06-04 Thread Ben
Sarcasism = Humour in my book. Ben

Re: Date format while writing to database using database toolbox

2004-06-04 Thread Ben
Rolf, You never fail to entertain! Who says we Enthusiasts do not have a sense of humor. Ben

Re: Date format while writing to database using database toolbox

2004-06-04 Thread pawel
The connectivity toolbox has a special treatment for the date/time column data type. It has a vi, which encapsulate a formated date&time with something like #date/time#. Anyways, I chanked the format of the string passed to the insert.vi and it is a correct one, like I want -MM-dd. The problem

Re: Date format while writing to database using database toolbox

2004-06-04 Thread pawel
Hello Rolf I have tried it on two kind: jet4 and ODBC - SQL Server. They are all dependent on local setting. But I agree it must be caused by the driver. regards Pawel

Date format while writing to database using database toolbox

2004-06-03 Thread pawel
Hello All Again a problem with input locales and database tooldbox. How to write to database using connectivity toolbox in user defined format (not dependent on Windows locales)? Every time different user is logged on and writes a measurement to database, the dataformat is different depending on t