U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » Table field name conflict?

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Switch to threaded view of this topic

Create a new topic

Submit Reply

Table field name conflict? [message #14527]

Fri, 29 February 2008 04:19

indiocolifa is currently offline

indiocolifa
Messages: 49
Registered: January 2008
Location: Argentina

Member

It is possible that with U++ (i'm using 2008.1 beta) you can't define a schema where one field in a table cannot be named equal to other field in a different table?

Example schema:

TABLE_(T1)
INT_ (F1)
END_TABLE

TABLE_ (T2)
TEXT_ (F1)
END_TABLE

F1 redefinition error...

Any help ?

Report message to a moderator

Send a private message to this user

Re: Table field name conflict? [message #14555 is a reply to message #14527]

Mon, 03 March 2008 18:30

Alex is currently offline

Alex
Messages: 18
Registered: October 2007
Location: Germany

Promising Member

Hello,

for the second definition remove the Underscore.

TABLE_ (T2)
TEXT (F1)
END_TABLE

HTH, Alex

Report message to a moderator

Send a private message to this user

Re: Table field name conflict? [message #14585 is a reply to message #14555]

Tue, 04 March 2008 08:10

sergeynikitin is currently offline

sergeynikitin
Messages: 748
Registered: January 2008
Location: Moscow, Russia

Contributor

sergeynikitin@jabber.ru

May I use names as T1.F1 and T2.F1 ?

SergeyNikitin<U++>( linux, wine )
{
under( Ubuntu || Debian || Raspbian );
}

Report message to a moderator

Send a private message to this user

Re: Table field name conflict? [message #14598 is a reply to message #14555]

Tue, 04 March 2008 13:53

indiocolifa is currently offline

indiocolifa
Messages: 49
Registered: January 2008
Location: Argentina

Member

Alex wrote on Mon, 03 March 2008 15:30

Hello,

for the second definition remove the Underscore.

TABLE_ (T2)
TEXT (F1)
END_TABLE

HTH, Alex

And for a third definition of F1?! Laughing

Laughing

Report message to a moderator

Send a private message to this user

Re: Table field name conflict? [message #14609 is a reply to message #14585]

Tue, 04 March 2008 15:21

mirek is currently offline

mirek
Messages: 13975
Registered: November 2005

Ultimate Member

Well, if we are speaking about SqlExp, yes, but you have to use this form:

F1.Of(T1)

Mirek

Report message to a moderator

Send a private message to this user

Switch to threaded view of this topic

Create a new topic

Submit Reply

Previous Topic:	How to save the DB data to another SQLite db file in HomeBudget?
Next Topic:	Methods of SQL debugging

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Thu Apr 25 11:52:22 CEST 2024

Total time taken to generate the page: 0.03655 seconds