Database Flush Command not working

[Lynn Fredricks]

Hi Barry,
 
Yes - in fact, we are the organizers of the Omegabundle 2011 @
http://www.omegabundle.com. Its only going to continue for another week or
so as its a VERY limited special offer, so if you are interested you should
jump on it :-)
 
Best regards,

Lynn Fredricks

Paradigma Software
http://www.paradigmasoft.com <http://www.paradigmasoft.com/> 

Valentina SQL Server: The Ultra-fast, Royalty Free Database Server 

 
 


  _____  


Hi all,

 

I've just received an offer for a Omegabundle 2011.

 

It includes vOffice Server.

 

Is this offer legit?

 

Thanks,

    Barry G. Sumpter

 

From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of william humphrey
Sent: Sunday, 23 January 2011 6:12 AM
To: Valentina Developers
Subject: Re: Database Flush Command not working

 

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_precarri
age_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/6f34f7e2/attachment.htm>