Viewing 15 posts - 3,301 through 3,315 (of 3,518 total)
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.
June 30, 2003 at 9:38 am
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...
June 30, 2003 at 2:40 am
quote:
David, quick question. When you select from this table are you joining to it or from it? When you join...
June 30, 2003 at 2:20 am
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...
June 27, 2003 at 10:39 am
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...
June 27, 2003 at 5:30 am
quote:
I've had to deal with are errors like PK violations ... I would like to figure out how to trap these kinds...
June 26, 2003 at 7:30 am
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...
June 26, 2003 at 7:16 am
quote:
Always, always, always cluster/primary key the ident in a reference table.
OK, I have a table...
June 26, 2003 at 2:41 am
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...
June 26, 2003 at 2:25 am
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...
June 26, 2003 at 2:16 am
quote:
reminds me of some evil joke with mathematicians and algebraic sign errors.
Not "Solution...
June 25, 2003 at 5:02 am
quote:
Just thinking off the wall for a moment, would a stored procedure with a case statment containing the values be quicker?
June 25, 2003 at 3:21 am
I always put a primary key on tables even if I have to use an identity column to force one. Thinking back to my MS Access days the SQL...
June 25, 2003 at 3:19 am
quote:
.. If its an internet app then not very much x huge audience = major headache.Not sure if I get the meaning
Cheers,
Frank
June 25, 2003 at 3:01 am
I would tend to index the table on principle but if it is virtually static I would make sure that the index has a very high fill factor.
As you will...
June 25, 2003 at 2:29 am
Viewing 15 posts - 3,301 through 3,315 (of 3,518 total)