I'm experimenting with some code to deploy forms from a development database to the production database by directly putting them into the SYS_FORMS3 table of the production database.
I SCONNECT the production database, and SATTACH the SYS_FORMS3 table as FormsTarget. I can select from the table and see the rows. However, if I try to issue a DELETE against FormsTarget I get a message from the ODBC Driver Manager saying "Program type out of range". I can successfully push the DELETE command through SSQL (of course change the table name back to SYS_FORMS3) and the appropriate row will be deleted. When I then try to INSERT a row into FormsTarget using the INSERT INTO FormsTarget SELECT * FROM SYS_FORMS3 . . syntax I get the same error. This time, there's no way to push the command through SSQL since I need the LONG VARCHAR values from the SYS_FORMS3 datbase. Does anyone have any experience directly updating the forms and reports tables in an SCONNECTED database like this? -- Larry
