Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
I just read that in paradox the OUTER keyword is optional.
So lets say you want to join customers and visitors from a website. They are not mutually exclusive and you're matching by email address.
select visitors.name, visitors.email, customers.name, customers.email from visitors full outer join customers on upper(customers.email)=upper(visitors.email)
You'll get 4 columns, like this...
Customer_name, Customer_email, null null --this entry only in customers
null, null Visitor_name, Visitor_email --this entry only in visitors
Customer_name, Customer_email,Visitor_name, Visitor_email --this entry in both
like this...
Bob A Fett, Bobafet@email.com, NULL, NULL
NULL, NULL, Claude O'vercast, cloudy@email.com
June C. june@email.com, June, June@EMAIL.com
Does this help?
Yahoo ID: Commander_Bombast
Opportunity is missed by most because it is dressed in overalls and looks like work.
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
Post ID #15109 (Level 1.1)
Reply to 15103
and Parent is 15101
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
Post ID #15111 (Level 1.2)
Reply to 15103
and Parent is 15101
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
Post ID #15106 (Level 1.1)
Reply to 15104
and Parent is 15101
I have not used those operators in queries in qbe in a long time, but it seems to me that in version Paradox 3.0 or 3.5 that the "!" may have been valid. I will try to find my old books and see if I remember it correctly. I could be wrong.
Can we please get the exact error message that you are getting. That may give us some idea of what exactly your problem is. Paradox does not translate the inclusion operator (!) into SQL. Not sure why this wasn't coded since it is essentially a full join. If you want a full join in SQL you have to either write it in SQL or use the SQL builder in Paradox.
Yes I did it. But the problem is that not present present the data. In the QBE the ! operator works, but like you say in the sql query the ! operator don't work. How to do when the from clause have more than 3 tables. In the QBE when i put the (!) in the example_id field, the query show the results. But in sql code, the query results is empty. Take a look to the following code:
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.