I'm trying to fill a matrix on a custom view, with data comming from a SQL query.
When I issue the call to LoadFromDataSource, th matrix remains empty.
If I try to fill it manually, then the rows are correctly added but nothing is shown.
I missed something?
Roberto MarraHi Eric,
Im not an expert, but did you update the form where is contained the matrix with a command
or something like that?Form.Update()
Roberto MarraSorry Eric,
I didn't see that you posted the code...
Eric LapougeI've forgotten to give the SQL Query which I'm using... It's:
SELECT 0, CardCode, CardName, Balance, DNotesBal, OrdersBal FROM OCRD
I'm using a where clause, but I guess it has nothing to do with my current problem.
Marco SchweighauserHello Eric,
the Matrix can not be filled by SQL queries. Only UserDatasources can be attached using the LoadFromDataSource method.
Please use the Grid component instead. The Grid offers you a ExecuteQuery() to fill it from a query result.
Eric LapougeHello Marco,
I know that I can't fill the Matrix from SQl queries.
I can't use the Grid, since I need the linkbutton object to each of the BP in resulting resultset.
I did an other try last night: create the form from ScreenPainter, then load it from the Framework and execute the query (I can evently change it before executing it. On my "final" version, I've just added an hack to change the WHERE clause of the query) and it works.
In this case, AFAIK I'm using a system data source and not a user's one.
From my readings of the Framework's documentation, I'm not limited to userDatasources.