PHP IDE :: NuSphere Forums :: View topic

Posted: Tue Jun 19, 2007 2:50 pm

I've got a simple database setup using the new MSSQL 2005 Schema notation. Instead of having dbo.<table> my setup is schema.<table> this seems to work fine in code view while I'm manually creating my sql queries, but if I try and use the DB form wizard it blows up. I get the error "SQL Server Error: Invalid object name '<name>'"

However, if I use the DB Form Wizard on a standard dbo object ( dbo.<table> ) everything works as expected. Also, I've tried using standard users as well as the sa account and I get the same error, so it does not seem to be security related.

Thanks for the help here,
Steve

Posted: Wed Jun 20, 2007 8:41 am

Sorry, I posted this in the wrong forum, and in fact shouldn't have posted it in the forum at all. I also submitted this to the support team with some SQL to demonstrate the problem. I received a quick response and was informed they would "most likely fix it in 5.1".

Hope this Helps someone else,
Steve

Just as an fyi - here's part of the SQL I'm using...

Code:

CREATE SCHEMA MorningReport;

CREATE TABLE [MorningReport].[step1] (
id int not null identity(1,1) primary key
, ipmonitor_status varchar(25) not null check( ipmonitor_status in ('GREEN', 'ORANGE', 'RED') )
, temperature decimal(3,1) default (0) check( temperature between 0.0 and 299.9 )
, humidity decimal(2,0) default (0) check( humidity between 0.0 and 99.9 )
, submitted_by varchar(25) not null
, submit_date varchar(10) not null default ( convert( varchar(10), getdate(), 120) )
, record_inserted datetime not null default ( getdate() )
, CONSTRAINT Unique_subDate UNIQUE( submit_date )
);

Posted: Thu Oct 18, 2007 10:42 am

I'm sorry to say this issue (see above post) has not yet been resolved. Confused

I am well aware that those of us using MSSQL are a tiny portion of your user base, but please take a look at this and fix it as soon as you can.

Thanks,

Steve Graham
Advantage Member