1. Jak Woj
  2. Report Editor
  3. Saturday, April 24 2021, 04:39 PM
  4.  Subscribe via email
Hello,

I’ve encoutnered a problem while using Valentina-DB.

Context: MS SQL Server – T-SQL

Let’s go with something simple:

In SSMS I can use aliases as columns i.e. in “JOIN” statements, example:

select
pp.PersonType,
pbe.ModifiedDate
from Person.Person as pp
join Person.BusinessEntity as pbe
on pp.BusinessEntityID = pbe.BusinessEntityID


Valentina-DB Studio Pro 11.2.4 on macOS 10.15

select
*
from Person.Person as pp
join Person.BusinessEntity as pbe
on pp.BusinessEntity.ID = pbe.BusinessEntityID

returns error,
moreover autocompletion does not work with aliases


I don’t know if it’s a lack of a feature or I have to enable option that I haven’t found yet.

j
Attachments (2)
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Jak,

Please check the static analyzer option in the preferences, is it enabled?
Preferences->Application->SQL Editing->Static Analyzer->Enable static analyzer
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 1
Jak Woj Accepted Answer
it was checked,
now i've unchecked it and aliases work!
thank you
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.