Zeoslib Portal

i use ZSQLMetadata +postgresql+ mdTables when acitve but there is nothing i see SQLMonitor got " SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE (n.nspname LIKE 'pg_%') OR (n.nspname='information_schema') WHEN true THEN CASE n.nspname WHEN 'pg_catalog' THEN CAS...

tks
i did update a set id = :id where id = :old_id

so raise a error !! ha ha

how to muti update table
ex

select a.id,b.name from a,b where a.id=b.id
now i update a only
how to do !!

tks ,i will try

how do i do on connection
ALTER SESSION SET NLS_LANGUAGE= 'SIMPLIFIED CHINESE' NLS_TERRITORY= 'CHINA' NLS_CURRENCY= 'RMB' NLS_ISO_CURRENCY= 'CHINA' NLS_NUMERIC_CHARACTERS= '.,' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT= 'DD-MON-RR' NLS_DATE_LANGUAGE= 'SIMPLIFIED CHINESE' NLS_SORT= 'BINARY'

the ado and bde are all have the property 'keepconnection '


do the Tzconnection have this or will have

thank's

there are table write by another application
i can't modfiy this table use zeolib when i post or applyupdate
but can insert new

this table have prikey but why???


unicode???

this is mic ado UPDATE "LIU1" SET "OPCODE"=:V0001 WHERE "OPCODE"=:V0002 AND "ROWID"=:V0003 this is zeoxlib UPDATE LIU1 SET GOODSID=:P1 WHERE GOODSID=:P2 AND OPCODE=:P3 AND GOODSNAME IS NULL AND GOODSENGNAME IS NULL AND GOODSINVNAME IS NULL AND GOODSSHORTNAME I...