[web2py] Re: import table

2010-01-09 Thread leone
I resolved with a new validator IS_AUTONUMBER

On 9 Gen, 11:07, leone  wrote:
> Thanks for yours suggests.
> I have already created a new colum as integer valorized with rowids of
> old table.
> But I have to set it with the new value (in progress) when I insert a
> new row.
> There is a smart way to do it?
> leone
>
> On 9 Gen, 09:56, Philip Kilner  wrote:
>
>
>
> > Hi Leone,
>
> > leone wrote:
> > > I must import tables from a database manteining the id value of
> > > original tables.
> > > How can I do? It seems not possible force a value in rowid.
>
> > Let web2py assign the id incrementally, as normal.
>
> > Treat the imported row_id as a separate column of data, but set it as
> > unique.
>
> > > Is it possible have more than one autonumber Field (not as rowid) in a
> > > table?
>
> > Probably not (the limitation would be at the db level), but in this case
> > you do not need to - the /imported/ row_id will be an autonumber field
> > in the system where it is /generated/, but it has already been generated
> > at the point that you import the data into web2py, so it just needs to
> > be a unique integer in web2py.
>
> > HTH
>
> > --
>
> > Regards,
>
> > PhilK
>
> > Email: p...@xfr.co.uk
>
> > 'a bell is a cup...until it is struck'
-- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py] Re: import table

2010-01-09 Thread leone
Thanks for yours suggests.
I have already created a new colum as integer valorized with rowids of
old table.
But I have to set it with the new value (in progress) when I insert a
new row.
There is a smart way to do it?
leone

On 9 Gen, 09:56, Philip Kilner  wrote:
> Hi Leone,
>
> leone wrote:
> > I must import tables from a database manteining the id value of
> > original tables.
> > How can I do? It seems not possible force a value in rowid.
>
> Let web2py assign the id incrementally, as normal.
>
> Treat the imported row_id as a separate column of data, but set it as
> unique.
>
> > Is it possible have more than one autonumber Field (not as rowid) in a
> > table?
>
> Probably not (the limitation would be at the db level), but in this case
> you do not need to - the /imported/ row_id will be an autonumber field
> in the system where it is /generated/, but it has already been generated
> at the point that you import the data into web2py, so it just needs to
> be a unique integer in web2py.
>
> HTH
>
> --
>
> Regards,
>
> PhilK
>
> Email: p...@xfr.co.uk
>
> 'a bell is a cup...until it is struck'
-- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.