Hello Jason

I have recently (over the weekend) upgraded my IBO to 4.8.7. Things got
vastly improved, see the content of the ClientSchemaVer.IBO file (all
records in schema table have version numer set to 5):

Computed=5
Defaults=5
ForeignKeys=5
IndexDefs=3
PrimaryKeys=5
ProcedureNames=5
TableFields=4
TableKeys=5
TableNames=5
ViewNames=5

The only thing I worry about is 'IndexDefs' and 'TableFields' items. There
can be two things: first is some bug hanging around and the second - IBO is
so smart that cannot be cheated by values from schema table (I update all
records on IBO$... table after doing some metadata changes - it's simply
easier for me). If latter - hats of the heads and respect to the author ;-)

I was thinking about your request for sample application... What should be
more in that than simple IB_Connection, IB_Transaction and any database with
IBO$Schema_Version table. If there is really something I forgot to mention,
let me know - I will prepare the application for you...

Thanks
Marcin

PS. Any timetable for next versions?

----- Original Message -----
From: "Jason Wharton" <supportlist@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, November 20, 2007 2:00 AM
Subject: RE: [IBO] SchemaCache and invalidating local files


> Marcin,
>
>> 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?
>
> At this point a sample app is going to be the most help.
>
> 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.16.1/1140 - Release Date:
> 2007-11-19 19:05
>
>