VS:DBObjSQLSetWrite: Difference between revisions

From Vectorworks Developer
Jump to navigation Jump to search
No edit summary
mNo edit summary
 
Line 10: Line 10:
This SQL query writes to database, so the query should be an UPDATE query, e.g.
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
'''UPDATE''' [Columns] '''SET''' [Center Mark Size]=0.5 '''WHERE''' [ID]=1


</desc>
</desc>

Latest revision as of 13:33, 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