I have never used Fox Pro before, and now I need to do a query that, in Access, uses DISTINCTROW as instruction. I can't make this operator to work in VF, is there some operator like this one? Thanks!
If you are referring to the SQL SELECT statement, then try using SELECT DISTINCT, not DISTINCTROW.
If you have been using SQL commands in Access, you will find some differences in how similar commands are used in VFP. VFP uses a more standard syntax than Access does. In other words, VRP's SQL commands are a lot more like SQL Server, Oracle, etc.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.