Data dictionary error after removing table column

rbuser

Delphi 7; RB 10.4 pro; ASA 9.0; dbExpress

Dictionary had table of "tools" with a column "pix" blob field. Worked
fine. I removed the blob field from the table and moved it to another table,
added that second table to the dictionary and that worked fine. Now, even
though I removed the original blob field from the original table, I get
errors in the data wizard and in trying to sync the data dictionary (SQL
error) saying it can't find field "pix" in the tool table. I've looked at
rb_fields and that row isn't there. I replace the column "pix" and all is
ok again.

Can you help me find out why RB is still looking for that field even though
it has been removed from the list?

Thanks,
--
Bill Skelton

Landmark Data Systems, Inc.
Two Old River Place, Suite L
Jackson, MS 39202-3435
601-362-0303

nardmoseley

If you have existing querys that use the Pix field and you try to edit them
after removing it from the DataDictionary, then that could cause that issue.

Try shutting down ReportBulider and Delphi and restarting. RB caches the
meta data info.


--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

No joy. I even deleted the only report that I had created (which did have
pix in its field list) but still get the same results.

nardmoseley

Try adding RBuilder\Source to your library path and rebuild your project.
When the error occurs examine the call stack and perhaps that will provide a
clue.

--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Still not working. I'm getting an ASA ODBC SQL error. There is some code
somewhere trying to read that column in the DB. I even loaded RB10.08.

I hate putting a band-aid on it, but I guess I'll just put a dummy column in
the DB and move forward.