Adding a new record

I run the Examples, and things work great. I click the Add button, and a new record appears at the bottom, just like it should.

I created my own database and loaded some records via SQL.
I then modified one of the examples to use my table, and the grid displays my records. I am also able to delete.

But when I click the Add button, the grid redisplay with no records in it. When I refresh my screen, the records display again, including new record. I can modify and delete, but when I add, my records disappear.

What am I missing?

Thanks.

Difficult to analyse this way. Could you send me the relevant code (to [email protected])?

I'm having the same problem, but this error occours just have one page !

I've downloaded: DrasticTools067.zip, unpack and rename 'mysqlphpgrid.class.php' to 'drasticGrid.class.php'

Import table country with all data

So, I've changed Examplemysqlconfig.php and try to access using 'ExampleGrid2.php'

This works fine !

But, if you empty table country you get the first error:

GET .../ExampleGrid2.php?op=v&start=0&end=20&cols=id,Code,Name,Continent,SurfaceArea,Population,LocalName&sortcol=id&sort=a
invalid flag after regular expression
[Break on this error] <b>Warning</b>: mysql_data_seek() [<a href='function.mysql-data-seek'>function....

If you add just one record this works again :-)

Butt... If you have just one record and try to add another you got an error:

GET .../ExampleGrid2.php?op=v&start=NaN&end=NaN&cols=id,Code,Name,Continent,SurfaceArea,Population,LocalName&sortcol=id&sort=a
t.data[0] has no properties
[Break on this error] if (t.rowselected == t.data[0][i])
drasticGrid.js (line 429)

Thanks

Igor

Indeed, this was a bug.
It is fixed in DrasticTools version 0.6.8 which is now available at the website http://www.drasticdata.nl

good luck