Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

Create an inital record in table when installing

Jun 6, 2002, 11:27 AM
Ian
Veteran (2577 posts)
Jun 6, 2002, 11:27 AM
Views: 19765
Shortcut
 
Create an inital record in table when installing
This sounded easy, but I think I am doing it wrong.

I want to create an inital (default) record in a table when it is first created. Do I have to do this with a seperate ADD statement, or can this be done in the CREATE somehow?

This particular table should only ever have one record in it... so I dont want to really ADD another row, just set the first one if it does not already exist.

Does that make sense?

Many thanks!


Edit: I have semi solved this just be checking the number of rows, and if less than 1, doing an update on the table....


http://www.iuni.com/...tware/web/index.html
Links Plugins

Last edited by:

Ian: Jun 6, 2002, 12:14 PM
Subject Author Views Date
Thread; locked thread Create an inital record in table when installing Ian 19765 Jun 6, 2002, 11:27 AM
Thread Re: [Ian] Create an inital record in table when installing 		Paul 19436 Jun 6, 2002, 12:35 PM
Thread Re: [Paul] Create an inital record in table when installing 		Ian 19288 Jun 6, 2002, 12:43 PM
Thread Re: [Ian] Create an inital record in table when installing 		Paul 19320 Jun 6, 2002, 12:46 PM
Thread Re: [Paul] Create an inital record in table when installing 		Ian 19337 Jun 6, 2002, 12:52 PM
Thread Re: [Ian] Create an inital record in table when installing 		Crapshoot70 19511 Jun 6, 2002, 1:34 PM
Thread Re: [Crapshoot70] Create an inital record in table when installing 		Stealth 19307 Jun 6, 2002, 7:24 PM
Thread Re: [Stealth] Create an inital record in table when installing 		Crapshoot70 19314 Jun 8, 2002, 11:12 AM
Post Re: [Crapshoot70] Create an inital record in table when installing 		Paul 19224 Jun 8, 2002, 11:15 AM
Thread Re: [Crapshoot70] Create an inital record in table when installing 		Stealth 19402 Jun 8, 2002, 11:43 AM
Thread Re: [Stealth] Create an inital record in table when installing 		Crapshoot70 19247 Jun 9, 2002, 8:36 AM
Thread Re: [Crapshoot70] Create an inital record in table when installing 		Stealth 19260 Jun 9, 2002, 5:45 PM
Thread Re: [Stealth] Create an inital record in table when installing 		Paul 19274 Jun 10, 2002, 1:57 AM
Post Re: [Paul] Create an inital record in table when installing 		Ian 19112 Jun 10, 2002, 9:37 AM
Thread Re: [Paul] Create an inital record in table when installing 		Stealth 19176 Jun 10, 2002, 12:46 PM
Thread Re: [Stealth] Create an inital record in table when installing 		Crapshoot70 19151 Jun 10, 2002, 8:19 PM
Post Re: [Crapshoot70] Create an inital record in table when installing 		Stealth 19140 Jun 10, 2002, 8:23 PM
Post Create an inital record in table when installing 		Ian 19153 Jun 8, 2002, 12:21 PM
Post Re: [Ian] Create an inital record in table when installing 		Alex 19126 Jun 10, 2002, 9:54 PM