access Accessfile from Delphi
Posted on 1998-05-19
Accessing Access from Delphi 3
I have two Access db files called
- ONE with string/text fields ONEfieldA and ONEreplace
- TWO with string/text fields TWOreplace and TWOvalue.
I have one string in Delphi called DEFAULT
For some stupid reason I want Delphi to read these values in two string arrays TEST1 and TEST2.
such that for all records y in ONE:
- TEST1[y] = value of ONEFieldA
- if there is NO record in TWO where the value TWOreplace is the value of ONEreplace
TEST2[y].FIELD2 = DEFAULT
if there is a record in TWO where the value in TWOreplace is the
value of ONEreplace then
TEST2[y].FIELD2 = TWOvalue (the value of the first record which match the
1 FIRST testa
2 SECOND testb
TWO TWOreplace TWOvalue
1 testa FIRSTVALUE
2 testc SECONDVALUE
TEST1 = FIRST
TEST2 = FIRSTVALUE
TEST2 = SECOND
TEST2 = DEFAULT
Hope this is clear enough.
BTW: If I need to install/configure some times to
be able to access Access MDB's from Delphi: please give
the needed instruction.