close Warning: Can't synchronize with repository "(default)" (/var/svn/tolp does not appear to be a Subversion repository.). Look in the Trac log for more information.

Opened 21 years ago

Closed 21 years ago

#77 closed defect (fixed)

Bayes Sql don´t permit to use of numeric and text data

Reported by: maalamo@… Owned by: rcsoto
Priority: normal Milestone:
Component: DataBase Version: head
Severity: normal Keywords:
Cc:

Description

If you connect to the Access Neptuno Database by ODBC y execute the query

SELECT IdEmpleado, Apellidos, Nombre,

Cargo, Tratamiento, FechaNacimiento,
FechaContratación, Dirección, Ciudad, Región, CódPostal,
País, TelDomicilio, Extensión, Foto, Jefe, Notas

FROM Empleados

in Bayes SQL you have an ERROR because the field Notas is a Text [memo] data,
the error is similar if the field is a numeric in a visual fox pro database.
If the query executed is
SELECT IdEmpleado, Apellidos, Nombre,

Cargo, Tratamiento, FechaNacimiento,
FechaContratación, Dirección, Ciudad, Región, CódPostal,
País, TelDomicilio, Extensión, Foto, Jefe

FROM Empleados
there isn´t ERROR.
The problen isn´t in the driver ODBC because if it is executed in Microsoft Query
there isn´t Error
Sorry by my english, Thanks

Change History (2)

comment:1 Changed 21 years ago by Javier Portugal

Owner: changed from Javier Portugal to rcsoto

We must review package tclodbc to fix those bugs. (With SqlServer gives an error
for tinyint data types)

comment:2 Changed 21 years ago by rcsoto

Resolution: → fixed
Status: new → closed

Hello.
The error was in the package "TclODBC".
The error in the external package has been corrected. The error to the list of
errors of TclODBC has been reported.

The package "tolbase_addons" has been modified, in order to correct this error.

Note: See TracTickets for help on using tickets.