RE: SQL 2000 & Null Values...
From: Nonoy of Philippines (NonoyofPhilippines_at_discussions.microsoft.com)
Date: 09/03/04
- Next message: Leonid: "Re: DOS command window handler"
- Previous message: Sietse Wijnker: "Re: DOS command window handler"
- In reply to: Chris Marsh: "SQL 2000 & Null Values..."
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 3 Sep 2004 01:43:10 -0700
Hi,
I'm not sure if this will help you. But columns that are stored with Null
values are usually set to allow null values with them. This happens during
insert and we don't assign a value to the field. Why don't you assign a
default value to the field? That may help fix the problem.
"Chris Marsh" wrote:
> Hi,
>
> I we are using VFP & SQL2000 together. At one clients office we are getting
> problems with data storing "Null" values in about a dozen different columns
> in 4 different tables. I did some research and realized that when we
> reinstalled the server we skipped putting SP3 in place. So, I did that last
> night hoping that would resolve the problems. However, that wasn't the
> case. We had the same problem today that we had yesterday. Part of the
> SP3a relates to a bug fix for Q236876 and Q313352 which somewhat look like
> the same problems we had been having. Please keep in mind the code works X
> amount of the time it just fails occasionally.
>
> Now, during the install of SP3a I had a problem on the MDAC piece of the
> install. How do I tell if the current MDAC 2.71 is in place? And, this is
> in an environment that functions between a 2003 Server and a 2000 SBS (SQL
> Server). Any known issues here?
>
> Lastly, is there any suggested code that we should put into place that will
> help prevent this problem if it's not an ODBC issue rather a coding problem?
>
> Thanks - I know I have a complicated puzzle here.
>
> Chris
>
>
>
- Next message: Leonid: "Re: DOS command window handler"
- Previous message: Sietse Wijnker: "Re: DOS command window handler"
- In reply to: Chris Marsh: "SQL 2000 & Null Values..."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
