ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '606790' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;]
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '606790' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;]
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '606790']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 606790 AND InstitucionPropia = 'S'
UNION
SELECT Adscripciones.Entidad FROM PublicacionesObras
JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion
JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado
WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 606790]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: 2021 18th International Conference On Electrical Engineering, Computing Science And Automatic Control (cce 2021) Título del capítulo: FPGA-based accuracy mechatronics of a feed-drive system with ball screw
High-accuracy mechatronic systems require a con-trol algorithm to
realize trajectories or positions. On the other hand, the acquisition of
data and embedded system design configurable is a very important part to
guarantees processing in hardware, high performance, reception, and send
of data that generally is defined by the applications to which it is
intended. Therefore, the increasing demands in the improvement of the
accuracy systems based on modern programable devices are being applied
in the scientific and engineering areas. This paper presents a novel
mechatronic approach to experimental validation of a feed drive system
with ball screw. The description of an original FPGA-based configurable
design is introduced which consists of an own design approaches of
hardware architecture. Finally, based on a built prototype of a feed
drive system with ball screw, the PID controller implemented and the
mathematical model, in both cases, were applied in order to establish
the comparison between the responses, seeking to observe if the
experimental results show a great difference with respect to the
simulation data. A cost-effective solution using a single chip low-cost
FPGA for feed-drive system is presented to the closed-loop control
present approximately the same response as that of the system model used
in the simulation. Experimental results demonstrate an excellent
positioning control and processing performance of the data configured on
the FPGA Firmware, which validates the feasibility and effectiveness of
the proposal.