- Code: Select all
CREATE VIEW [vwGroupBibs] AS
WITH RECURSIVE
[tab] AS(
SELECT [BibFrom],
[BibTo],
[idGroup]
FROM [GroupBibs]
UNION ALL
SELECT [BibFrom] + 1,
[BibTo],
[idGroup]
FROM [tab]
WHERE [BibFrom] < [BibTo]
)
SELECT DISTINCT [idGroup] AS [idGroup],
[BibFrom] AS [BibNumber]
FROM [tab];
When I try to import the schema of the DB containing this view, the action is quitted with the following error message (attachment). If I drop the view, everything is fine. I use QxEntityEditor release 1.1.9.