good day forum.
excuse me, I create new thread in bugs.
I have database the other system CRM, and use data for create form and grid query view data.
the problem the connect build sql wizard not work conect table, the field type ntext.
i create code sc_lockup the table. and work, i like use wizard, can’t conect to table.
$check_sql =“SELECT REFID AS ITEMID,
LANGUAGEID,
SHORTTEXT AS DESCRIPCION,
cast(PRODUCTTEXT as text),cast(PRODUCTSUMMARY as text)”
. " FROM dbo.ECPPRESENTATION A "
. “WHERE (DATAAREAID = N’DPM’) AND (LANGUAGEID = N’es’) AND”
." REFID = ‘".{Referencia}."’";
//echo $check_sql;
sc_lookup(rs, $check_sql);
if (isset({rs[0][0]})) // Row found
{
{DESCRIPTION} ={rs[0][3]};
//{DESCRIPTION} =ereg_replace(’[^ A-Za-z0-9_-??]’, ‘’, {rs[0][3]});
}
else // No row found
{
{DESCRIPTION} ="…";
}
this message not use CAST. “Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier.”