Home > Archive > Clarion > March 2004 > Need help with 2 tables (Relational )
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Need help with 2 tables (Relational )
|
|
| Charlie Parvin 2004-03-26, 11:01 pm |
| I have a program that imports information from another database. Here
is the problem.
Table 1 I have a field called Sys_Id. Autonumber Key
Table 2, I have a field called Something_ID
When I import into table 1 (Sys_ID) I need to also have table 2
(Something_ID)populated with the same info and have a relations ship
with both tables. In the Clarion examples it maual entry works fine
and I understand that. But when importing info from another database,
I dont get the same results.
Any help would be appreciated.
Charlie
| |
| Arnett, James 2004-03-26, 11:01 pm |
| Hi Charlie,
After importing both databases into two tables, you could write a
batching process to loop through each entry of the first table with an
inner loop (or a single Get) of your second table with boolean search
criteria to match the first, pass your variables from first to second,
then write the results to disk before moving on to the next entry of
the first table. This is the idea you can apply to Legacy or ABC:
LOOP ! table 1
LOOP ! table 2
IF table 2 = table 1 boolean criteria
table2.field = table1.field
PUT table 2 ! write to table 2
CYCLE ! move on to next table 1 record
ELSE
! keep searching
END ! end of criteria
END ! end of inner loop
END ! end of loop
cparvin@parvin.phxcoxmail.com (Charlie Parvin) wrote in message news:<9ed5bf67.0403200112.49979f87@posting.google.com>...
> I have a program that imports information from another database. Here
> is the problem.
>
> Table 1 I have a field called Sys_Id. Autonumber Key
>
> Table 2, I have a field called Something_ID
>
> When I import into table 1 (Sys_ID) I need to also have table 2
> (Something_ID)populated with the same info and have a relations ship
> with both tables. In the Clarion examples it maual entry works fine
> and I understand that. But when importing info from another database,
> I dont get the same results.
>
> Any help would be appreciated.
>
> Charlie
|
|
|
|
|