Re[2]: [indopb] UPDATEBLOB Gagal

sandy Wed, 24 Oct 2007 00:39:17 -0700

mudah-mudahan ada hubungannya. di pb 9.02 atau yg lebih baru bugs ini udah dibenerin.

kayaknya masalahnya muncul ketika :is_id nya ketemu null

coba aja cek dulu pakai debug, is_idnya null gak atau cek pakai isnull()

ini ebf dari sybase:

Change Request #: 370051 Priority: 2

Product Name: PB Enterprise OS: Microsoft Windows
Product Component: DW - Runtime

Fixed in Version #: PB 9.0.2 EBF_7578

Description:

When Empty String Is Null is checked for a datawindow

column, the following error will result when you delete the values in that column

and then update it:

Error 257 (rc -1) : SQLSTATE = 42000

Microsoft OLE DB Provider for SQL Server

Implicit conversion from data type text to nvarchar is not allowed. Use the CONVERT function to run this query.

Problem only happens when Emptry String Is Null is checked for a column. The column is

defined to allow nulls.

In PB 8.0.4, the error happens on varchar and nvarchar columns. In PB 9, the error

only happens on nvarchar. In PB 10, the error only happens a varchar column.

The update to the database is being done thru a stored procedure.

Description: Fixed in Version #: PB 9.0.2 EBF_7578 Microsoft Windows 2000

Terimakasih atas responnya.

Pesan erorrnya:

SQLDBCODEnya 156

SQLSTATE = 42000 Microsoft OLE DB Provider for SQL Server Incorrect syntax near the keyword 'WHERE'.

type data blob

statement yang digunakan:

UPDATEBLOB SERIFIKAT

SET IMAGE_DATA = :lbl_data

WHERE SERTIFIKATID = :is_id

USING gtr_blob ;

Salam,

Pada tanggal 24/10/07, sandy <[EMAIL PROTECTED]> menulis:

pesan errornya apa. error numbernya.

type data yg dipakai apa.

statement yg digunakan apa.

regard

Sebelumnya saya mohon maaf lahir batin untuk semua member indopb...

Selanjutnya, saya punya permasalahan mengenai statement UPDATEBLOB untuk menyimpan data binary ke database MS SQLServer 2000. Ketika menggunakan PB7 dengan menggunakan koneksi native interface MS SQL Server tidak ada masalah. Tetapi ketika mau saya upgrade ke PB10 dengan mengunakan interface OLE DB muncul masalah. Statement UPDATEBLOBnya selalu error. Mohon saran dan pencerahannya ? Terimakasih.

Salam,

Telaga

Best regards,

sandy mailto:sandy@infotech.co.id

Best regards,

sandy mailto:[EMAIL PROTECTED]

__._,_.___

----------------------------------------------- IndoPB - Indonesia PB User Group An Indonesian PowerBuilder User Group's Event 2nd PowerBuilder Update Rumah Sakit Jantung Harapan Kita 26/27 August 2006 To Register : http://groups.yahoo.com/group/indopb/database?method=addRecord&tbl=4

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___

Re[2]: [indopb] UPDATEBLOB Gagal

Kirim email ke