Documentation is not updated for SQLite database

[Geert Bellekens]

In the documentation the fact that SQLite is now also an option as database is not reflected.
There are a few places where this is missing. One of them is: https://sparxsystems.com/enterprise_architect_user_guide/16.0/the_application_desktop/creating_filters.html

Reported

Geert

[Geert Bellekens]

Does anyone know what I should put for SQLite as dbName between the #DB=<dbName>#?
I tried SL3 and SQLite, but neither seems to work.

Geert

[wivel]

Or it could be that Sparx have forgotten to add it to the list of databases.

Henrik

[qwerty]

I was about to say that an hour ago xD

q.

[Geert Bellekens]

For those interested, the DB name for SQLite is SL3

So if you want to make a query with a specific part for SQLite you'll need to use #DB=SL3#

This is what it looks like in an SQL fragment. this fragment works for both SQL Server as SQLite.
For SQL Server I need [Description-Formatted] whereas the SQLite syntax requires `Description-Formatted`

Code: [Select]

select a.Name as AttributeName, a.Type as Format, a.LowerBound, a.UpperBound
, tvacc.VALUE as Accuracy, tvcri.VALUE as Critical, tvdtk.VALUE as DataKind, tvgdpr.VALUE as GDPR, tvinte.VALUE as Intern_Extern, tvqp.VALUE as QualityPeriodicity
, tvra.VALUE as RisAppetite, tvrc.VALUE as RiskClassification, tvsui.VALUE as Suitability
, tvts.VALUE as Timesliced
, a.Notes as #DB=SL3#`#DB=SL3##DB=SQLSVR#[#DB=SQLSVR#Description-Formatted#DB=SL3#`#DB=SL3##DB=SQLSVR#]#DB=SQLSVR#
 from t_attribute a
left join t_attributetag tvacc on tvacc.ElementID = a.ID
and tvacc.Property = 'Accuracy'
left join t_attributetag tvcri on tvcri.ElementID = a.ID
and tvcri.Property = 'Critical'
left join t_attributetag tvdtk on tvdtk.ElementID = a.ID
and tvdtk.Property = 'DataKind'
left join t_attributetag tvgdpr on tvgdpr.ElementID = a.ID
and tvgdpr.Property = 'GDPR'
left join t_attributetag tvinte on tvinte.ElementID = a.ID
and tvinte.Property = 'Intern_Extern'
left join t_attributetag tvqp on tvqp.ElementID = a.ID
and tvqp.Property = 'Quality Periodicity'
left join t_attributetag tvra on tvra.ElementID = a.ID
and tvra.Property = 'Risk Appetite'
left join t_attributetag tvrc on tvrc.ElementID = a.ID
and tvrc.Property = 'Risk Classification'
left join t_attributetag tvsui on tvsui.ElementID = a.ID
and tvsui.Property = 'Suitability'
left join t_attributetag tvts on tvts.ElementID = a.ID
and tvts.Property = 'Timesliced'
where a.Object_ID = #OBJECTID#
order by a.Pos, a.Name
Geert