Skip to Content
0
Former Member
Mar 03, 2009 at 10:50 PM

Linking command to table?

23 Views

I have created a simple command that selects data from a table, and using the Database Expert have linked it to another table in the DB. Now, when I try to run the report, CR stops responding.

Here is my command:

select ItemCode, U_R30, U_R60, U_R90, U_R180, U_RLTD from OITW

where WhsCode = '01'

In the Links window, I've linked Command to the table OITM via ItemCode. So this should pick the data from OITM that matches my parameters, and from Command that matches the ItemCode in OITM, right? But when I test the report, CR freezes up. No error message, nothing, it just stops responding. Clearly I'm doing it wrong - what's the correct procedure?

Thanks.