VS:DBObjSQLSetWrite: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
No edit summary |
||
Line 6: | Line 6: | ||
----------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------- | ||
<desc> | <desc> | ||
Set an object's SQL | Set an object's SQL query for ODBC write. | ||
This SQL query writes to database, so the query should be an UPDATE query, e.g. | |||
UPDATE [Columns] SET [Center Mark Size]=0.5 WHERE [ID]=1 | |||
</desc> | |||
----------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------- | ||
Line 25: | Line 31: | ||
hRecord | hRecord | ||
HANDLE | HANDLE | ||
The handle to linked record. | |||
</line> | </line> | ||
<line> | <line> | ||
SQLSentence | SQLSentence | ||
DYNARRAY[] of CHAR | DYNARRAY[] of CHAR | ||
The UPDATE query. | |||
</line> | </line> | ||
</lineList> | </lineList> |
Revision as of 13:30, 4 November 2015
.VectorScript|VectorScript ..VS:Function Reference|Function Reference ..VS:Function_Reference_Appendix|Appendix
Description
Set an object's SQL query for ODBC write.
This SQL query writes to database, so the query should be an UPDATE query, e.g.
UPDATE [Columns] SET [Center Mark Size]=0.5 WHERE [ID]=1
FUNCTION DBObjSQLSetWrite(
hRecord :HANDLE;
SQLSentence :DYNARRAY[] of CHAR) : BOOLEAN;
def vs.DBObjSQLSetWrite(hRecord, SQLSentence): return BOOLEAN
Parameters
hRecord HANDLE The handle to linked record. SQLSentence DYNARRAY[] of CHAR The UPDATE query.
Version
Availability: from Vectorworks 2011