Hi,
We're using the latest Access 4.0 drivers and we have problems with queries that contain 'calculated' fields. As soon as we use them, the access driver will not return and fields in the query.
Please let me know if you wish to have the test accdb that I'm using.
Regards,
Marc
|
|
Please send you test sample.
|
|
Mail send to support@hxtt.com
|
|
can you confirm you've received the mail with attachment?
|
Checked. It prompted:
SELECT EPS.*,Projects.*,[FD]-[SD] AS Duration,IIf([SD]<[DD],([DD]-[sD])/([FD]-[SD]),0) AS DurPCT FROM EPS INNER JOIN Projects ON EPS.EPSID=Projects.EPSid;
Two date type can't do / operation
|
But in MS Access it does allow me to do so.
Any workarounds for this?
|
|
Supported. The latest package files will be available after about 2 hours.
|
Thanks !! Great support.
I'll check the download section for an update on 18-10-2010.
|
For the sample above the new drivers now work perfectly, but my colleague has a query:
SELECT PlVal.ActID, PlVal.ItemID, PlVal.ActStart, SetPeriode.Werkdgn, DateAdd("d",[SetPeriode]![Werkdgn],[PlVal]![DDate]) AS DDenPer, PlVal.OD, (([PlVal]![OD]*([SetPrj]![Delay]/100)))/8 AS ODenDy, SetPrj_1.Delay, DateAdd("d",[ODenDy],[PlVal]![ActSD]) AS SDenDy, [SDenDy]<[DDenPer] AS Expr1, PlVal.DDate, PlVal.PID, SetPrj.DDate, DateAdd("d",[ODenDy],[PlVal]![ActFD]) AS EF, PlVal.ActFD, PlVal.ActSD
FROM ((PlVal LEFT JOIN SetPrj ON PlVal.PID=SetPrj.PID) LEFT JOIN SetPeriode ON PlVal.Periode=SetPeriode.Periode) LEFT JOIN SetPrj AS SetPrj_1 ON PlVal.PID=SetPrj_1.PID
WHERE (((PlVal.ItemID) Is Not Null) AND ((PlVal.ActStart) Is Null));
which still doens't work. Could the ! sign be a problem here? Or the (maybe) internal function DateAdd from Access?
It's an accdb database too and creating a query.
|
>Could the ! sign be a problem here?
Yeah. But HXTT Access can detect and convert it.
>the (maybe) internal function DateAdd from Access?
That's the answer. v4.0.032 supports function DATEADD(INTERVAL, expr, date), DATEDIFF (INTERVAL, date1, date2), DATEPART (INTERVAL, date). The latest package will be available after about 2 hours.
|
|
thanks. Works like a charm!
|
Main
webmaster@hxtt.com