bitbucket-25253 (2/28/2010)

---

I'm creating triggers that create/update a record in a history table as records are added to a master table. If a new record is added to the master, a...

...like misspelling a column name only to discover the mistake too deep into development to change it?

...and then I switched databases from 'master' to the correct database. Imagine how that fixes things.

I fixed the brackets, but its still a no-go. I even copied the altered code as-is.

Something else to blame the recession on. The project was ready to start its shakedown and then yanked with a cease & decease email. Its now being revisited on a...

Luke L (10/13/2009)

---

Since you're doing this in ASP, why not get your recordset from the database in the order it will be in, put it in a datagridview do whatever...

I'll have to play with that. Pretty much as I get something up and running, I'm moving on to the next issue and then later going back to refine.

Bob Hovious 24601 (10/12/2009)

---

You can use a CTE as the source for the update, like so.

declare @sampleSource table (rowid int identity(1,1),priority int) -- this would be your temp table

declare...

Bob Hovious 24601 (10/12/2009)

---

The effectively places the records in the temp table in order of priority. This was necessary since an UPDATE statement cannot specify the order in which records...

The original post seems confusing. Are you viewing the data in an Access front end or are you viewing it via an a ASP.NET page? The relationship between Access, ASP.NET...

eko indriyawan (10/7/2009)

---

I'm as a Developer. I afraid when sell my application, my customer can open all the stored procedure and endpoint that I have been created. if they use...

If it hasn't been mentioned, try posting in this newsgroup...

http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.access.modulesdaovba&lang=en&cr=US

Based on your original post, it sounds like you want to prevent a user from directly access SQLServer objects...

Jeff Moden (10/7/2009)

---

Keep in mind that UNIQUE...

I just answered my own question...

Alter table contactuserids

Add constraint ix_WindowsUserId UNIQUE(WindowsUserID)

Alter table contactuserids

Add constraint ix_ContactId Unique(ContactId)

I just didn't know what the term was.

I had already planned on shifting everything to stored procedures so it sounds like I'm on the right track. Even though its for an intranet, the idea is not to...