NexusDB 2

rbuser

Are you likely to be officially supporting this any time soon?

I know that it will work currently but there is a problem when autosearching
on date fields because nexus insists on SQL 2003 construct of ... where
MyDate>=date'2005-01-01'.

Ken

nardmoseley

Try adding a couple of overrides to the TdaNexusSession class for the
methods GetSearchCriteriaDateFormat and GetSearchCriteriaTimeFormat. The
ancestor methods are defined in TdaSession (daSession.pas). These methods
are used by the TdaSQL object to format date and time search criteria.

If that works, then please email the updated Nexus plug-in to
support@digital-metaphors.com and we can update our web site.

rbuser

> Try adding a couple of overrides to the TdaNexusSession class for the

I'm not sure that is enough.

SQL 2003 seems to require different literals for dtDate, dtTime and
dtDateTime:
dtDate -> DATE 'yyyy-mm-dd'
dtTime -> TIME 'hh:nn:ss[.[zzz]]'
dtDateTime -> TIMESTAMP 'yyyy-mm-dd hh:nn:ss[.[zzz]]'

The GetSearchCritera does not know what datatype it should format.
The DataType or the Critera must be added as a parameter to
GetSearchCriteria to be able to handle this.

/Johan

nardmoseley

Check out the TdaSQL.ResolveCriteria method in daSQL.pas. It contains a
FormatValue function that has special formatting logic for Oracle and
SQLServer. Perhaps you can add a new IsNexus boolean and associated
formatting. Test and then send the proposed modifications to
support@digital-metaphors.com.

rbuser

Going back to the original question; are you going to be supporting nexusdb
in the near future?

Ken

nardmoseley

The original daNexus plug-in was created by Nexus Database Systems.

Johan Nilisson has provided a list of mods required to support the latest
Nexus version.

We can incorporate the changes into the next major release and we can a new
DatabaseType enum value for dtNexus.

rbuser

Thanks