PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV (précédentes versions) → how to insert data into an external table with hfsql and windev
how to insert data into an external table with hfsql and windev
Débuté par Perez YESENIA, 22 mar. 2018 13:07 - Aucune réponse
Membre enregistré
7 messages
Posté le 22 mars 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