This is the craziest thing i have ever seen LOL

<tt>
dleec45@... wrote:<BR>
<BR>

>>My Thoughts - Don't use RowLock - It's an archaic way of working :)<BR>
>><BR>
>>Your fix looks fine - I would never have been through there, and would <BR>
>>prefer to avoid anything that breaks the generational processing that <BR>
>>Firebird has always provided.<BR>
> <BR>
> What I am doing is getting a new seed with a random generator using this:<BR>
> <BR>
> $db->RowLock('seed','seed',srand($rs->fields[0]) +

intval(substr(microtime(),2,4)),'seed=seed');<BR>
<BR>
The question has to be "Why?"<BR>
What are you trying to do, then perhaps we can direct you another way :)<BR>
If you need to guarantee something unique, then you would normally use a <BR>
generator, insert the blank record with the generator id, and then add <BR>
the details. But since you know that the id is unique, there is no need <BR>
to lock, just post the details.<BR>
<BR>

>>The correct way of doing things is to <BR>
>>handle the error when a commit fails because a second user has already <BR>
>>updated the record. If you want to say that someone else is modifying a <BR>
>>record, then an 'UPDATING' field would be more appropriate - into which <BR>
>>you put the ID of the user who is 'locking' the record. Updating that <BR>
>>field would be equivalent of RowLock, and would tell you who is <BR>
>>processing the record - ready for when things get stuck ;)<BR>
> <BR>
> I'm afraid I do not know of any other way to do this as my experience with PHP and

Firebird15 is very small. I'm just beginning to attempt this modification and the
mountain is steep, cliff like actually!!! Any advise appreciated. Lee<BR>
<BR>
I've pushed this back onto the firebird-php list as well. Other people <BR>
there may well come up with other useful ideas. And any help can be <BR>
useful ;)<BR>
<BR>
-- <BR>
Lester Caine<BR>
-----------------------------<BR>
L.S.Caine Electronic Services<BR>
</tt>


<br>

<!-- |**|begin egp html banner|**| -->

<table border=0 cellspacing=0 cellpadding=2>
<tr bgcolor=#FFFFCC>
<td align=center><font size="-1" color=#003399><b>Yahoo! Groups Sponsor</b></font></td>
</tr>
<tr bgcolor=#FFFFFF>
<td align=center width=470><table border=0 cellpadding=0 cellspacing=0> <tr> <td
align=center><font face=arial size=-2>ADVERTISEMENT</font><br><a
href="http://rd.yahoo.com/SIG=129suqtd3/M=295196.4901138.6071305.3001176/D=groups/S=1705007183:HM/EXP=1085478734/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com"
alt=""><img
src="http://us.a1.yimg.com/us.yimg.com/a/ya/yahoo_companion/lrec_companion_043004.gif"
alt="click here" width="300" height="250" border="0"></a></td></tr></table> </td>
</tr>
<tr><td><img alt="" width=1 height=1
src="http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=439963167"></td></tr>
</table>

<!-- |**|end egp html banner|**| -->



<!-- |**|begin egp html banner|**| -->

<br>
<tt><hr width="500">
<b>Yahoo! Groups Links</b><br>
<ul>
<li>To visit your group on the web, go to:<br><a
href="http://groups.yahoo.com/group/firebird-php/">http://groups.yahoo.com/group/firebird-php/</a><br>

<li>To unsubscribe from this group, send an email to:<br><a
href="mailto:firebird-php-unsubscribe@yahoogroups.com?subject=Unsubscribe">firebird-php-unsubscribe@yahoogroups.com</a><br>

<li>Your use of Yahoo! Groups is subject to the <a
href="http://docs.yahoo.com/info/terms/">Yahoo! Terms of Service</a>.
</ul>
</tt>
</br>

<!-- |**|end egp html banner|**| -->