VB 2015 / Pervasive SQL (Actian Zen (PSQL))

[Bre-x]

my code runs fine until it hits the following cmd

update UNIDB.seq_main set wo_note='HUSKY V1 INSPECTION AS PER SECTION 8.2 OF HUSKY EDS-31-15:

PERFORM 100% VISUAL INSPECTION:

- CASTINGS AS PER MSS-SP55

- FORGINGS AS PER ASTM 182 SECTION 12 (ASTM A961) ?

-

VALVES WITH WELD ON FLANGES OR ANY PRESSURE CONTAINING WELD:

- 10% OF ANY BUTTWELDED JOINTS OR ANY ALLOY WELDS

(P4, P5, P6, P7, P9) SHALL BE 100% RT EXAMINED AS

PER ASME SECTION V 2

- 10% OF ANY FILLET, SOCKET OR FILLET WELD SHALL BE 100%

MPI or LPI EXAMINED AS PER ASME SECTION V ARTICLE 6 (LPI)

OR ARTICLE 7 (MPI)

**ACCEPTANCE CRITERIA SHALL BE PER ASME B31.3 PARA. 341.2**' where seq_id=392;

If I copy and paste to Pervasive Control Panel. It work

Is there a character that is creating the issue?

An unhandled exception of type 'Pervasive.Data.SqlClient.PsqlException' occurred in Pervasive.Data.SqlClient.dll

Code :

If the_inst.Length = 0 Then
'Console.WriteLine(the_inst.Length)
'Nothing
Else
erp_cmd.CommandText = "update UNIDB.seq_main set wo_note='" & the_inst.Replace("'", "''") & "' where seq_id=" & seq_id & ";"
erp_cmd.ExecuteNonQuery()
End If

Please help !!!

John

Continue reading...