Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Saturday, March 28, 2020 
 
View User Profile  

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


fiogf49gjkf0d


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
fiogf49gjkf0d
Ryan,
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?

Thanks,
Tom

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 © 2020 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): 3/28/2020 7:00:13 PM