Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 2 of 2 total

Wed, Apr 18 2007 6:26 PM	Permanent Link
"Lance R"	It doesn't like my timestamp insertion. I've tried it every which way but the right way... lol. All qoutes except around taddresstype are single quotes. Lance EXECUTE IMMEDIATE 'INSERT INTO "taddresstype" VALUES ( ''{2AD33F4D-D9B0-40FD-AFAF-7A3EE8C1B1EF}'', ''Billing'', ''2007-04-17 12:00'', ''2007-04-17 12:00'', True, 3)';
Wed, Apr 18 2007 7:01 PM	Permanent Link
"Lance R"	Sorry.. Should move this one to SQL "Lance R" <lance@cdesoftware.com> wrote in message news:FB6BC486-8400-4EC2-AA61-188BC9B6BD2F@news.elevatesoft.com... > It doesn't like my timestamp insertion. I've tried it every which way but > the right way... lol. > All qoutes except around taddresstype are single quotes. > > Lance > > > > EXECUTE IMMEDIATE 'INSERT INTO "taddresstype" VALUES ( > ''{2AD33F4D-D9B0-40FD-AFAF-7A3EE8C1B1EF}'', > ''Billing'', > ''2007-04-17 12:00'', > ''2007-04-17 12:00'', > True, > 3)'; > > >