Adding records to my database...

rcgomez11

Member
im having problems with my codes..i thought this codes was enough but when i start to run it, its not....here is my code:

<html>
<head>
<title> Another Add Program </title>
</head>
<body>
<script language="speedscript">
if get-value("rad") <> "" then do:
create assessment-roll.
assign assessment-roll.owner-name = get-value("rsys").
queue-message(""," Added Successfully ").
end.
</script>
<form name="romel" method="post" action="entry1.html">
Name: <input type="text" name="rsys" size="15" />
<input type="submit" name="rad" value="Submit" />
</form>
</body>
</html>

the first time i run this code,it successfully adds one record then after that when i try again the second record,it wont add anymore,i cant figure it out why it is like that...anyone will be appreciated...thanks...Mr. Moderator, can you please help me too...thanks...
 

WSS_R2D2

New Member
Did you check if the second time you hit the submit button if you actually get in the if then do statement? Just to be sure..

If so, then do get an error something?
 

Cecil

19+ years progress programming and still learning.
Check your create/write tirggers or indexs/fields for unique values.

You may have created a record with an "ID" of zero and then the the next record(s) also trying to create a record with the same ID of zero.

Hope that helps.
 
Top