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:

Computed=3
Defaults=3
ForeignKeys=3
IndexDefs=3
PrimaryKeys=3
ProcedureNames=3
TableFields=3
TableKeys=3

- 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);
DB_U.Connect;
DB_U.SchemaCache.CheckSchemaVersionTable;

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?

Regards
Marcin

----- Original Message -----
From: "Jason Wharton" <supportlist@...>
To: <IBObjects@yahoogroups.com>
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.
> ___________________________________________________________________________
> http://www.ibobjects.com - 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
>