Jason,

Thanks for the reply - I'm sure using a keyboard is the last thing
you want to be doing right now!

I have a program (called 'DBProducer') which connects to our company
database and allows SQL scripts to be run against it to extract data
into DBF files. These files are then accessed through Lotus Approach
to allow rapid generation of reports, which are then used as
prototypes and recoded into our business software.

I can send you the source for DBProducer and we can talk it through -
where should I send it to? This list or your private email?

I've altered DBProducer to work with Mike Skolnik's SMExport at the
moment - it doesn't work fully either! I can alter it back to using
the original IBO components, so I can have it ready for early next
week.

Thanks again for the response, and hope you have a quick recovery,

Gary.




--- In IBObjects@yahoogroups.com, "Jason Wharton" <supportlist@...>
wrote:

>
> Gary,
>
> Apologies for my delay.
>
> Let's take this up in a private exchange to work through this issue.
>
> Please send me what I need to get in the driver's seat to resolve

this.

>
> (I'm a very slow typist lately because my left middle finger

received a

> scorpion sting yesterday and its is really messed up.)
>
> Thanks,
> Jason
>
> > -----Original Message-----
> > From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]

On

> > Behalf Of bamber12001
> > Sent: Thursday, April 19, 2007 3:31 AM
> > To: IBObjects@yahoogroups.com
> > Subject: [IBO] Re: Exporting large text fields to a DBF file...
> >
> >
> > --- In IBObjects@yahoogroups.com, "bamber12001" <Gary@> wrote:
> > >
> > > Hi all,
> > >
> > > IB_Export doesn't export fields with more than 254 characters

to a

> > > DBF file properly, unfortunately - it would have to create them

as

> > > MEMO fields (and also create the DBT file that they are stored

in).

> > >
> > > To try to overcome this limitation, I have installed SMExport

from

> > > Scalabium software. This gave me further problems with rounding

of

> > > floating point numbers, among other things. I was unable to

resolve

> > > my problems with this, and my SMExport license has since run

out.

> > >
> > > I have two choices:
> > >
> > > ) Use another component suite to export to DBF files. I cannot

find

> > > any that are compatible with IBO. Does such a thing exist?
> > >
> > > ) Request that the facility is added to the existing IB_Export
> > > component in IBO - would this be a possibility?
> > >
> > > Thanks,
> > >
> > > Gary McLagan.
> > >
> >
> > I don't want to look impatient, but has anyone got any thoughts

on my

> > problem? My favoured solution would be for IBObjects to be

altered to

> > export large text fields properly, so if you read this Jason,

could

> > you comment on whether this is likely to be implemented or not so

I

> > know whether to wait for an update or try and hunt down an

alternative

> >
> > Thanks!
> >
> > Gary.
>