Up Prev Next
From: Brad Collins <bradc at micromuse dot com>
Subject: A cgi ?
Date: Aug 13 1998 4:52PM
I'm just full of tedious questions this week aren't I? :)
Anyhow, I've built a handy "History" tool on the web. It works
from one database, it's actually right nifty if I do say so my self :) I
We've created a new database, and I'm trying to run the same reports
across it to no avail. I get this:
Message number: 416, Severity 16, State 1, Line 1
Message String: Create of work table failed because row size would be
2106. This exceeds the maximum allowable size of a row in a table,
The difference between the old database and new database (on the same
dataserver) is one column has increased from a numeric(8) to a
and we have added about 12 columns.
I wrote another sybperl script that sucks all the data out of the old
database and builds a huge insert file in the new order. All the old
has been successfully populated into the new Database.
If I do this exact same query sybperl is trying to do from isql it works
fine, however when I run the script I get the error message above.
I'll be glad to provide source if its needed!
Thanks for your help!