Re: Problem using linked tables instead of ADP


"Monte" <Monte@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:46D395BA-E150-4C96-9EDE-AF4776FBC18A@xxxxxxxxxxxxxxxx
>I have also seen this problem occur when I have "bit" type fields in the
>SQL
> table, and don't have a default value (say zero) and allow nulls checked.

Monte

Scary stuff hey :o{

I'm not going to worry about it too much as I was just playing to see the
difference in performance etc. Would still be interested to know why, may
have another look later...

Cheers

Mark


.

Relevant Pages

  • Write Conflict.. Urgent .. Please help.
    ... type fields that do not have a default value set in ... the table design. ... When you add or edit a record, SQL ... fields have a default value of zero, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: V$SGA_TARGET_ADVICE in Oracle RDBMS 10.2
    ... > SQL that defines gv$sga_target_advice. ... > and v$ views to overwrite the proper ... The last column causes division by zero. ... Prev by Date: ...
    (comp.databases.oracle.server)
  • Re: Examples of SQL anomalies?
    ... If you have a bag that can contain peaches, but doesn't, then the answer to ... then the answer is clearly zero. ... ie. SQL can count zero rows with count but not with sum. ...
    (comp.databases.theory)
  • Re: Examples of SQL anomalies?
    ... then the answer is clearly zero. ... ie. SQL can count zero rows with count but not with sum. ... Fabian Pascal would say that he is doing a Celko. ... bringing up intricate arbitrary logics like Johnston's is phony in this ...
    (comp.databases.theory)
  • RE: I am receiving an #Error in my query even after using Nz funct
    ... Looks like a Whoops while posting the SQL. ... "Jerry Whittle" wrote: ... have to make sure any possibility of dividing by zero never happens. ... I have used an IIf statement, the Nz function, and even ran another query ...
    (microsoft.public.access.queries)