Hello all, again!!!
Sorry for my late reply. I was out on a long-and-well-deserved vacation that kept me away from Internet. But, I’m back now
Thank you all for paying attention on the issues I reported. It’s glad to know that there’s someone on the other side of the screen that works for making TDA the best tool for DB
I would like to remark the second issue I reported on my original message: I attached 2 images.
First one is from an Oracle Native Connection using “DATE” BIND VARIABLES, where it is possible to pick a date AND a time.
Second one is the same scenario, but on a MySQL native connection using “DATETIME” BIND VARIABLES, but in this case it is possible to pick a date BUT NOT a time (the TIME PICKER is missing in the small window - In the Oracle connection it was present)
Am I doing anything wrong? Is there any other way to pick a DATE and a TIME using a “DATETIME” BIND VARIABLE in a MySQL Native conn? I’ve found a “workarond” that consist in first selecting “VARCHAR”, then type in the DATE & TIME (example: 26/04/2010 11:59:59 p.m.), then switch to “DATETIME”, and finally click OK! It works nice, but it is annoying to have to do this every time with every new variable.
Hope you guys can take a look at this as you kindly did with the other issue I reported.
Thanks in advance!!!
I’ve found that BIND VARIABLES function in TDA
220.127.116.111 is not working as in the previous version
In TDA 2.5.1, the BIND VARIABLES window always
“remebered” the last values entered in the NAME,
TYPE, DIRECTION, and VALUE fields. In TDA 2.6.0 the
BIND VARIABLES always displays a “fresh”
configuration, with the TYPE field defined as
VARCHAR, and the VALUE field is EMPTY, so every time
you have to enter the values again and again, also
for running the very same query.
In TDA 2.5.1, when using BIND VARIABLES with 2
variables (DATE_START and DATE_FINISH) of DATETIME
type, it was possible to set different TIME for each
one (i.e: DATE_START = ‘01/01/2010 00:00’ and
DATE_FINISH = ‘01/01/2010 23:59’). Now, in TDA 2.6.0
I can’t even find the way to display/set the TIME
when the CALENDAR shows up during setting the value
for a DATETIME variable.
Sorry for my BAD english I hope you guys can help
me out on this, because I’m thinking in downgrading
to TDA 2.5.1 again.
Thanks in advance!