How to edit records in a table?

klaus

Expert

Licensed User

Longtime User

• Jun 11, 2012

• #2

First you should change line 101 in the display routine from
edit_delete_id = rc.Row -1
to
edit_delete_id = GetCell(rc.Row, 0)

Second, it's normal that SelectedRow = -1 after deleting. It's set to this value in ClearAll which is called in Loaddatas and it's logical too because after deleting the selected row there is no selected row anymore.
What SelectedRow value did you expect ?

Best regards.

 

Upvote 0

systems1

Member

Licensed User

Longtime User

• Jun 12, 2012

• #3

klaus said:

What SelectedRow value did you expect ?

Click to expand...

Actually i expect id of the record which is displayed in the table as ID.
This code is working fine.

But i have a doubt. If i don't want to display ID in table How can i get record id?

eg:table structure

NAME | ADDRESS | PLACE
test | somaddres | some place

in this case i thing it is not a good idea to select Selectedrow of table id.

How can we do that?

Please Help me

 

Upvote 0

klaus

Expert

Licensed User

Longtime User

• Jun 12, 2012

• #4

I'd suggest you to store the IDs in a Map when you load the database with the rowindex as the Key and the ID as Value so you know the Id for each row.

Best regards.

 

Upvote 0

systems1

Member

Licensed User

Longtime User

• Jun 12, 2012

• #5

Thank you for your replay klaus

 

Upvote 0

S

swamisantosh

Member

Licensed User

Longtime User

• Jan 29, 2013

• #6

unable to unzip data

I have downloaded test.zip file

i would not extract the test.zip:

sign0013:

 

Upvote 0

mangojack

Expert

Licensed User

Longtime User

• Jan 29, 2013

• #7

Confirmed , for some reason the zip is corrupt ?
Cheers mj

 

Upvote 0

W

wheretheidivides

Active Member

Licensed User

Longtime User

• Jan 30, 2013

• #8

you use marget's DB class, it's a breeze. You put the variable (expyear) into the filed (var1), then update record. It's so easy compared to that other db nonsense.

db.PutField("var1", ExpYear)
db.UpdateRecord

 

Upvote 0