2. PHPRunner General questions
  3. Master-Child Empty Table
This topic is locked

Master-Child Empty Table

 		3/28/2007 20:50:50
PHPRunner General questions
D
 dharris909 author

Friends,
I am relatively new to PHP runner. I LOVE it! But I encountered an interesting (troubling) problem with Master-Child tables. When I go to edit a table which is empty, or has no related records connecting the child table from the master table. I get the following error.
Error type 2

Error description mssql_data_seek() [function.mssql-data-seek]: Bad row offset
If I add a related record to the table, then the error doesn't occur. Is there something I don't understand? <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=4909&image=1&table=forumtopics' class='bbc_emoticon' alt=':blink:' />
J
 		Jane 3/29/2007

answered in your personal email.
P
 		psychodad71 4/4/2007

please let me know the solution per mail as well. Thanks
J
 		Jane 4/5/2007

Hi,
you need to edit dbconnection.mssql.win.php file in C:\Program Files\PHPRunner3.1\source\include folder.
Find db_dataseek function and add the conditional if ($row>0) expression:

function db_dataseek($qhandle,$row)

{

if ($row>0) { mssql_data_seek($qhandle,$row); }

}