Hello Jason,

> What I saw in the header where the SQLPrecision item was it said "for

future

> use" and so I have not paid specific attention to it in IBO.
>
> We use IB 7.1 and IB 7.5 in our production apps and have not had any
> problems but I also have not had any specific need to get the precision of
> any of our columns. For the time being, IBO has simply relied upon

certain

> assumptions based on the general data type of the column, where I presume
> this will give the exact precision specified. The data is probably there
> and has been all the time, I just didn't label it right or do anything to
> make use of it if that "future" time is now.
>
> I'll look at this more closely and see if I can take advantage of this
> better.

From what I can see, you had no chance of putting in sqlprec yet?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

> Regards,
> Jason
>
> > -----Original Message-----
> > From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> > Behalf Of Martijn Tonies
> > Sent: Friday, November 24, 2006 3:24 AM
> > To: ibobjects@yahoogroups.com
> > Subject: [IBO] XSQLVAR & Precision
> >
> >
> > Hello Jason,
> >
> > According to the IB documentation, from v6 and onwards, XSQLVAR
> > should include a field "sqlprecision", I cannot find this in IBO.
> >
> > Could you include this so we can get the Precision for
> > NUMERIC columns?
> >
> > Leave it empty (or -1?) for pre v6 / pre Firebird?
> >
> > Martijn Tonies
> > Database Workbench - tool for InterBase, Firebird, MySQL,
> > NexusDB, Oracle &
> > MS SQL Server
> > Upscene Productions
> > http://www.upscene.com
> > My thoughts:
> > http://blog.upscene.com/martijn/
> > Database development questions? Check the forum!
> > http://www.databasedevelopmentforum.com
>
>
>
>

___________________________________________________________________________

> 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
>
>
>
>
>