[ZS1] Re: [mapguide-users] [ZS1] Re: MS SQL and SDF Join Problem

[Kenneth Skovhede, GEOGRAF A/S]

I have not gotten it to work with anything but integers.
Can you add another column with sequential integers to both data sources?

Regards, Kenneth Skovhede, GEOGRAF A/S



anakando skrev:
> Thanks for suggestion. I afraid i cannot change id data type to integer since
> it contains both of integer and char such as 'FLAG 010'..i just wondering if
> this is related to the space between 'FLAG' and '010'??
>
>
>
> Try linking the tables with integer columns, that is usually the only 
> stable solution.
>
> Regards, Kenneth Skovhede, GEOGRAF A/S
>
>
>
> anakando skrev:
>   
>> Yes..my MG version is 2.0.1..Here is my situation. I have database that
>> contain 2 tables (as example). Both of tables are linked to SDF file
>>