PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEVWEBDEV e WINDEV Mobile

Inicio → WINDEV (versões anteriores) → 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, mar., 22 2018 1:07 PM - Sem resposta
Membro registado
7 mensagems
Publicado em março, 22 2018 - 1:07 PM
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