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

[Antonio Martinez]

7th. previous test for neccessary or not to update dbf (looking at
structures)


Antonio Martinez escribió en mensaje ...
>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-JsoAwUIsXosN+BqQ9rBEUg at public.
gmane.org>...
>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/>
>>>>
>>>> _______________________________________________
>>>> 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