General information
Category:
Coding, syntax & commands
>First, thanks (No alltrim! DUH!) But even though I removed the ALLTRIM()'s, I'm still getting all records in the child table.
>
>Second, I'm using IDX's cause legacy code is looking for IDX files.
>Bummer, but for now it'll work.
>
>Third, I have a typical one to many, and all fields from table1 and
>table2 need to become a record in table3. So the second SCAN scatters
>each record to a memvar:
>
>
>SELECT Table1
>SCAN
>
> ** Get's all of the first table's fields on the current record
> SCATTER MEMVAR
>
> ** Now loop through all child records and scatter each value to
> ** memvars
> SELECT Table2
> SCAN
> SCATTER MEMVAR
> ENDSCAN
>
>ENDSCAN
>
>** Table3 has only matching fields from tables 1 & 2 that I want
>INSERT INTO Table3 FROM MEMVAR
>
>
>See?
Don't you have to put SELECT Table1 between the two ENDSCANs?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only