Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » SQLEX. Is it possible to specify a different name for a real column?
SQLEX. Is it possible to specify a different name for a real column? [message #58048] Fri, 28 January 2022 13:52 Go to next message
sergeynikitin is currently offline  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 Go to previous messageGo to next message
mirek is currently offline  mirek
Messages: 13984
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
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 Go to previous message
sergeynikitin is currently offline  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 );
}
Previous Topic: Connection to the postgres db over ssh tunnel
Next Topic: SQL EXPR NOT WORKING
Goto Forum:
  


Current Time: Sat Jun 15 04:34:47 CEST 2024

Total time taken to generate the page: 0.02156 seconds