FUDforum: Database discussions » Zero values in fields

Home » General » Database discussions » Zero values in fields

Show: Today's Messages :: Polls :: Message Navigator

Re: Zero values in fields [message #19842 is a reply to message #19820]

Sun, 12 September 2004 14:32

dataj1998

Messages: 31
Registered: June 2004
Location: Germany

Karma:

Member

The solution with the option "NOT NULL" should do the whole job.

If a field is defined to be not null, you should always get a value back. But please be careful: You should set a default value for that field. If you insert a record and leave out a field with the option set and you don't have a default value, your insert will fail.

Report message to a moderator

[Message index]

		Zero values in fields By: Abraxa on Tue, 07 September 2004 00:50
		Re: Zero values in fields By: dataj1998 on Tue, 07 September 2004 12:15
		Re: Zero values in fields By: Abraxa on Sat, 11 September 2004 01:49
		Re: Zero values in fields By: dataj1998 on Sun, 12 September 2004 14:32
		Re: Zero values in fields By: Abraxa on Sun, 12 September 2004 19:36
		Re: Zero values in fields By: dataj1998 on Sun, 12 September 2004 21:37
		Re: Zero values in fields By: alansmith on Sun, 03 October 2004 10:50
		Re: Zero values in fields By: Ilia on Mon, 04 October 2004 13:17

Previous Topic:	2 Fud Forums, Can I combine users
Next Topic:	Determining when to use INSERT or UPDATE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 04:10:48 GMT 2024

Total time taken to generate the page: 0.04351 seconds