On Thursday 13 March 2003 20:27, Steve Holt wrote:
> I am linking an MS Access front end to MYSQL on the back with ODBC
> If I open the table I can enter a value in the course name field only which
> is the primary key
> and it will save the record even though I have not entered values in the
> fie
On Wed, 2002-08-28 at 21:17, Keith C. Ivey wrote:
> Not paying attention to case. As you said earlier, the code for NULL
> is \N, not \n.
Oh my! I feel so stupid! I should have known to check the case better by now.
\n is a newline in mysql, right? That's probably why the lines are 'broken' in
ok , but I have now just programmed around the error
to meet my deadline...
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 6:08 AM
To: [EMAIL PROTECTED]
Subject: Re: RE: null
Mary,
Wednesday, August 14, 2002, 7:23:47 PM
Mary,
Wednesday, August 14, 2002, 7:23:47 PM, you wrote:
MS> here is is ...
MS> 'check to see if agent/dist code are already in temp table
MS> sSql = "SELECT *" & _
MS>" FROM TempSap " & _
MS>" WHERE Produc
> sql,query
> > The current
> > behavior is what I'd expect to have happen, and what I'd expect most
> > people to expect to have happen. Maybe you just need to adjust your
> > expectations.
Paul/Keith:
OK, I see. It was a varchar field, so I assume it must have been entering
empty strin