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.
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. 2 weeks ago
  2. Report Editor
  3. # 1
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. 2 weeks 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.

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