Hello
I’m trying to create a UPDATE SQL statement that will include the data, and be passed to a calling Property/CommandText as a String. See below my two examples.
Software specs: Oracle 10.5, Tuxedo, VB 2008, Visual Studio.NET
The first is the original and will expose the data with each of the variables, including the row number in cKEY_SEQ.
UPDATE DEV4.DB_ENVIRONMENTS
SET CITRIX_ICON_NAME = :cCITRIX_ICON_NAME,
DB_NAME = :DB_NAME,
TUX_SERVER = :TUX_SERVER,
TUXCFG_INI = :TUXCFG_INI
WHERE (DB_ENVIRONMENTS.KEY_SEQ = :cKEY_SEQ)
In this second example, I used the Oracle TOAD option - Editor|Make Code Statement, to set it up as a string. But notice it hides the variables containing the data rather than expose them so the data in the variables can be passed.
**SQL = " UPDATE DEV4.DB_ENVIRONMENTS "
SQL = SQL & " SET CITRIX_ICON_NAME = :cCITRIX_ICON_NAME, "
SQL = SQL & " DB_NAME = :DB_NAME, "
SQL = SQL & " TUX_SERVER = :TUX_SERVER, "
SQL = SQL & " TUXCFG_INI = :TUXCFG_INI "
SQL = SQL & " WHERE (DB_ENVIRONMENTS.KEY_SEQ = :cKEY_SEQ) "
**If the second one IS the correct way of passing data via a stringed SQL, could one please show me how I can enter that data in the sql so it can be executed in the recordset.
I would appreciate you help with this. Thanks.
Kevin
Message was edited by: Kevin33809 Message was edited by: Kevin33809
Message was edited by: Kevin33809