Function.ODBC.Connection!ConnectionName.Execute

From GAB Help
Jump to: navigation, search

Executes a SQL statement for database access. The example will update the CompDt, Seq,and Grp where the row where the parent is equal to the variable.

Syntax

Function.ODBC.Connection!ConnectionName.Execute (SQL Statements [string])

Arguments

SQL Statement

Statement that tells what information to get from a database

Example

Variable.local.sSQL.declare(string)
Variable.local.sDate.declare(string)
Variable.local.iGrp.declare(long)
F.Intrinsic.String.Concat("Update ATG_BOM_Comp set CompDt='2007-11-15',Seq=2,Grp=",V.Local.iGrp," where Parent='",V.Global.sBoM2.Trim,"'",V.Local.sSQL)
F.ODBC.Connection!conP.Execute(V.Local.sSQL) 

Remarks

  • For those VB Programmers out there this is like a con.execute statement.