Logo SQLinForm

 

[solvedthumbs up] Simple Object extensions

I use an SQL variant with a simple object extension, arrow reference syntax, e.g.:

select a->b->c
from etc.

does what it suggests assuming "a" and "b" are object reference columns. The formatter behaves not very nicely for this commonly used feature of our sql variant. Any chance you can support "->" as a token, to be handled similarly to "." as a name separator? I doubt it would harm any other sql variant.



Edited 1 time(s). Last edit at 12/27/2010 01:08PM by guidomarcel.
Re: Simple Object extensions
April 18, 2010 09:52PM
Hi sql_user,
many thanks for your feedback. I will add your suggestion to my todo list. Which SQL dialect are you working with?
Regards
Guido
sql_user
Re: Simple Object extensions
April 20, 2010 09:26PM
The variant is InterSystems CacheSQL. It's other differences from or enhancements to, standard sql, follow common patterns and are handled just fine by the 'any sql' formatting option.
Re: Simple Object extensions
August 04, 2010 08:10PM
As an employee of InterSystems I second this! :-)

We love your tool (just bought a site license), this is the only issue I've noticed.
Re: Simple Object extensions
August 04, 2010 09:20PM
Hi, thanks for reminding me this suggestion. I will have think about this.
Regards
Guido
Re: Simple Object extensions
August 05, 2010 01:06AM
Hi,
could you please send me a few examples so that I can test my changes?

Regards
Guido
Re: Simple Object extensions
December 27, 2010 01:08PM
Hi,
feature is now available
Regards
Guido
Author:

Your Email (Optional):


Subject:


Spam prevention:
Please, solve the mathematical question and enter the answer in the input field below. This is for blocking bots that try to post this form automatically.
Question: how much is 3 plus 18?
Message: