>>Don't you need a set on this line:
>>objcmd.ActiveConnection = oConn
>>Like:
>>Set objcmd.ActiveConnection = oConn
>>Also, can you paste the value of UpdateStr here?
To the first question of "set" - no. This is a value of the object objcmd and is the same in all my pages - those that work and those that don't. Wish it were something this obvious,tho <g>!
The value of updatestr is:
insert into corecomponent (component_name,component_description,
component_class,create_date,create_userid,uniqueness_column,
manager_type,component_status) values ('A NEW TYPE ',
'A FULL DESCRIPTION OF THE TYPE BEING ADDED.',3 ,'11/16/00 9:15:18 AM',
'combsv','_11/16/0091518',0,58)
I can paste this string into iSQL and it executes just dandy. BTW, the key on this table is system generated (the primary identify field) and a query of that field confirms that the new record is NOT being added but there are no error messages being generated...
What AM I doing wrong? Thanks for considering this, let me know if you spot anything.
Vicki Combs
Customized software for today AND tomorrow...
Applications and web sites designed, developed and maintained. (MBE)
"Change is inevitable...unless that's changed!