VS:DBObjSQLSetRead: Difference between revisions
Jump to navigation
Jump to search
m (1 revision) |
No edit summary |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 6: | Line 6: | ||
----------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------- | ||
<desc> | <desc> | ||
Set an object's SQL | Set an object's SQL query for ODBC read. | ||
This SQL query is used to update the Vectorworks document, so the query should be an SELECT query, e.g. | |||
'''SELECT''' [ID],[Center Mark Size],[Use Center Marks],[Height],[Struct Width],[Struct Depth] '''FROM''' [Columns] '''WHERE''' [ID]=1 | |||
</desc> | |||
----------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------- | ||
<def> | <def> | ||
<funcDef lang="vs"> | <funcDef lang="vs"> | ||
FUNCTION DBObjSQLSetRead( | FUNCTION DBObjSQLSetRead(hRecord:HANDLE; SQLSentence:DYNARRAY[] of CHAR) : BOOLEAN; | ||
</funcDef> | </funcDef> | ||
<funcDef lang="py"> | <funcDef lang="py"> | ||
def vs.DBObjSQLSetRead( | def vs.DBObjSQLSetRead(hRecord, SQLSentence): | ||
return BOOLEAN | return BOOLEAN | ||
</funcDef> | </funcDef> | ||
| Line 23: | Line 29: | ||
<lineList ident=1> | <lineList ident=1> | ||
<line> | <line> | ||
hRecord | |||
HANDLE | HANDLE | ||
The handle to linked record. | |||
</line> | </line> | ||
<line> | <line> | ||
SQLSentence | SQLSentence | ||
DYNARRAY[] of CHAR | DYNARRAY[] of CHAR | ||
The SELECT query. | |||
</line> | </line> | ||
</lineList> | </lineList> | ||
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 read.
This SQL query is used to update the Vectorworks document, so the query should be an SELECT query, e.g.
SELECT [ID],[Center Mark Size],[Use Center Marks],[Height],[Struct Width],[Struct Depth] FROM [Columns] WHERE [ID]=1
FUNCTION DBObjSQLSetRead(
hRecord :HANDLE;
SQLSentence :DYNARRAY[] of CHAR) : BOOLEAN;
def vs.DBObjSQLSetRead(hRecord, SQLSentence):
return BOOLEAN
Parameters
hRecord HANDLE The handle to linked record. SQLSentence DYNARRAY[] of CHAR The SELECT query.
Version
Availability: from Vectorworks 2011