Hello Guys!

Im having a poltergeist here...lol, and i dont know how to fix..

Im counting the number of nodes of a datagrid, and in the server, the count is 5. But in the machine of the user ,  the count of the datagrid nodes is 4. Anyone know something about this? lol.. There are some users that works perfectly and other users no...

thanks!

Rafael

SecodeID limiting the number of nodes on the user's grid.......

Don't know what you mean by 'in the server'...... a network client is a network client.....whether it's nstalled on a laptop, desktop, terminal server,  or server. Log into the network client as the same SLX user on both the server and the user's machine for a fair comparison.

You've lost me completely on this.....is this an installation issue? A connection issue? a local date format setting on the machines? what is a 5 node on the datagrid? What is a 10 node or a 20 node? Are you speaking about Rows or Columns in the grid, just so I get your terminology correct.

Hi RJ Samp!!

lol..sorry for this misunderstanding...its my bad english...lol

I created a datagrid with 5 rows (nodes)... Have 3 columns, 1 is a checkbox column... When i try to retrieve the data, it means, when i want to know what is the status of the checkbox column of each row (checked or not), i use the command Datagrid.nodes(0) ...

But, i dont know why, in certain users machines, this code gives me an error....The code dont recognize the fifth row..he recognizes only 4 rows.... But this happens in some machines, not all the machines in the network... What im trying to say is, i dont know what is precisely, but appears to be a problem in the user machine, because for other uses works well

understood?

thanks!

Rafael

Rows are nodes, yepper. How do you 'create' a datagrid with 5 rows\nodes? Don't you create a datagrid with 5 columns (keyID, 3 columns, 1 checkbox column) and then retrieve the data to fill the rows? The number of rows\nodes retrieved is based on the data queried.....on one machine it's 5, on the other it's 4?

On the machine that gets the wrong answer.....what happens when you log in as a different user? same results with Admin as with user 1 versus user 2?

Depending on how you retrieve the data and how Ownership\SeccodeID lines up with team ownership...you may get a different answer for each user.

Run the SLXProfiler on this machine and you will probably find out what's up.....Regional ShortDate format is what?

in the saleslogix folder is an application called slxProfiler (on lan version can run it from the client machine)

Run the application and attach it to the saleslogix clinet application.

when you refresh the grid, look at the query and again at the number of rows returned.

possibly security is blocking access to some of the data or you do not have the grid configured correctly.

suggest you change all columns to text, no formatting and see what you get then.

Hello Guys!

Thanks for the answer....

My problem is in the code:

    strLine1 = "" & dgPesq.nodes(0).Values(2)

    strLine2 = "" & dgPesq.nodes(1).Values(2)

    strLine3 = "" & dgPesq.nodes(2).Values(2)

    strLine4 = "" & dgPesq.nodes(3).Values(2)

The error is in the last line, the slx dont find the last row in the grid.... I will change this code, i will work with the recordset of the grid, and not with the rows of the grid..maybe i have some success...

thanks!

Rafael

Not sure what you are trying to do, but working with the recordset may be a better option.

Also, couldn't you dynamically get a count of Nodes on the Grid before reading them to avoid trying to read an item that doesn't exist?

As per some of the answers here, there are reasons why a Grid may present different results to Users (primarily security), so using some of the Tools (e.g. SLX Profiler) may help you find an explanation to why you are not getting as many records as expected.

Regardless, you should make sure that your Code is able to determine the number of rows at run time and adjust accordingly (e.g. using an array instead of specific values for each line).

  For example (please don't rely on this syntax, I have not tested this code):

  Dim iNodeCount, i

  Dim arrLine

  iNodeCount = dgPesq.nodes.count

  Do while i < iNodeCount

    arrLine(i) = dgPesq.nodes(i).Values(2) & ""   ' (I am not verifying the existance of a Value at Index 2, assuming that it exist)

    i = i + 1

  Loop

Thanks for the answer Raul!

I will test my code using the datagrid recordset...i post here the results later...thanks everyone!!

Regards

Rafael