Home | Forums | Contact | Search | Syndication

[login] [create account]   Friday, November 22, 2024

slxdeveloper.com   Home   Search   Contact us   About slxdeveloper   Syndication  Community   Forums (NEW!)   Newsletter Archive  Members   Your Profile   Submit Article  General   Administration (6)   OLE DB Provider   Miscellaneous (2)  Architect   VBScript (9)   ActiveX Controls (6)   How To's (14)   .NET Extensions (3)  External   OLE DB Provider (12)   SLAPI (SlgxApi.dll)   SalesLogix COM (1)  Web   ASP/ASP.NET (2)   Web Services   Web Client  Downloads   Samples (17)   Documentation (7)   Utilities (18)  Resources   SalesLogix (3)   Programming (1) 11/22/2024 12:51:05 AM slxdeveloper.com Now Live!   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: Comments  Articles  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 © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software. code of conduct |

page cache (param): 11/22/2024 1:10:04 AM