General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Update an mdb database(access)
Hello,
I have a curso un VFP, in it i have number of documents, this documents have a field with .T., I want update this field in an access database.
For example i have:
vfp cursor -> micursor
field of the cursor ->nrodoc
field of the access table -> documento
odbc for access -> miodbc
table of access -> mitable
field of table for update -> estado
manejo = sqlconnect("miodbc")
=sqlexec(manejo,"update mitable set estado = .t. where document in micursor))
=sqldisconnect(manejo)
Could you help me ?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only