Trying to extract my "codes" from our database. We have a structure where "codes" are columns in each table and inserted as GUIDs. E.g. I have a table called Activity that contains the code ActivityTypeCODE.To get the description of the code I have to perform a JOIN to another table called CodeDescription in which one key is CodeID i.e. the GUID from ActivityTypeCODE.
My problem is that on some machines the description of the code doesn't get extracted. When comparing the query from one working-machine to a non-working-machine I can see that different queries are sent to the SQL server. And the JOIN to the CodeDescription table is missing in the "non-working" machine's SQL query.
The tables like the Activity table described above contain several Codes, so if I want to extract all codes I have to perform a JOIN to the CodeDescription table for each code, meaning that I end up having a lot of aliases e.g. CodeDescription_1, CodeDescription_2 etc. I am running the run-time version of Crystal Reports 9 (the merge modules from 20/2 2004). The run time is delivered together with our CRM system and launched using a .dll through a button in the application.
Please advise!
My problem is that on some machines the description of the code doesn't get extracted. When comparing the query from one working-machine to a non-working-machine I can see that different queries are sent to the SQL server. And the JOIN to the CodeDescription table is missing in the "non-working" machine's SQL query.
The tables like the Activity table described above contain several Codes, so if I want to extract all codes I have to perform a JOIN to the CodeDescription table for each code, meaning that I end up having a lot of aliases e.g. CodeDescription_1, CodeDescription_2 etc. I am running the run-time version of Crystal Reports 9 (the merge modules from 20/2 2004). The run time is delivered together with our CRM system and launched using a .dll through a button in the application.
Please advise!