<< Click to Display Table of Contents >>

Navigation: Programming Mechworks PDM > DBWCommandShell > Library Reference > Database >

DBWGetInsertCmdValue

Description

Gets the value from an DBWorks-generated sql INSERT command, given the name of a field.

Syntax

Function DBWGetInsertCmdValue(FieldName)

Parameters

FieldName

the field to set in the sql statement

Example

'given the DBWorks-generated sql statement
'INSERT INTO A (FIELD1,FIELD2,FIELD3) VALUES ('val1',1234,'val3')
val = DBWGetInsertCmdValue( FIELD2 )
'val will contain '1234'