This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hello! Lets say I have table with some places. Every place has FK to table with cities, cities has FK to country and country has FK to continents. What I want to do is retrieve some places based on continents. What is the best way to do this using Lightspeed? I was using something like this:
Query generated by Lightspeed was without any Where statement. When I've changed
to
Where has appeared in SQL generated by Lightspeed. Thanks |
|
|
Hello Webio, I've tried to reproduce this here and LightSpeed is generating a WHERE clause as I'd expect it to. Could you provide us with a small console application and SQL CREATE TABLE scripts that reproduce the problem? Also please let us know which database you're using (it shouldn't matter, but always best to be sure...!). Thanks! |
|
|
I found what was causing getting all of items in table.
I dont know why but there was no FK between places and ratings. Adding them fixed issue but on the other hand it was normal that all places was retrieved from table when rating was used like above? |
|