incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 118575] OOo Base will not reopen a database after I have created a new Query in it.
Date Tue, 08 Nov 2011 12:11:45 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=118575

--- Comment #5 from Bill Barker <aalhaulagejersey@hotmail.com> 2011-11-08 12:11:45 UTC
---
Understood. Oddly, whilst I was getting things ready to send to you I
discovered that if I copy the "populated" database (which no longer has the
query in it) and strip all data and then write the query again the "empty"
database opens OK. I will do a bit of testing on the "empty" and the
"populated" databases with the query in question(and maybe other new ones too). 

Query script is simple: -


SELECT "Assets"."AssetID" AS "AssetID", "Assets"."Category" AS "Category",
"Assets"."Make" AS "Make", "Assets"."Model" AS "Model",
"Assets"."RegistrationNumber" AS "RegistrationNumber", "Assets"."CurrentAsset?"
AS "CurrentAsset?" FROM "Assets" "Assets" WHERE ( "Assets"."CurrentAsset?" = 1
) ORDER BY "Assets"."RegistrationNumber"

-- 
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.

Mime
View raw message