OK... now... you can write every one of the routines to make every one of the steps needed. As you can think on the way to make every check, you can write a routine that do it every check. As you can think on the way to make every change, you can write a routine that do every change.

So... is not that hard and once you have it writen you can:
 a) Keep it and use it on every program you like
 b) Share it with the world.

The opensource planet is not only to go and ask, is also to go and give but the most important thing is that you can go and think by yourself.

I can´t call me a programmer if i'm not minded to write at least 1 routine by myself. If i don't do it, i'm only a puzzle assembler, where i'm always asking others for pieces to complete my own endless puzzle.

I'm sorry if this makes anyone bother or get angry, but is what i'm seing.
You can't just go and ask for everything you "don't want/like to do".
You can ask for something you don't know or you don't figure... but if you know and/or you can figure, you can do it.

Come on people, bring back to life the real programmers or go sell hot dogs.

The "thing" you are asking is that someone else writes what you need because you dont want to do it, and it will end by having a .prg writen by someone just because someone else didn't want to do it and asked for it.

And i say a .prg because you can do that with 100% dbase code.... yes, dbase, not even 1 "new" function is needed.



Lucas De Beltrán escribió:
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 <[email protected]>

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
<[email protected]>...
 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
<[email protected]>:
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
<[email protected]>...
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 <[email protected]>


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)
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour-users


________________________________________________
Szekely Andras <> [email protected] <>
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)
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour-users


_______________________________________________
Harbour-users mailing list (attachment size limit: 40KB)
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour-users



_______________________________________________
Harbour-users mailing list (attachment size limit: 40KB)
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour-users


--
Massimo Belgrano



_______________________________________________
Harbour-users mailing list (attachment size limit: 40KB)
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour-users

_______________________________________________
Harbour-users mailing list (attachment size limit: 40KB)
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour-users


_______________________________________________
Harbour-users mailing list (attachment size limit: 40KB)
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour-users

Reply via email to