[web2py] Re: Primary Key tables in MSSQL. Cannot get them to work

Yes, I don't think you can use SQLFORM crud unless you have an 'id' column, or another primary key column that is an INT. On Wednesday, March 28, 2012 5:28:44 PM UTC-7, Andrew wrote: Thankyou Derek, I will give it a try , but this was only a simple, cut down, test case to get it to work

[web2py] Re: Primary Key tables in MSSQL. Cannot get them to work

Try changing your field1 type to 'id'. like this: Field('Field1', 'id'), On Tuesday, March 27, 2012 10:56:44 PM UTC-7, Andrew wrote: Hello, I posted on this issue some time ago and I'm pretty sure it was working again after a fix from DenesL. However I can't get Primary Key tables in MSSQL

[web2py] Re: Primary Key tables in MSSQL. Cannot get them to work

Thankyou Derek, I will give it a try , but this was only a simple, cut down, test case to get it to work initially. I originally had a string for the PK, and I also wanted to test multi column PKs. I am confident the 'id' will work, but it doesn't address the other scenarios. My real goal