They all look like this only with different SQL - everything works fine except flush does not occur until I close the database. I would put a flush command in here after every write command throughout if I knew how to do it (although it shouldn't be necessary because of "flush after any data modification"<div>
<br></div><div>Let me know what you suggest.<br><div><br></div><div><div>put "insert into info_clients (i_clients_id,i_clients_ein, i_clients_title, i_clients_firstname, " & \</div><div> " i_clients_middlename, i_clients_lastname, i_clients_nickname, " & \</div>
<div> " i_clients_notify, i_clients_website, i_clients_defaultkcode_ref, " & \</div><div> " i_clients_marks, i_clients_notes, i_clients_created, " & \</div><div> " i_clients_updated, i_clients_salutation_ref, i_clients_companyname, " & \</div>
<div> " i_clients_IsCompany, i_clients_eintypes_ref, i_clients_IsShipper, i_clients_IsNoSurcharge, i_clients_IsNoFeesAtAll, i_clients_IsUsePLTcharge, i_clients_IsNoEmailNotice, i_clients_IsPrePaid, i_clients_EEIfiler) VALUES (" & \</div>
<div> "'" & t_i_clients_id & "'" & comma & "'" & t_i_clients_ein & "'" & comma & "'" & t_i_clients_title & "'" & comma & "'" & t_i_clients_firstname & "'" & comma & \</div>
<div> "'" & t_i_clients_middlename & "'" & comma & "'" & t_i_clients_lastname & "'" & comma & "'" & t_i_clients_nickname & "'" & comma & \</div>
<div> "'" & t_i_clients_notify & "'" & comma & "'" & t_i_clients_website & "'" & comma & "'" & t_i_clients_defaultkcode_ref & "'" & comma & \</div>
<div> "'" & t_i_clients_marks & "'" & comma & "'" & t_i_clients_notes & "'" & comma & "'" & t_i_clients_created & "'" & comma & \</div>
<div> "'" & t_i_clients_updated & "'" & comma & "'" & t_i_clients_salutation_ref & "'" & comma & "'" & t_i_clients_companyname & "'" & comma & \</div>
<div> t_i_clients_IsCompany & comma & "'" & t_i_clients_eintypes_ref & "'" & comma & t_i_clients_IsShipper & comma & \</div><div> t_i_clients_isNoSurcharge & comma & t_i_clients_isNoFeesAtAll & comma & t_i_clients_isUsePLTcharge & comma & t_i_clients_isNoEmailNotice & comma & t_i_clients_isPrePaid & comma & t_i_clients_EEIfiler & ")" into tQuery</div>
<div> --ERROR 0x99503 happens if date field is empty</div><div> put VDatabase_SQLExecute( gDatabase, tQuery) into affectedRows</div><div> put affectedRows && "client added." into field "error_field" of card "Client Card" of stack "clients"</div>
<br><div class="gmail_quote">On Fri, Jan 21, 2011 at 3:45 AM, Ivan Smahin <span dir="ltr"><<a href="mailto:ivan_smahin@paradigmasoft.com">ivan_smahin@paradigmasoft.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im">On 1/21/2011 2:49 AM, william humphrey wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I have my vServer init<br>
<br>
; 1 - Flush after any data modification.<br>
; 0 - Default value - no flushing.<br>
FlushEachDataChanges=1<br>
<br>
set to write the data after every change. Is there any way to check this in the logs or using livecode? I'm certain it is not working because if I have a crash in livecode then all the data which was made before the last proper shut-down is lost.<br>
<br>
</blockquote></div>
It should be working. Can you please show me your "write data" code?<div class="im"><br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Since this is not working and there is no way to test it (conjecture) can someone give me sample livecode database flush commands so that I can force it to work? I looked in the WIKI already.<br>
<br>
</blockquote></div>
get VDatabase_Flush( dbRef )<br>
<br>
-- <br>
Best regards,<br>
Ivan Smahin<br>
Senior Software Engineer<br>
Paradigma Software, Inc<br>
Valentina - The Ultra-Fast Database<br>
<a href="http://www.valentina-db.com" target="_blank">http://www.valentina-db.com</a><br>
<br>
_______________________________________________<br>
Valentina mailing list<br>
<a href="mailto:Valentina@lists.macserve.net" target="_blank">Valentina@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a><br>
</blockquote></div><br><br clear="all"><br>-- <br><a href="http://www.bluewatermaritime.com">http://www.bluewatermaritime.com</a><br>
</div></div>