no database submit option

[Blackduke]

I have created a form based on a SQL 2000 table however when I add a
button and look at the actions and change it to submit there was no
submit to data base option.

any ideas

thanks

 

[Blackduke]

Seems I may have found out why but I am not sure how to fix, there is
no primary key, and if i am correct a primary key must be unique,
however the columns I am using could well not be unique, how can i get
around this.

thanks

 

[Scott L. Heim [MSFT]]

Hi,

There could be a few options as to why you do not have this:

- No primary key: if your data cannot be used as a primary key, you will
need to add a field to the SQL table that will be set as the primary key.
For example:

Name: ID
Data Type: Int
Allow Nulls: No
Identity: Yes
Identity Seed: 1

- You have "long" data types (i.e. Image, Text, etc.): If this is the case,
you will either need to change the data types or use a web service to
retrieve/update your data.

I hope this helps!

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.