Re: changing field's length?

jfreeman@xxxxxxxxx wrote:
Hi Lee,

Thanks for your response.

Basically we don't OWN foxpro per se. I am trying to find a 3rd-party
application to use to make changes to my .dbf files.

Sage's AbraSuite has licensed foxpro and use it as the data repository
for their HR application.

I can see clearly, using a couple of trial versions of various 3rd
party dbf manipulation applications, that the field width is set to 25
.... I don't seem to have a mechanism by which I can change it... I know
we'd have to also make changes at the reporting tool layer as well..
but the first step, I think, is to figure out how to expand this
field's character width at the database layer...

in a perfect world, we'd figure out how to expand it at the database
layer, then the application layer (where the data is
added/modified/deleted) and then the reporting layer...

We'll keep plugging... we're a non-profit with charity licensing for
all of our MS products so if you can hook me up with an up-to-date
version of foxpro that'd be great..

Cheers,

joshua


You can run any VFP command at runtime, If you want it I (or we) can send you a compiled app to acomplish this (do an ALTER TABLE ), in the case of modify an character field to 308 chars is not possible, just changing his data type to Memo.

--

¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º

Espartaco Palma Martínez
SysOp http://www.PortalFox.com
México D.F.
MoBlogs!
http://weblogs.golemproject.com/esparta/ <- Tech
http://www.espartha.com/blog/ <- Personal
VFP Bookmarks http://del.icio.us/esparta/vfp
.

Relevant Pages

  • Re: changing fields length?
    ... Basically we don't OWN foxpro per se. ... application to use to make changes to my .dbf files. ... we'd have to also make changes at the reporting tool layer as well.. ... field's character width at the database layer... ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Cannot set CDX index on DBF file from C#
    ... > I am using .NET framework 2.0 to open Foxpro DBF files. ... > the connection / command process, none of the actual indexes ... > within the CDX file are being selected, so when I run a select SQL ... the FoxPro Index command requires exclusive use of the ...
    (microsoft.public.fox.helpwanted)
  • Re: changing fields length?
    ... I would be VERY wary of changing data structures for a software package. ... Basically we don't OWN foxpro per se. ... know we'd have to also make changes at the reporting tool layer as ... this field's character width at the database layer... ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Import DBF files with MEMO fields
    ... FoxPro and Visual FoxPro ODBC drivers work with all versions of FoxPro ... The DBF files are created by Foxpro 2.6 for Dos. ...
    (microsoft.public.access.externaldata)
  • Re: Connect to Foxpro Data (*.DBF) in VB.Net
    ... be sure you have the latest FoxPro and Visual FoxPro OLE DB ... data provider, available from msdn.microsoft.com/vfoxpro/downloads/updates. ... Does Object support DBF Files? ...
    (microsoft.public.dotnet.framework.adonet)