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 Perez YESENIA, Mar., 22 2018 1:07 PM - No answer
Connect yourself…
Perez YESENIA
#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
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