|
|
Posted by Neil on 10/31/05 05:09
> I've not had any problems with Host_name() as a parameter, as the only
> records I retrieve are for my particular machine there is very little
> point in returning that column so I never ask the server for it as I know
> the value already.
>
> A couple of things you need to know about Access and SQL Server, firstly
> bit fields should be made NOT NULL and default to 0 as Access interprets
> these as Jet Yes/No columns and treats them accordingly so it expects a
> value to be there (In Access/Jet, a Yes/No column cannot be null and
> defaults to 0). The results otherwise can be unpredictable.
Yes, the bit field is Not Null and defaults to zero.
>
> Secondly, if you have any floating point columns in your data (including
> datetime as these are stored as floating point numbers) then you most
> probably need a timestamp column as floating point errors can cause the
> #Deleted condition you describe.
I don't have any floating point columns in my table. However, I went ahead
and added a timestamp field anyway. Same results.
Neil
Navigation:
[Reply to this message]
|