One of the content management systems I use is called OBTREE and all binary files are stored within the database. One client has over 8,000 binary files stored in...

My company works with many CMS vendors. The attitudes of two of them show up the stark contrasts between vendors.

Vendor A

• Denies that problems exist.
• Deletes any unfavourable...

I've been looking at e-commerce and one of the options open to me as a developer is to route the payment method through a known credit card provider. In...

My identity column is ALWAYS my primary key, otherwise there would be no point in having it. It tends to be my clustered index but won't necessarily be so.

If I...

I've also had problems where Access is referencing a VIEW and there is no primary key.

Unless Access has a primary key, virtual or otherwise, it doesn't like editing records.

Thanks for that both of you.

The other trade-off I have to consider is that I will be handing over the database and stored procedure list to other developers so that...

quote:

---

David, quick question. When you select from this table are you joining to it or from it? When you join...

It depends on your user's abilities. If they are surviving brain donors then you will need something expensive to allow them to write their own reports.

For the reasonably literate...

http://www.technology-and-computers.com/Computers/Programming/Disassemblers/6502/

BBC Model B...ahh those were the days. I've heard that there has been a major university project to extract data from the old Doomsday project that used BBC B's...

quote:

---

I've had to deal with are errors like PK violations ... I would like to figure out how to trap these kinds...

On the ADO error thing I tend to have a local stored procedure variable that I use to record errors that occur within the stored procedure.

Obviously I try and test...

quote:

---

Always, always, always cluster/primary key the ident in a reference table.

---

OK, I have a table...

Robert,

I would generally consider selecting from a non-existant table to be a bug rather than an error.

In cases where it can be a legitemate programming error I would tend to...

If your store procedure fails before hitting a RETURN statement then the return value will be zero. This is the same value that you have used if your stored...

quote:

---

reminds me of some evil joke with mathematicians and algebraic sign errors.

---

Not "Solution...