Hello everyone,

I created a datagrid and a simple data entry form (example from Active Forms section of DevLogix III.7) and tailored it to my own use. I then added some labels to the form where the datagrid resides. The idea is that when a user clicks on a node in the grid, the labels will be populated with the values from the grid (see code below). The intention is to not make the user have to scroll in the datagrid. This works really well except for one thing....

when testing, I did a ctrl-F5 and saw that the values within my datagrid changed. What appears to be happening is that the values that are showing up in my label's are getting posted back to the database and updating another record on the grid when a hard refresh occurs.

I dont understand why this is happening. I'm using SLX 7.5.0.1 (LAN).

Thank you in advance

<pre>Sub grdMainChangeNode(Sender)
lbCorpDir.Caption = grdMain.GetCurrentField("CORPDIRECTORY")
lbOffsiteName.Caption = grdMain.GetCurrentField("OfficialSiteName")
lbSiteDir.Caption = grdMain.GetCurrentField("SiteDirectory")
lbSiteNum.Caption = grdMain.GetCurrentField("SiteNumber")
lbURL.Caption = grdMain.GetCurrentField("CLMURL")
lbVersion.Caption = grdMain.GetCurrentField("CLMVERSION")
lbSDSAdmin.Caption = grdMain.GetCurrentField("SDSAdmin")
'nodes(0).Values(1)
End Sub

There can be several reasons for this - but to avoid all of them, set the RowSelect to True and the PostChanges to false - and, ensure that none of the labels are bound (.Text) to any of the columsn in the db.

Pure genius! Thank you very much Mike.

One more question if I may..... For some reason I cannot use my data form to insert a new row into my table if a row (for that accountid) does not already exist. My primarykey is set to auto increment. I have never had any success getting SLX Profiler to work, but using SQL profiler it appears that it never even tries to do an insert. This only happens if a record doesnt already exist in the DB for that account.

Any thoughts on this one?

Good news

Basically, for this to work you need a grid, bound correctly and an add/edit form that is linked up as well. So:

1) Add a new form/tab based on Account. Add a grid and make sure the BindID of the grid is set to the primaryID (such as AccountID)

2) Create a new form that is based on the table you wish to add to (say, c_mydata). This is created in architect as a 1:M from account. It will have c_mydata.AccountID added automatically. Save the form.

3) In the Edit View of (1) - select the form created in (2)

4) In the SQL property of the grid - select the secondary table (created in 2). In the Join box - drag in the AccountID from the secondary table (from 2 - c_myData.AccountID)

That's it !

Hi Mike,

I finally figured out what my problem was.....I went through a 3rd time and validated that I did exactly as you suggested and I was still getting the problem. I then used my brain (it doesnt always work ) and really thought about the issue I was having. I checked my JOINS in architect and realized I had the join from my new table to ACCOUNT set as an INNER. I changed it to LEFT and all is good in the world.

Thanks again for all your help. It is much appreciated!