Re: From OpenBase To MSSQLServer2000 (built app)
Re: From OpenBase To MSSQLServer2000 (built app)
- Subject: Re: From OpenBase To MSSQLServer2000 (built app)
- From: "Jonathan Fleming" <email@hidden>
- Date: Fri, 30 May 2003 20:13:30 +0100
I can't seem to save data entered through a form in the build web app. In
MSSQLServer2000 I have set the permissions on public for each user table to
yes or a tick for SELECT, INSERT, UPDATE, DELETE and DRI but I get no joy is
there some other permissions that need to be set too?
Bare in mind everything worked and tested well under stress in OpenBase so I
was hoping there would not be too much chopping and changing now I've had to
move to MSSQLServer2000 (my fingers are crossed)
Requesting your help.
Jonathan
PS. One other question, Should I set the primary key column Identity option
tag in the table design to True/Yes on each table or leave it as it is set
on False/No.
When I created the tables from the SQL Generated in EOModeller all seemed
well, the relationships copied over fine, the PK's and FK's seem OK, but
there are obviously things in MSSQLServer2000 that EOModeller will not set.
In the Northwind example some are set others are not. I don't exactly
understand what this option does or how it may alter your table design.
_________________________________________________________________
On the move? Get Hotmail on your mobile phone http://www.msn.co.uk/msnmobile
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.