Another item that came up and again before I enter an issue thought
I would see if someone knows if it is already there.
I created a little demo database and kind of mini tutorial on the OOOForum
board this weekend. I was answering a question about creating what I call
a tickler function using Base. In showing the example I created 2 views,
one uses a max function on a date field and group by clause. This gets the
last date a contact was contacted. The second view uses this first view and
joins back to a customer table.
Finally I create a query that addes a where clause and gets the result
set that
was requested,. Any way i was kind of proud of the whole thing and
posted the
database up for download. Next morning thought I would double check the work
and grabbed the database as a download and opened it...failed to connect.
The same for my original on my local disk.
Turns out that Base had not quoted the name of the aliased column that I
created
using the max funtion in the first view. This didn't seem to bother the
engine while it
was running, but when it went to startup again and was reading the
script file this caused
a column not found error.
The exact details of what I did - screen shots and all - can be seen at
http://www.oooforum.org/forum/viewtopic.phtml?t=24480
I can attach a copy of the corrupted database to an issue. Question is
should I limit
to just this scenario or make it broader. For example I have found 2 or
3 ways to make
this type of thing happen.
Thanks
Andrew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
