slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - Controls
Forum to discuss usage & tips for SalesLogix controls and other 3rd party ActiveX controls. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Controls | New Thread

View: Search:

Author

Thread: Grid Control Generating incorrect SQL

LeVar Berry
Posts: 47

Grid Control Generating incorrect SQL Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Mar 09 7:17 PM

I have a grid where the base table is a custom table.

When I join a field from the CONTACT it generates incorrect SQL

For example without the Contact:
From LOCKS A1 INNER JOIN ACCOUNT A2 ....etc

with Contact:

From LOCKSINNER JOIN CONTACT A2 on (A1.CONTACT ... ....etc **NOTE NOw THERE IS NO A1 and there is NOSPACE between LOCKS and INNER.

[Reply][Quote]

RJ Samp
Posts: 973

Re: Grid Control Generating incorrect SQL Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 01 Apr 09 9:33 AM

Why would I be thinking (for once) that LOCKS is a reserved word of some kind......

Scipt the SQL yourself and feed it to the grid at run time.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

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/26/2024 9:39:16 AM