Subject Re: [IBO] SchemaCache and invalidating local files
Author Marcin Bury
Hello Jason

I have made following test:
- I have deleted all *.IBO files along with their directory
- after running the application all files where created

This is the content of ClientSchemaVer.IBO file:


- then I have updated VERSION_NUMBER column to value 4 manually and run
application again - the content of ClientSchemaVer.IBO file didn't change.

I use following code in my application:

DB_U.SchemaCacheDir := ExtractFilePath(Application.ExeName);

where DB_U is TIB_Connection component.

The enviroment is D2007 with IBO 4.7.16.

Is there something I can do to help you trace the problem?


----- Original Message -----
From: "Jason Wharton" <supportlist@...>
To: <>
Sent: Thursday, November 15, 2007 5:38 AM
Subject: RE: [IBO] SchemaCache and invalidating local files

>> I'd like to use connection schema cache and it's local files.
>> My database
>> has proper table (IBO$SCHEMA_VERSION) and when application is
>> run for the
>> first time, local files are created.
>> But when I update VERSION_NUMBER column after some metadata
>> modifications
>> I'd like to have the local files updated automatically after
>> connecting to
>> the database. How can I achive that.
> That should happen automatically.
> If the table is there then it will store the last value in the local file
> and compare it and automatically refresh it.
> Please let me know if that isn't actually happening.
> Thanks,
> Jason
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.503 / Virus Database: 269.15.31/1129 - Release Date:
> 2007-11-13 21:22