1. Jak Woj
  2. Report Editor
  3. Samstag, April 24 2021, 04:39 PM
  4.  Abonnieren via E-Mail
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
Anhänge
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello Jak,

Please check the static analyzer option in the preferences, is it enabled?
Preferences->Application->SQL Editing->Static Analyzer->Enable static analyzer
Anhänge
Kommentar
There are no comments made yet.
Jak Woj Akzeptierte Antwort
it was checked,
now i've unchecked it and aliases work!
thank you
Kommentar
There are no comments made yet.
  • Seite :
  • 1


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

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories