The new DAL will allow this. I am working on it but it is a complex
thing and I do not know for sure when it will be done. I hope in one
month. I cannot take a patch to do this in the current DAL because it
would break a lot of stuff.
Sorry.
There must be a way to define an alias (or a view) in Oracle. That may
be an easier solution.
On Dec 22, 10:17 am, Alexey Nezhdanov <snak...@gmail.com> wrote:
> Sorry for double posting. While this would be an ideal - it is clearly not
> supported atm. But may be I can somehow emulate it by, say, initialising
> table with the usual way and then doing something like
> db.inet.var1.var2='rad....@inet' ?
> If there is any coding needed - that's ok too, I can submit a patch (just
> like before).
>
> On Tue, Dec 22, 2009 at 7:15 PM, Alexey Nezhdanov <snak...@gmail.com> wrote:
> > I do not know actually as I am not the Oracle expert (or even regular
> > user). Will find out tomorrow.
> > Suppose - I can't - can you give any clue how to make an alias in web2py?
> > The ideal would be something like this:
>
> > db.define_table('inet', internal_name='rad....@inet',
>
> > Field('ip','string',length=16),
> > migrate=False
> > )
>
> > On Tue, Dec 22, 2009 at 5:47 PM, mdipierro <mdipie...@cs.depaul.edu>wrote:
>
> >> No. "." and "@" are not allowed in table names. Can you alias in
> >> Orcale?
>
> >> On Dec 22, 12:15 am, Alexey Nezhdanov <snak...@gmail.com> wrote:
> >> > Hello.
> >> > I've googled this group for my problem, but didn't find the answer.
> >> > It seems that problem was mentioned once [1] [2], but I do not know if
> >> any
> >> > solution was done.
>
> >> > I need to connect to existing database so things like 'schemas are not
> >> > portable' are not really acceptable - I should be able to connect,
> >> period.
> >> > What is worse - there are actually two servers - DB2 and Oracle. I do
> >> not
> >> > have direct access to DB2 database and have to connect through Oracle.
> >> > So the sql query looks like this:
>
> >> > SELECT ip FROM rad....@inet
>
> >> > so here is scheme RAD, table NAS at the 'INET' DB2 database.
>
> >> > web2py refuses me to do this:
>
> >> > db.define_table('rad....@inet',
> >> > Field('ip','string',length=16),
> >> > migrate=False
> >> > )
>
> >> > So what should I do? Is there any way out?
> >> > Thanks
>
> >> > [1]
> >>http://groups.google.com/group/web2py/search?group=web2py&q=oracle+ta...
> >> > [2]
> >>http://groups.google.com/group/web2py/browse_thread/thread/3c27af0533...
>
> >> > --
> >> > Regards
> >> > Alexey Nezhdanov
>
> >> --
> >> Regards
>
> > Alexey
>
>
--
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.
