U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » SQLEX. Is it possible to specify a different name for a real column?

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

SQLEX. Is it possible to specify a different name for a real column? [message #58048]

Fri, 28 January 2022 13:52

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

Contributor

Is it possible to specify the name of a real column that differs from the name of the SqlId variable. For example:
instead:

	TIME_	(TIME)

(this code call compilation error, but real colomn name is TIME)
do like this:

	TIME_	(LOCTIME).NAME(TIME)

or like this:

	TIME__N	(LOCTIME,TIME)

???

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

[Updated on: Fri, 28 January 2022 13:54]

Report message to a moderator

Re: SQLEX. Is it possible to specify a different name for a real column? [message #58142 is a reply to message #58048]

Thu, 03 March 2022 08:56

mirek
Messages: 13975
Registered: November 2005

Ultimate Member

upptst/SQL_Name

TABLE_(SIMPLE_TEST1) SQL_NAME("TEST")
   INT_     (ID) PRIMARY_KEY
   STRING_  (NAME, 200) SQL_NAME("NAME2")
   STRING_  (LASTNAME, 200)
   INT_     (BDATE)
END_TABLE

SQL_NAME sets the name to be used with SQL while "normal" IDs are still used in C++.

Mirek

Report message to a moderator

Re: SQLEX. Is it possible to specify a different name for a real column? [message #58161 is a reply to message #58142]

Sat, 05 March 2022 16:46

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

Contributor

Thanks.

Super cool!

It's in last release?

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

Report message to a moderator

Previous Topic:	Connection to the postgres db over ssh tunnel
Next Topic:	SQL EXPR NOT WORKING

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Apr 20 14:13:01 CEST 2024

Total time taken to generate the page: 0.03759 seconds