发布新帖

查找

讨论 (2)0
登录或注册以继续
问题
· 九月 17, 2016

Compare time

#ObjectScript #Caché

Hello, guys.

Say I have two horologs or timestamps, how can I compare them? I know that just time1 > time2 doesn't work because it will compare them as strings which is not correct. 

6 Comments
讨论 (6)0
登录或注册以继续
问题
· 九月 15, 2016

ERROR - SQL Error '[Cache ODBC][State : S1000][Native Code 29]

#ObjectScript #SQL #Caché

I have been using the query below and it was working fine but now it's giving a SQL error. There were no changes made that could cause this to stop working. There is no Field 'APPLICATIONID' in the table.

QueueSQL=select distinct (convert(char(5),SkillsetID)+'='+Skillset) from iagentbySkillsetStat where ApplicationID > 10000
QueueMappingSQL=SELECT DISTINCT (convert(char(5),SkillsetID)+'='+Skillset), SkillsetID FROM iagentbySkillsetStat iagentbySkillsetStat WHERE (iagentbySkillsetStat.ApplicationID>10000)

DB- Intersystems Cache

Error details for the log files are below.

14/09/2016 11:20:05 a.m. > ERROR - SQL Error '[Cache ODBC][State : S1000][Native Code 29]
[C:\xlink\xlink Compiled Package\Xlink Application\Isps_Ul.exe]
[SQLCODE: <-29>:]
[Cache Error: <errdone+2^%qaqqt>]
[Details: ]
[%msg: < SQL ERROR #29: Field 'APPLICATIONID' not found in the applicable tables^select distinct ( convert ( char ( 5 ) , SkillsetID ) + :%qpar(1) + Skillset ) from iagentbySkillsetStat where ApplicationID >>]'

Thanks in advance.

6 Comments
讨论 (6)0
登录或注册以继续
问题
· 九月 14, 2016

Question: CSP Session

#CSP #Caché

Hi,

  I was set one session in user namespce (%session.Data("sup")="login User ").but i couldn't get this session(%session.Data("sup")) in  another namespace.

Cache version:cache 16

but i can acces in cache 5.02.

4 Comments
讨论 (4)0
登录或注册以继续
问题
· 八月 29, 2016

Cache 5.02 installation

#系统管理 #Caché

Hi all,

We have one doubt regarding cache 5.02 installation.

What is the difference b/w custom and standard installation in cache 5.02?

Thanks,

Sansa.

1 Comment
讨论 (1)0
登录或注册以继续