Guriddo » Topic: Tree Grid database SQL – demo bug

Tree Grid database SQL – demo bug

Guriddo
Tree Grid database SQL – demo bug

This topic has 7 replies, 3 voices, and was last updated 16 years, 11 months ago by zerikv.

Creator

Topic
June 12, 2009 at 12:38 am #73500

cristib
Participant

Hi,

There is posted anywhere the SQL for Tree grid side ?

Currently the downloadable demo does not include the sql for the tree grid, only for normal grid.
Creator

Topic

Viewing 7 replies - 1 through 7 (of 7 total)

Author

Replies
June 12, 2009 at 1:17 am #87207

tony
Keymaster

Hello,

You can look in server.php – case 'tree' :

Regards

Tony

June 12, 2009 at 1:20 am #87208

cristib
Participant

Thanks,

Congrats for a great grid 🙂

June 12, 2009 at 3:22 am #87229

zerikv
Participant

Hi,

Have you the sql commands to create and populate the table “accounts” ?

This table is needed to run the treeview sample, but the sql is not in the zip jqGrid-3.5.beta-demo.

Thanks,

June 12, 2009 at 3:24 am #87230

cristib
Participant

I think that's it:

CREATE TABLE IF NOT EXISTS accounts (

June 12, 2009 at 3:41 am #87231

zerikv
Participant

Thank cristib for your quick reply

It seems miss some columns like “level”, “rgt” and “lft” to select sub-tree in the table. These columns are a bit tricky to calculate. Do you have the insert commands or could you point me where I can find them ?

June 12, 2009 at 3:50 am #87232

cristib
Participant

The create table i sent you is for adjiacent model, not for nested table model.

Take a look on the mentioned file to see about them….

June 12, 2009 at 4:46 am #87233

zerikv
Participant

Thanks cristib for your help

Finally to run the treeview demo I have added 3 columns in the create command
Author

Replies

Viewing 7 replies - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.

Stay connected with us in your favorite flavor!

Copyright 2014 TriRand LtdAll Rights ReservedRSS