FiveTech Software tech support forums

Thanks Rao, that seemed to solve the problem. If I run in to any issues, I will contact you.

Hi Rao,

It did not work. Any ideas what needs to be done?

Rao,

I changed the following code and it seems to be working.

cSqlIns += STRTOHEX( MemoRead( cCft + aImages[nX1,1] ) )

I will let you know once process is complete

Rao, Here is the complete code in case you need it: TRY oSql:=TOleAuto():New("ADODB.Recordset") CATCH MsgWait( "Unable to Load SQL Driver" ) RETURN (.F.) END // Set... oSql:CursorType := 1 // opendkeyset oSql:CursorLocation := 3 // local cache oSql:LockType := 3 // lock opportuni...

Hi Rao, I am getting the following error while trying to save images to MS SQL table. What am I doing wrong? ERROR: Incorrect syntax near '+'. (0x80040E14) Code: cSqlIns := [INSERT INTO asset_chart(] cSqlIns += [itemnumber,] cSqlIns += [inspcft] cSqlIns += [)] cSqlIns += [ VALUES (] cSqlIns += ['] +...

Good Day Everyone,

Does anyone have sample code that stores an image (JPG / PNG / etc.) from a directory to MS SQL table field?

Thank you in advance for your assistance!

Dear Rao,

Thank you!

Rick,

I found a Status property, however when I use it, the system errors out.

Error occurred at: 08/05/2019, 15:32:35
Error description: (DOS Error -2147352567) WINOLE/1007 Operation is not allowed when the object is closed. (0x800A0E78): ADODB.Recordset

Rick, The ERROR only occurs when the SQL statement fails to process correctly. If the SQL processes correctly but no record is updated, the ERROR catch does not work. I need to submit the SQL UPDATE statement and I need to get the response code that indicates number of records updated (should be one...

Hi Rick,

Ok, I will just use the CATCH to handle the error.

Dear Rick,

Thank you. What property of oSql will contain this response?

Hello Everyone, can someone tell what response code I would get if UPDATE succeeded and failed? I want to determine if UPDATE FAILED so I can INSERT record. TRY oSql:=TOleAuto():New("ADODB.Recordset") CATCH MsgAlert("It seems that your PC does not have MDAC installed OR MDAC is corrup...

Dear Antonio,

Thank you! I hope you are well!

Hello Everyone, We are using XML reader to process large amount XML messages. We are receiving the error below, how do I resolve this issue? /*********************************************** Application Internal Error - C:\winapps\vessel\xmlreader.exe Terminated at: 2019-06-09 08:54:10 Unrecoverable ...

Hello,

I was able to figure it out.

Sincerely,