Data Connections

Re: Error When Submitting - Primary Key?

Michael71 — Wed, 22 Nov 2006 15:30:16 GMT

Try this......

Make sure Primary id int(data type) 4(Length)

At the bottom of the bottom the Columns should be set to.....

Precision = 10
Scale = 0
Idenity = Yes
Identity seed = 1
Idenitity Increment = 1
ISRowGuid = No

Re: Error When Submitting - Primary Key?

derrickgh — Wed, 22 Nov 2006 14:43:07 GMT

The PK is set to "int" and permissions are set correctly. Any other suggestions would be appreciated. Thank You!

Re: Error When Submitting - Primary Key?

Michael71 — Wed, 22 Nov 2006 03:58:51 GMT

I had the same problem many times, I had to troubleshoot the issue. When I experience the problem, the data type for the primary key was wrong(should be int) or the permissions to submit to the database has to be true for update, insert, view. Good Luck.

Error When Submitting - Primary Key?

derrickgh — Tue, 21 Nov 2006 22:40:42 GMT

I am creating a form that is connected to a SQL DB. The form is conected to a couple different tables. When I hit submitt it returns the error "Field or group: TargetMarketID Error: Only integers allowed"

This field is the PK, looking at functioning forms the only difference I can find is that the properties on my PK are set at "int" and the functioning forms properties PK are set at "optional_int." Also my PK is set to require a value and will not let me edit the field. Any help would be appreciated. Thank You!