Nathaniel Harris
|
| Posted: 06/21/2002, 8:45 AM |
|
Hi,
I am new to CCS and would appreciate some help with a problem I have
encountered with the creation of a new record. I created a "Records
Maintenance" page with the Build wizard.
The only modification I made to the records page was to change a couple of
text boxes to list boxes.
When I attempt to add a new record I get the following error message.
Source: Record Members / Insert Operation
Command Text: INSERT INTO [Members]([title], [lname], [fname], [telephone],
[member_number], [address1], [address2], [city], [zipcode],
[martial_status], [join_method], [gender], [age], [date_joined]) VALUES (1,
'Harris', 'Nat', '770-469-0369', 22055, '123 Any Street', 'Apt # 1A',
'Dallas', 30073, 1, 3, 1, 54, #6/21/2002#)
Error description: Index or primary key cannot contain a Null value.
(Microsoft JET Database Engine)
INSERT INTO [Members]([title], [lname], [fname], [telephone],
[member_number], [address1], [address2], [city], [zipcode],
[martial_status], [join_method], [gender], [age], [date_joined]) VALUES (1,
'Harris', 'Nat', '770-469-0369', 22055, '123 Any Street', 'Apt # 1A',
'Dallas', 30073, 1, 3, 1, 54, #6/21/2002#)
I checked the database table and the key field is identified and
autoincrement.
Any advice would be appreciated.
Thanks,
Nat
|
|
|
 |
Nathaniel Harris
|
| Posted: 06/21/2002, 9:52 AM |
|
Hi again,
Ignore this post for the moment. I think I know what is causing the
problem. The query has a couple of joins and I believe that I must write a
custom query to facilitate the record insert.
Thanks,
Nat
"Nathaniel Harris" <nharris@bellsouth.net> wrote in message
news:aevhm3$vmn$1@news.codecharge.com...
> Hi,
>
> I am new to CCS and would appreciate some help with a problem I have
> encountered with the creation of a new record. I created a "Records
> Maintenance" page with the Build wizard.
>
> The only modification I made to the records page was to change a couple of
> text boxes to list boxes.
>
> When I attempt to add a new record I get the following error message.
>
> Source: Record Members / Insert Operation
> Command Text: INSERT INTO [Members]([title], [lname], [fname],
[telephone],
> [member_number], [address1], [address2], [city], [zipcode],
> [martial_status], [join_method], [gender], [age], [date_joined]) VALUES
(1,
> 'Harris', 'Nat', '770-469-0369', 22055, '123 Any Street', 'Apt # 1A',
> 'Dallas', 30073, 1, 3, 1, 54, #6/21/2002#)
>
> Error description: Index or primary key cannot contain a Null value.
> (Microsoft JET Database Engine)
> INSERT INTO [Members]([title], [lname], [fname], [telephone],
> [member_number], [address1], [address2], [city], [zipcode],
> [martial_status], [join_method], [gender], [age], [date_joined]) VALUES
(1,
> 'Harris', 'Nat', '770-469-0369', 22055, '123 Any Street', 'Apt # 1A',
> 'Dallas', 30073, 1, 3, 1, 54, #6/21/2002#)
>
> I checked the database table and the key field is identified and
> autoincrement.
>
> Any advice would be appreciated.
>
> Thanks,
> Nat
>
>
|
|
|
|
|
