>Nice link John. Thanks!
>
>I think I have it working based on this response in that thread:
>
>

>ok. I think this is an bug in VS2005 query builder for SQL mobile. Mine is final version and I still have the same problem. someone may want to report this to MS.
>
>the problem is that it creates "{ oj.....}" in Tableadapter which you drag from "Data Connections" table. I just create query/TableAdapter  and remove that then everything works for me.
>
>you may want to give it a try in "Query" or your own TableAdapter.
>
>1. open up your *.xsd dataset file
>2. go to toolbox and drag a "query" (or TableAdapter) over.
>3.  follow the wizard, it will give you {oj...} in "query builder" click "ok" (don't worry in this point because it will keep on adding {oj} for you all the time)
>4. back to "tableadpter query configuration wizard" screen, and remove "{oj"  "}"
>5. click "Next" all the way to finish the wizard
>6. right click on the query you just created and choose "preview data"
>7. click on "preview" then every thing shows out correctly from there.
>

Glad I could help.