J
Jef Eekhoorn
If someone knows a link to a good url, it will be fine to start
= = = =
Today I still use dbase4,
but I know Excel, Access as user
Delphi as programmer
I have to start to stop using dbaseIV and do Access
ONLY if i have NOT to
open 10-windows
click 100 mouse-buttons
unchek or check 1000 check-boxes
for changing and starting one makro
= = = = dbase IV / dbase4
* updatb.prg
The contence of one field of table FILEA.DBF is transfered to FILEB.DBF.
select 1
use FILEA.DBF ALIAS FILE1 in 1
select 2
use FILEB.DBF ALIAS FILE2 in 2 order &FIELD1
FIELD1 = 'NAME'
FIELD2 = 'PHONE'
* field ZZ [char 1] only to mark end check records that are updated
update on &FIELD1 From File1 REPLACE &FIELD2 WITH File1->&FIELD2, ZZ with
'*' RANDOM
* end
The match is unique, so FIELD1 should be unique in both files.
= = =
I have another dbase program to do the same but without a strict relation :
more than one record in FILEA can be related with one source record in FILEB
Ind I have tons of little dbase programs
= = =
Now what's my point and question :
My dbase4 is still running fine in my DOS-box on Windows XP home.
My simple dbase4 programs does in 10 sec an update of 100000 records.
( of course if the record length is small )
With a few simple commands ( like dos prompt commands ) I do my job .
..do updatb
..browse
.. < i do control, filter >
..list history to whatdone.prg
If I did a mistake, I can edit my whatdone.prg ( text ) and run it again and
again and
again.
Then I make a report in Excel which reads dbase4-tables just by clicking
them
in the windows explorer.
But I have to start to think to do the same in Access
because I have to learn my collegues to do the same,
and DBASE4 is outdated ( I agree )
( repeat of top )
ONLY if i have NOT to
open 10-windows
click 100 mouse-buttons
unchek or check 1000 check-boxes
for changing and starting one makro
while my old dbase4-methode
can do all in 10 seconds typing a few keys.
It must ! be easy to reuse old makro's or vba-applications on new databases.
If any knows what I mean,
and understands what I should learn or read
or what other windows program I should use ?
Maybe exist a simple way in Access ? i don't know.
Maybe working with mouses and visual relations isn't that bad.
My database tabels are for 90% throw-away-tables that only lives a few
hours.
I'm not using database to store data but to find discordances between
databases of
different applications and/or systems that should contain for some parts the
same information.
Maybe some guys do this in Excel, but that I only use to make reports,
not to change data and to screw up my databases.
Jef
Brussels Belgium
Even i could contact and pay a
person to give some 1-day course
to 3 persons
= = = =
Today I still use dbase4,
but I know Excel, Access as user
Delphi as programmer
I have to start to stop using dbaseIV and do Access
ONLY if i have NOT to
open 10-windows
click 100 mouse-buttons
unchek or check 1000 check-boxes
for changing and starting one makro
= = = = dbase IV / dbase4
* updatb.prg
The contence of one field of table FILEA.DBF is transfered to FILEB.DBF.
select 1
use FILEA.DBF ALIAS FILE1 in 1
select 2
use FILEB.DBF ALIAS FILE2 in 2 order &FIELD1
FIELD1 = 'NAME'
FIELD2 = 'PHONE'
* field ZZ [char 1] only to mark end check records that are updated
update on &FIELD1 From File1 REPLACE &FIELD2 WITH File1->&FIELD2, ZZ with
'*' RANDOM
* end
The match is unique, so FIELD1 should be unique in both files.
= = =
I have another dbase program to do the same but without a strict relation :
more than one record in FILEA can be related with one source record in FILEB
Ind I have tons of little dbase programs
= = =
Now what's my point and question :
My dbase4 is still running fine in my DOS-box on Windows XP home.
My simple dbase4 programs does in 10 sec an update of 100000 records.
( of course if the record length is small )
With a few simple commands ( like dos prompt commands ) I do my job .
..do updatb
..browse
.. < i do control, filter >
..list history to whatdone.prg
If I did a mistake, I can edit my whatdone.prg ( text ) and run it again and
again and
again.
Then I make a report in Excel which reads dbase4-tables just by clicking
them
in the windows explorer.
But I have to start to think to do the same in Access
because I have to learn my collegues to do the same,
and DBASE4 is outdated ( I agree )
( repeat of top )
ONLY if i have NOT to
open 10-windows
click 100 mouse-buttons
unchek or check 1000 check-boxes
for changing and starting one makro
while my old dbase4-methode
can do all in 10 seconds typing a few keys.
It must ! be easy to reuse old makro's or vba-applications on new databases.
If any knows what I mean,
and understands what I should learn or read
or what other windows program I should use ?
Maybe exist a simple way in Access ? i don't know.
Maybe working with mouses and visual relations isn't that bad.
My database tabels are for 90% throw-away-tables that only lives a few
hours.
I'm not using database to store data but to find discordances between
databases of
different applications and/or systems that should contain for some parts the
same information.
Maybe some guys do this in Excel, but that I only use to make reports,
not to change data and to screw up my databases.
Jef
Brussels Belgium
Even i could contact and pay a
person to give some 1-day course
to 3 persons