Database Flush Command not working

[william humphrey]

Nothing in the liveCode logs say "flush" either.

I also have the logs generated by LiveCode. Interesting the time of the
crash does not match. The last line in those logs when things are working
looks like this:

VDatabase_SqlSelect...
PARAM: dbRef = "18056848"
PARAM: inStrQuery = "select d_cargo_linenumber, d_cargo_pieceCount,
d_cargo_pkgtype, d_cargo_description, d_cargo_piece_rate, d_cargo_charges,
d_cargo_pieceweight, d_cargo_ratetype_ref, d_cargo_defaultcargodesc_ref,
recID from data_cargo where d_cargo_billoflading_ref = 23989"
return res = 602889520

VCursor_RecordCount...
PARAM: cursorRef = "602889520"
return res = 1

VCursor_GetRecords...
PARAM: cursorRef = "602889520"
return res = 0

VDatabase_IsOpen...
PARAM: dbRef = "18056848"
return res = 1

VDatabase_Close...
PARAM: dbRef = "18056848"
return

VDatabase_Destructor...
PARAM: dbRef = "18056848"
return (vuint32)0 = 0

VConnection_Close...
PARAM: serverRef = "565089968"
return

VServer_Destructor...
PARAM: serverRef = "565089968"
return res = 0

Valentina_ShutDownClient...

When there is a crash the last line looks like this:


VDatabase_SqlExecute...
PARAM: dbRef = "575261824"
PARAM: inStrCommand = "insert into info_billoflading (
 i_billoflading_id,i_billoflading_clientShipper_ref,
i_billoflading_clientConsignee_ref, i_billoflading_kcodeLoading_ref,
i_billoflading_shipperAddressLine, i_billoflading_consigneeAddressLine,
i_billoflading_freightForwarderAddressLine,
i_billoflading_kcodeDischarge_ref, i_billoflading_ExportDocsFurnished_fl,
i_billoflading_AESremainder_fl, i_billoflading_surcharges_fl,
i_billoflading_export_fl,i_billoflading_hazCargo_fl,
i_billoflading_freightcollect_fl, i_billoflading_printed_fl,
i_billoflading_notifyparty, i_billoflading_specialNote,
i_billoflading_MarksAndNumbers, i_billoflading_totalPallets,
i_billoflading_CubicFeet,i_billoflading_TotalPayable,i_billoflading_precarriage_ref,
i_billoflading_number, i_billoflading_clientFreightForwarder,
i_billoflading_voyagenumber_ref, i_billoflading_dockReceipt,
i_billoflading_datecreated ) VALUES ('24019','8327','480','4909', '1','','',
'24815',false,false,true,true,false,false,false, 'Same as
Consignee','','','1', '','','','075',NULL,'SS102','6539','2011-01-19' )"
return res = 1

and nothing more.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20110122/3c287a25/attachment.htm>