[transfer-dev] Re: Autoincredmening a non-primary key field.

2009-03-04 Thread Sir Rawlins
Subject: [transfer-dev] Re: Autoincredmening a non-primary key field. J! high five Good to see you mate. That certainly sounds like a good option! it is a little long winded but not impossible, I just wonder if there is a better option, perhaps a setting in my SQL Server that'll do

[transfer-dev] Re: Autoincredmening a non-primary key field.

2009-03-04 Thread James Allen
Of Sir Rawlins Sent: 04 March 2009 17:35 To: transfer-dev Subject: [transfer-dev] Re: Autoincredmening a non-primary key field. James you sexy boy, I implemented your solution to this and it works a charm, good thinking. Rob On Mar 3, 3:42 pm, Sir Rawlins robert.rawl...@thinkbluemedia.co.uk wrote

[transfer-dev] Re: Autoincredmening a non-primary key field.

2009-03-03 Thread James Allen
Sir Rawlins! high five :) Your problem is an interesting one. The error is like you say is caused by Rank being an auto incrementer field. When saving the object, Transfer is using a NULL value in the INSERT statement and this of course is illegal in SQL server due to the field type. My

[transfer-dev] Re: Autoincredmening a non-primary key field.

2009-03-03 Thread Sir Rawlins
J! high five Good to see you mate. That certainly sounds like a good option! it is a little long winded but not impossible, I just wonder if there is a better option, perhaps a setting in my SQL Server that'll do it for me? I like your approach though, its not THAT bad if that's the route I've

[transfer-dev] Re: Autoincredmening a non-primary key field.

2009-03-03 Thread James Allen
@googlegroups.com [mailto:transfer-...@googlegroups.com] On Behalf Of Sir Rawlins Sent: 03 March 2009 14:00 To: transfer-dev Subject: [transfer-dev] Re: Autoincredmening a non-primary key field. J! high five Good to see you mate. That certainly sounds like a good option! it is a little long winded

[transfer-dev] Re: Autoincredmening a non-primary key field.

2009-03-03 Thread Bob Silverberg
Of Sir Rawlins Sent: 03 March 2009 14:00 To: transfer-dev Subject: [transfer-dev] Re: Autoincredmening a non-primary key field. J! high five Good to see you mate. That certainly sounds like a good option! it is a little long winded but not impossible, I just wonder if there is a better

[transfer-dev] Re: Autoincredmening a non-primary key field.

2009-03-03 Thread James Allen
] On Behalf Of Bob Silverberg Sent: 03 March 2009 15:37 To: transfer-dev@googlegroups.com Subject: [transfer-dev] Re: Autoincredmening a non-primary key field. It sounds like you've figured out that using an auto-increment field for this purpose isn't going to work, as you cannot update the value

[transfer-dev] Re: Autoincredmening a non-primary key field.

2009-03-03 Thread Sir Rawlins
Of Sir Rawlins Sent: 03 March 2009 14:00 To: transfer-dev Subject: [transfer-dev] Re: Autoincredmening a non-primary key field. J! high five Good to see you mate. That certainly sounds like a good option! it is a little long winded but not impossible, I just wonder if there is a better