Very Computer

my form ties a master table, unified.db to 7 other tables by the id#.  Thats
8 total tables.  I have created a report based on an answer table, and the
code follows:

        var
         q   query
           rpt Report
           num String

        endVar

        num=String(ID#)
        q=Query

        Query
        ANSWER: :WORK:answer.db

        unified.DB | ID#        | FullName | LName  | FName  | MI     |
Prefix | Suffix |
                   | Check ~num  | Check    | Check  | Check  | Check  |
Check  | Check  |

        unified.DB | Title  | Company | Address1 | City/State | Zip    |
Country |
                   | Check  | Check   | Check    | Check      | Check  |
Check   |

        unified.DB | PrimaryAgent | Phone  | Fax    | AltPhone |
ActiveClient? |
                   | Check        | Check  | Check  | Check    | Check
|

        unified.DB | IUQ?   | ActiveBusClient? | BusTaxID | DOB    | Smoker?
|
                   | Check  | Check            | Check    | Check  | Check
|

        unified.DB | MaritalStatus? | Sal    | Spouse | SS#    | SpouseSS# |
                   | Check          | Check  | Check  | Check  | Check     |

        unified.DB | SpouseDOB | SpouseOcc | SpBusPhone | Dependents |
DependentsSS# |
                   | Check     | Check     | Check      | Check      | Check
|

        unified.DB | DependentsDOB | AltContact | ReviewMonth | BadAddress?
|
                   | Check         | Check      | Check       | Check
|

        unified.DB | Selection | Notes  | ECName | Pol#   |
                   | Check     | Check  | Check  | Check  |

        EndQuery

        if not executeQBE(q) then
         errorShow("Could not execute Query")
           Return
        endif

        if not rpt.open("clientreport1.sl") then
         errorShow("Could not open report")
           return
        endif

        endMethod

I get an error message because it won't run the QBE because it says it's
expecting
| in the table header, but when I look, they are all there.  What gives?

The alternative method below using tcget, tcput:
the code is:

        var
         tcget,tcput   TCursor
         rprt     Report

        endVar

            if not tcget.attach(ID#) then
            errorShow()

           endif

           if not tcput.open("holdadd.db") then
            errorShow()

           endif

           if not tcput.isEmpty() then
            tcput.Empty()
           endif

           tcput.edit()
           tcput.insertRecord(tcget)
           tcput.postRecord()
           rprt.open("clientrecord1.rsl")

        endMethod

and when I try this, the info from the master table shows, but none of the
detail stuff in the detail tables at all, as they are all tied to the
unified table, not the holdadd.db table, or at least that is what I'm
thinking.

What am I doing wrong?

*ia:

Another thing I've found to be useful with this type of error is to
save the query that is formed and look at it in native paradox or, if
native paradox can't open it, open a text editor - like notepad - and
open it that way.  I was going crazy with that type of problem once
and found that I had used a "tab" rather than a "space" character in a
field name and it wasn't obvious within the code.  Anyway, to do this,
form your query but before the execute, add
"q.writeQBE("whatever.qbe")".

HTH.

Bob