Hello out there,
I am using VB6, Maximizer 5, ODBC - generating an SQL query and DAO. There are a number of problems I have encountered.
The first problem is when I access the 'text' field from the 'notes' table it appears to be encrypted. Is there any way around this?
Second, Ive tried doing an inner join with client, notes, and combined_client_user_fields and I keep getting a generic ODBC error. Here is the sql for that:
sql = "SELECT * From Client"
sql = sql & " Inner Join (Combined_Client_User_Fields Inner Join Notes"
sql = sql & " On Combined_Client_User_Fields.Client_Id = Notes.Client_Id)"
sql = sql & " On Client.Client_Id = Combined_Client_User_Fields.Client_Id"
Any comments would be greatly appreciated!
hbaker over and out
[This message has been edited by hbaker (edited 12 October 2000).]
[This message has been edited by hbaker (edited 12 October 2000).]
Original Post
join.