PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEV, WEBDEV and WINDEV Mobile

Home | Recent messages | Connect |  | English US
Home → WINDEV (earlier 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
Started by Perez YESENIA, Mar., 22 2018 1:07 PM - No answer
#1
Registered member
7 messages
Posted on March, 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
→ Go back to WINDEV (earlier versions)