Hi guys, i think DP have expertise on Filemaker so here it goes: We are running 4 travel related websites with filemaker advanced server 7 backend via ODBC driver. websites are .net 2.0. We are having 2 problems when using ODBC driver. 1st: is there anyway to limit results? doing a top 10 (sqlserver like) or limit 0,10 (mysql like). 2nd: if i have 2 related files, A and B and i have a calculation text on file A, that refers a related field of B, it will show up on Filemaker 7 client, but it's empty if I make query via ODBC. any way to round that? Example: Table User, File A iduser name Table Order, File B idorder iduser name = text calculation by related record iduser, of A.name if I have 1 connection via ODBC to file A and i make select name from Order, i will get empty field. Best regards.
I don't use fm unless I absolutely have to. I found this info http://fmforums.com/forum/showtopic.php?tid/182180/ that might help. If it doesn't, you could do the limiting in the code as opposed to the query. What language are you using for the sites? It's very easy to do in VB.Net. It is not the best way to do it, but I am guessing by the fact that you're using fm that your sites are not that large (so there should not be a noticable difference). On your second question, do you have a sample of the query? Also, have you had your pages print out the query to know that it is the same?