ODBC variables

[Nadir]

Hi all,

Could you tell me what's the best type of variable(varchar, char, int, time, date...) for values in tables on SQL:

%Date%
%Time%
%Reply%
%Status%
%FCommentLine1%

I want to choose the best for Log Analyser

[KS-Soft Europe]

Could you tell me what's the best type of variable(varchar, char, int, time, date...) for values in tables on SQL:

%Date% - datetime
%Time% - datetime
(but you may use one %DateTime% variable)
%Reply% - varchar (see also Reply_Number and Reply_Integer variables, here you may use double and int accordingly)
%Status% - varchar
%FCommentLine1% - varchar

Also we recommend to store %TestID% and %TestMethod% variables.

Regards,
Max

[Nadir]

but you may use one %DateTime% variable

What's the best for Log Analyser?

Also we recommend to store %TestID% and %TestMethod% variables.

Why? they are used by Log Analyser?

[KS-Soft Europe]

What's the best for Log Analyser?

It is depends on your SQL Server.
It's preferable to use %DateTime% variable, because most of SQL Servers store Date and Time in one field. Log Analizer is able to parse such fields and retrieve Date and Time separately.

Also we recommend to store %TestID% and %TestMethod% variables.

Why? they are used by Log Analyser?

Yes, %TestMethod% is used, as you may see in ODBC Logs Manager.
%TestID% is used for your own convenience. But if you do not need such field, you must not record it.

Regards,
Max

[KS-Soft]

Right now Log Analyzer may use either %TestID% or %TestMethod% field. I think future versions will be able to use both fields.
So, if you have enough space for the table, record both fields.

Regards
Alex