//StrCopy() 字符串拷贝,末位加'\0'
int StrCopy(char *t, char *s,int len)
{
int i;
for(i=0;i<len && *(s+i)!=0;i++) *(t+i)=*(s+i);
*(t+i)=0;
return i;
}
EXEC SQL SELECT c_serno, c_callee, c_voicefile INTO :nSerialNo, :vCalledId,
:vFileName FROM t_ordersong WHERE c_playtime <= sysdate AND rownum = 1
order by c_serno;
if (sqlca.sqlcode == 0) //found an order
{
StrCopy(sCallId, (char*)vCalledId.arr, vCalledId.len);
StrCopy(sVoiceFile, (char*)vFileName.arr, vFileName.len);
return 0;
}
return -1;
int StrCopy(char *t, char *s,int len)
{
int i;
for(i=0;i<len && *(s+i)!=0;i++) *(t+i)=*(s+i);
*(t+i)=0;
return i;
}
EXEC SQL SELECT c_serno, c_callee, c_voicefile INTO :nSerialNo, :vCalledId,
:vFileName FROM t_ordersong WHERE c_playtime <= sysdate AND rownum = 1
order by c_serno;
if (sqlca.sqlcode == 0) //found an order
{
StrCopy(sCallId, (char*)vCalledId.arr, vCalledId.len);
StrCopy(sVoiceFile, (char*)vFileName.arr, vFileName.len);
return 0;
}
return -1;
解决方案 »
- 关联查询sql语句
- 采用full outer join后SQL语句执行太慢,结果出不来了
- 求一算法(Oracle)
- 各位老师救命:如何写一个sql脚本,删除oracle某个用户下的所有表
- [安装问题] Oracle 9i,点击 setup.exe 后毫无反应?
- 各位大虾,我在toad里查看表或程序,只要有汉字的地方,都是问号,怎么设置阿,我的版本是8.5.3.3阿。
- 求sql. 请高手帮忙
- 请问忘掉sys口令了怎么启动数据库?
- 在Win2K下怎样安装Oracle734??急!!在线等待
- 关于字段命名问题,有行业mis数据库设计经验的请进
- 两个表中的字段名相同时如何进行多表查询
- [急救]PROCEDURE的问题。
sample.obj : error LNK2001: unresolved external symbol "void __cdecl sqlcxt(void * *,unsigned long *,struct sqlexd *,struct sqlcxp const *)" (?sqlcxt@@YAXPAPAXPAKPAUsqlexd@@PBUsqlcxp@@@Z)
Debug/AppServer.exe : fatal error LNK1120: 1 unresolved externals