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
wrote:
> Bob, J, thank you both, I th
rank. You can then increment it in your beans
> > > save() method.
>
> > > James.
>
> > > ---
> > > James Allen
> > > E: slingsho...@googlemail.com
>
> > > -Original Message-
> > > From: transfer-dev@googlegroups.com [mailto:tr
> > James.
>
> > ---
> > James Allen
> > E: slingsho...@googlemail.com
>
> > -Original Message-
> > From: transfer-dev@googlegroups.com [mailto:transfer-...@googlegroups.com]
> > On Behalf Of Sir Rawlins
> > Sent: 03 March 2009 14:00
&
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
legroups.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! Good to see you mate.
>
> That certainly sounds like a good option! it is a little long winded
> but not imposs
e-
From: transfer-dev@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! Good to see you mate.
That certainly sounds like a good option! it is a l
J! 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 got to go,
Sir Rawlins!
:)
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 suggestion is n