 |
SoftTree Technologies
Technical Support Forums
|
|
| Author |
Message |
judahr
Joined: 09 Mar 2007
Posts: 319
Country: United States |
|
 Bug: $OBJECT(ins_qualname)$ returns table.table |
 |
v6.3.139
Code snippet starts with this:
$OBJECT(ins_nothing, column)$
Later, I reference what I would think would be schema.table or database.schema.table as this:
$OBJECT(ins_qualname)$
I get:
table.table
|
|
| Fri Oct 12, 2012 12:57 pm |
  |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7847
|
|
| |
|
If I get it correctly, you want to use the second macro to get a fully qualified database object name?
That type of qualification depends on the "Fully Qualify Object Name" settings. If is is not set to Always Qualify with Database and Schema Name, then only schema.table is inserted. There could be also other dependencies on other settings, which is a bit confusing.
To make it work independent from the settings, you can use
$OBJECT(ins_db)$.$OBJECT(ins_schema)$.$OBJECT$
|
|
| Fri Oct 12, 2012 1:36 pm |
|
|
judahr
Joined: 09 Mar 2007
Posts: 319
Country: United States |
|
| |
|
I would like it to say schema.table. My "Always fully..." is set to "With schema name". I've used a workaround for now. It just seems like $OBJECT(ins_qualname)$ should not output table.table
|
|
| Fri Oct 12, 2012 1:39 pm |
|
|
judahr
Joined: 09 Mar 2007
Posts: 319
Country: United States |
|
| |
|
As of .171 this is still an issue.
|
|
| Fri Feb 01, 2013 5:37 pm |
|
|
judahr
Joined: 09 Mar 2007
Posts: 319
Country: United States |
|
| |
|
The workaround does not work if the selected object is a column. I can't seem to workaround for this case.
|
|
| Thu Feb 07, 2013 6:07 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7847
|
|
| |
|
I have raised it again. there is still a ticket in our system for $OBJECT(ins_qualname)$
|
|
| Fri Feb 08, 2013 12:08 am |
|
|
gemisigo
Joined: 11 Mar 2010
Posts: 2108
|
|
| |
|
Hi!
Any progress on this issue?
|
|
| Wed Apr 24, 2013 6:45 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7847
|
|
| |
|
Yes, it is marked as fixed in build 6.3.182, ticket #SA0019807. This is an internal build not available to end-users yet. We are developing several new features and at the moment there is no stable build I can offer to you. Please hold on a little longer.
|
|
| Wed Apr 24, 2013 7:12 am |
|
|
gemisigo
Joined: 11 Mar 2010
Posts: 2108
|
|
| |
|
Splendid, thanks :)
|
|
| Wed Apr 24, 2013 7:46 am |
|
|
gemisigo
Joined: 11 Mar 2010
Posts: 2108
|
|
| |
|
Works in 6.4.199 preview
|
|
| Wed May 22, 2013 3:47 am |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
