Home | Forums | Contact | Search | Syndication  
 [login] [create account]   Sunday, December 3, 2023 
View User Profile  

 User Profile - Tom Lewis  
Tom Lewis
(SalesLogix Business Partner)


Log in to send this member a message!

 Tom Lewis's Contributions
Tom Lewis has contributed 1 comments and 0 articles.
Select to view:    
Comment: SQL Parse error
I was able to use your example and it worked fine. I tried to modify it to do something slightly different and I'm getting an error message "Failed to Parse SQL" The statement that I am passing to the data grid is:

.SQL.Text = "Select c.LastName, c.FirstName from C_IAContact iac, join C_InvAccount ia on iac.c_invaccountid = ia.c_invaccountid join Contact c on iac.contactid = c.contactid where c.lastname = '" & strLastName & "' and c.firstname = '" & strFirstName & "'".

I wrote this first in Query Ananlyzer so I know technically it works. Not sure where it's getting stuck. Any ideas?


Author: Tom Lewis - 4/5/2003


 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2023 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
page cache (param): 12/3/2023 4:47:39 AM