PC SOFT

FOROS PROFESIONALES
WINDEV, WEBDEV y WINDEV Mobile

Inicio | Mensajes recientes | Conéctese... |  | Español FR
Inicio → WINDEV (versiones precedentes) → how to insert data into an external table with hfsql and windev
how to insert data into an external table with hfsql and windev
Iniciado por Perez YESENIA, 22,mar. 2018 13:07 - No hay respuesta
#1
Miembro registrado
7 mensajes
Publicado el 22,marzo 2018 - 13:07
I try to insert data into an external table, I use the following code, if it is done, but not in the analysis table of the connection, if not that it creates a table in the analysis of the project and there adds them.

I want you to insert them in the analysis of the connection.

conecta is Connection
conecta..Server=gsErver + ":" + gsPort
conecta..Database=bd
conecta..User=guser
conecta..Password=gsPass
conecta..Provider=hAccessHFClientServer

IF HOpenConnection(conecta) = False THEN
Error(HErrorInfo())
RETURN
END

IF HDeclareExternal("./Gpw_SitioYohualli/Producto.FIC", "Producto", conecta) = False THEN
Error(HErrorInfo())
RETURN
END

// Run the query
dsSQLQuery is Data Source
IF NOT HExecuteSQLQuery(dsSQLQuery, conecta, hQueryDefault,[
insert into Producto(Nombre)values('prueba')
]) THEN
Error("Runtime problem"+HErrorInfo())
ELSE
Info("ok")
END
// Cancels the dynamic declaration of the file
HCancelDeclaration("Producto")

// Closes the connection to the database
HCloseConnection(conecta)

How can I do it?

--
Yesenia
→ Volver a WINDEV (versiones precedentes)