"text" Data Type In Database

[invoso.com]

I try to get data from database, but by getting data with "text" type VG shows in logs this message and data is not found.

 

085249,72 1 db About to execute a Retrieve type operation [sELECT opcja, id, opis, kolejkowanie FROM schemat WHERE id_proj=500 AND poziom1=cast('4' as text) AND poziom2 is NULL]

085249,73 1 db [get_menu_1_settings] row count=1

085249,73 1 rv add [get_menu_1_settings_RowCount]{1}

085249,73 1 db get RecordsetGetRowsMax

085249,73 1 db get 999 records. (row count=1)

085249,73 1 db update RVs

085249,73 1 ERROR 6.0.3391 Runmodule eh_DBQuerySaveDataToRV line 5940, 13:Type mismatch

 

 

 

I try too "SELECT CAST(my_var as character(255)) FROM table2 WHERE id=1" worked in pgAdmin sql query but no in VG

 

How to get "text" data from database in VG?

[SupportTeam]

You may need to use VBSCript to retrieve Text and BLOB data types in v6. Some examples showing use of VBScript to retrieve data via ADODB are shown here: http://www.voiceguide.com/vghelp/source/html/modvbs.htm

 

NB. VG v7 supports reading/writing of BLOBs. Please see: http://www.voiceguide.com/vghelp/source/html/moddbquery.htm