PROFESSIONAL NEWSGROUPS
WINDEV
,
WEBDEV
and
WINDEV Mobile
Home
|
Recent messages
|
Connect
|
Sign out
|
English
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 Yess, Mar., 22 2018 1:05 PM - No answer
Connect yourself…
Yess
#1
Posted on March, 22 2018 - 1:05 PM
intento insertar datos a una tabla externa, utilizo el siguiente codigo, si lo realiza, pero no en la tabla del analisis de la conexion, si no que crea una tabla en el analisis del proyecto y ahi los agrega.
quiero que los inserte en el analisis de la conexion.
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?
Report
0
0
→ Go back to WINDEV (earlier versions)
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (earlier versions)
Français
English
Español
Portuguesa
Close this window
Search type
Only topics
All the messages
Search period
Any time
Past hour
Past 24 hours
Past week
Past month
Past year
Cancel
Preview of your message
Adding an image
Import an image from a URL
Send an image from a file of your disk
Drop a file or click "Browse..."
or
Cancel
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Text