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 using
unique id,and both data type are set to 'varchar'. Out of my curiosity, only
1 table are successfull linked to sdf, but the other one are not. It only
show the first row of data.I am frustated
zspitzer wrote:
also which version are you running 2.0.1?
On Fri, Sep 12, 2008 at 2:54 PM, Jackie C. Ng
<[EMAIL PROTECTED]>wrote:
Are you joining on strings?
- Jackie
anakando wrote:
Hi guys..
I faced a very big problem (i guess) since i cannot overcome this
problem
for almost 2 weeks! Let me simplify my problem. I have successful makes
a
join between my sdf file and MS SQL, but the problem is,after
joining,it
only show only first row data form MS SQL. The type of join is inner
join,
and relationship with secondary records is one-to-one. But when i
change
type of join to left outer join, it will show all the data from MS SQL
but
with a 'null' value! I have do some research about this problem but i
can't find something useful for me. If somebody out there already
experienced and successful solved the problem, please let me know. TQ
-----
http://themapguyde.blogspot.com
http://www.linkedin.com/in/jackieng
--
View this message in context:
http://www.nabble.com/MS-SQL-and-SDF-Join-Problem-tp19448719p19449417.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
_______________________________________________
mapguide-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
--
Zac Spitzer -
http://zacster.blogspot.com (My Blog)
+61 405 847 168
_______________________________________________
mapguide-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
