USERDATASOURCES AND SQL

[Former Member]

Hello...

i have a SQL that i want to run... onjoins and stuff like that,

linebyline i can fill the matrix, its working ok, but slowly...

i just want to know if i can bind the column to a userdatasource, fill the "UDS" with the data retrieved with the sql recordset and then just show it in the matrix...

if yes, please, can send me example on filling the datasource?

(this is the SQL:

select T1.ItemCode+' - '+T3.ItemName
  from OWOR T1 INNER JOIN OITT T2 ON T1.ItemCode = T2.Code 
               INNER JOIN OITM T3 ON T2.Code = T3.ItemCode
 where T1.DocNum <= 100

Thank you guys

[Former Member · Accepted solution]

<a href="http://www.sapbo.it/modules.php?name=News&file=article&sid=5&mode=thread&order=0&thold=0">http://www.sapbo.it/modules.php?name=News&file=article&sid=5&mode=thread&order=0&thold=0</a>

[Former Member]

thank you man.... ^^

[Former Member]

Hi Fernando

look this example

good work

Pasquito

[Former Member]

Have a look at this post

there is a function to load a query in a matrix.

Note than with SDK2005, you have the grid object which is quite fast