[Harbour-users] Re: Re: function for update dbf structure

[Lucas De Beltrán]

I agree.

It is a very complex fuction.

First of all, the function should compare the exsisting structure with the
new one and peform the changes.

Next point, is data width checking.

Last point, inherint existing data and adapting them to the new structure.

We need a helping hand from the gurus!!!.


best regards,

2009/12/18 Antonio Martinez <alcisoft at arrakis.es>

> Massimo
> Imagine it:
>
> Scenario: Temp.Dbf     Struct is {{"NField", "N", 10, 0} } and 1000 records
>
>
> FUNCTION Main
> Local aNewStruct:= {{"NField", "N", 3, 0}}
>
>
> // This generates run time error data width error
> dbModStruct("Temp.Dbf", aNewStruct)
>
> RETURN NIL
>
>
>
>
> Massimo Belgrano escribió en mensaje
> <609353e70912171005qfc28389j7b013bd8151a8afa at mail.gmail.com>...
>  dbcreate(D_APP,ADBF) // Create nes dbf with new structure
> use
> use &(D_APP) alias APPOGGIO && open it
> append from &(D_FDBF)          // append data
> use
> Now rename
>
> 2009/12/17 Antonio Martinez
> <alcisoft at arrakis.es>:
> > Hi,
> >
> > You must write it dbmodify thinking on errors protection;
> > For example: Data width error, corruption detected, etc....
> >
> > Too possibillity to write init values for old records, etc...
> > Too renamed memo file .fpt (or .dbt) associated
> >
> > Really its a complex function !
> >
> > Function is dbModStruct(cFile, aNewStruct)
> >
> > Regards
> >
> >
> >
> >
> > Richard escribió en mensaje
> <4B2A323C.5040409 at adinet.com.uy>...
> > You can develop the new function by programming the necessary steps.
> >
> >
> > Lucas De Beltrán escribió:
> >> Hi,
> >>
> >> Thanks, but it will be more powerful a funcion dbmodify( newstruct ).
> >>
> >> regards,
> >>
> >> 2009/12/16 szekely <szekely3 at enternet.hu>
> >>
> >>
> >>> Hi !
> >>>
> >>> DBCREATE() ?
> >>>
> >>> Not too simple: you make a new table, from the old table copy the
> >>> records into the new, and after rename it to the old name.
> >>>
> >>> Andras
> >>>
> >>> On Wed, 16 Dec 2009 09:01:07 +0100, Lucas De Beltrán wrote:
> >>>
> >>>
> >>>> Hi,
> >>>>
> >>>> Is there a function in Harbour that updates a DBF structure?. For
> > example,
> >>>> updatedbf( dbffile, newstructure ).
> >>>>
> >>>> Thanks!!
> >>>> _______________________________________________
> >>>> Harbour-users mailing list (attachment size limit: 40KB)
> >>>> Harbour-users at harbour-project.org
> >>>> http://lists.harbour-project.org/mailman/listinfo/harbour-users
> >>>>
> >>>>
> >>> ________________________________________________
> >>> Szekely Andras <> szekely3 at enternet.hu <>
> > eCS 1.2 <>
> >>> http://www.scharenkreutzer.hu <>
> > http://2Mai.dyndns.org <http://2mai.dyndns.org/><http://2mai.dyndns.org/
> >
> >>>
> >>> _______________________________________________
> >>> Harbour-users mailing list (attachment size limit: 40KB)
> >>> Harbour-users at harbour-project.org
> >>> http://lists.harbour-project.org/mailman/listinfo/harbour-users
> >>>
> >>>
> >> _______________________________________________
> >> Harbour-users mailing list (attachment size limit: 40KB)
> >> Harbour-users at harbour-project.org
> >> http://lists.harbour-project.org/mailman/listinfo/harbour-users
> >>
> >>
> >
> >
> >
> > _______________________________________________
> > Harbour-users mailing list (attachment size limit: 40KB)
> > Harbour-users at harbour-project.org
> > http://lists.harbour-project.org/mailman/listinfo/harbour-users
> >
>
>
>
> --
> Massimo Belgrano
>
>
>
> _______________________________________________
> Harbour-users mailing list (attachment size limit: 40KB)
> Harbour-users at harbour-project.org
> http://lists.harbour-project.org/mailman/listinfo/harbour-users
>