Database Flush Command not working

[william humphrey]

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"

Let me know what you suggest.

put "insert into info_clients (i_clients_id,i_clients_ein, i_clients_title,
i_clients_firstname, " &   \
         " i_clients_middlename, i_clients_lastname, i_clients_nickname, " &
 \
         " i_clients_notify, i_clients_website, i_clients_defaultkcode_ref,
" &  \
         " i_clients_marks, i_clients_notes, i_clients_created, " &  \
         " i_clients_updated, i_clients_salutation_ref,
i_clients_companyname, " &  \
         " 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
("   &  \
         "'" & t_i_clients_id &  "'" & comma &  "'" & t_i_clients_ein & "'"
& comma &  "'" &  t_i_clients_title &  "'" & comma &  "'" &
t_i_clients_firstname & "'" & comma &   \
         "'" & t_i_clients_middlename &  "'" & comma &  "'" &
t_i_clients_lastname &  "'" &  comma &  "'" &  t_i_clients_nickname &  "'" &
comma &  \
         "'" & t_i_clients_notify &  "'" & comma &  "'" &
t_i_clients_website &  "'" & comma &  "'" & t_i_clients_defaultkcode_ref &
 "'" & comma &  \
         "'" & t_i_clients_marks &   "'" & comma &  "'" &  t_i_clients_notes
&  "'" & comma &  "'" & t_i_clients_created &  "'" & comma &  \
         "'" & t_i_clients_updated &  "'" & comma &  "'" &
 t_i_clients_salutation_ref &  "'" & comma &   "'" & t_i_clients_companyname
& "'" & comma  & \
         t_i_clients_IsCompany & comma &  "'" & t_i_clients_eintypes_ref &
 "'" & comma &  t_i_clients_IsShipper & comma &  \
         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
   --ERROR 0x99503 happens if date field is empty
   put VDatabase_SQLExecute( gDatabase, tQuery) into affectedRows
   put affectedRows && "client added." into field "error_field" of card
"Client Card" of stack "clients"

On Fri, Jan 21, 2011 at 3:45 AM, Ivan Smahin
<ivan_smahin at paradigmasoft.com>wrote:

> On 1/21/2011 2:49 AM, william humphrey wrote:
>
>> I have my vServer init
>>
>> ; 1 - Flush after any data modification.
>> ; 0 - Default value - no flushing.
>> FlushEachDataChanges=1
>>
>> 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.
>>
>>  It should be working. Can you please show me your "write data" code?
>
>
>  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.
>>
>>  get VDatabase_Flush( dbRef )
>
> --
> Best regards,
> Ivan Smahin
> Senior Software Engineer
> Paradigma Software, Inc
> Valentina - The Ultra-Fast Database
> http://www.valentina-db.com
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>



-- 
http://www.bluewatermaritime.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20110121/6f467c5e/attachment.htm>