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 - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Bind data in DataGrid from different Oracle tables

alexUA
Posts: 23

Bind data in DataGrid from different Oracle tables Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 14 Jan 10 2:35 AM

Hi all!!! I need to bind data in DataGrid from 2 different tables in Oracle? I am trying to do like this way:

Datagrid.SQL.Text = "SELECT * FROM TABLE1 T1, TABLE2 T2 WHERE T1.FIELD1=T2.FIELD2....."

Is that possible at all? Because I didnt see fields from secondary table. They are empty

Thanks for your help!

[Reply][Quote]

RJ Samp
Posts: 973

Re: Bind data in DataGrid from different Oracle tables Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 14 Jan 10 2:57 PM

The 'term' you are looking for is not Bind. It's JOIN.

It's a clause in a SQL statement.

Datagrid.SQL.Text = "SELECT * FROM TABLE1 T1 INNER JOIN TABLE2 T2 ON(T2.Keyfield=T1.Keyfield) WHERE .......

or LEFT OUTER JOIN if the keyfield item doesn't always exist in table 2

NEVER use SELECT * unless you truly need to....if you need 6 fields, then specify the 6 fields exactly....

An exception is when you SELECT * to open up a 1 record buffer to perform an INSERT.

SELECT * FROM TABLE1, TABLE2 would be a cartesian join that could quickly grab a million records and crash your server!

[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 © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 7/8/2025 12:17:45 PM