>I have some code that was working fine but now it has quit functioning.
>
>Store SQLConnect('webprddtx','sde','mypassword') To gnHandle1n
>testthissd = "INSERT INTO drawmstrp(dm_drawing_number) Values('855459')"
>= SQLSETPROP(gnHandle1n, 'Transactions', 2)
>= SQLEXEC(gnHandle1n, testthissd)
>= SQLCOMMIT(gnHandle1n)
>
>=SQLDISCONNECT(gnHandle1n)
>EndIf
>
>SQLCommitt returns a 1 but the as400 table is not appended too.
Dumb question: is the SQLEXEC()
also returning 1?