发布于 2005-07-05 10:53:56
0楼
不好意思,斑竹大哥,我不太明白您说的这个应该怎么加,下面是动作的源程序
有select关键字的是 TLG_IO_BACKUP_SELECT ibs;这一行
您说加一个Order By T该怎么写?
谢谢,麻烦您了
void ActionForExportingArchive (LPTSTR lpszArchivNameReturn, LPTSTR lpszVariablenName , DWORD dwNumberOfRecords)
{
BOOL fRet;
int iTlgCon = 0;
CMN_ERROR Error;
char szProj[MAX_PATH];
char szFile[MAX_PATH];
LPTSTR lpszArchivName = "PDE#HD#ZK_ProcessValueArchive_04#G64i_ex_tlg_04";
char szFileName[MAX_PATH] = "";
LPTSTR lpszFileName;
TLG_IO_BACKUP_SELECT ibs;
DWORD dwSize;
time_t Time;
struct tm* TimeStruct;
int nPathLen,nFileLen;
time(&Time);
TimeStruct = localtime(&Time);
DMGetRuntimeProject( szProj, MAX_PATH, &Error);
nPathLen=strlen(szProj);
nFileLen=strlen((strrchr(szProj,'\\')+1));
strncat(szFile,szProj,nPathLen-nFileLen);
sprintf(szFileName,"%s%s",szFile,"ArchiveBackUp.CSV");
lpszFileName=&szFileName[0];
ibs.sysFrom.wYear = 1997;
ibs.sysFrom.wMonth = 1;
ibs.sysFrom.wDay = 1;
ibs.sysFrom.wHour = 0;
ibs.sysFrom.wMinute = 0;
ibs.sysFrom.wSecond = 0;
ibs.sysTo.wYear = (WORD)(TimeStruct->tm_year+1900);
ibs.sysTo.wMonth = (WORD)(TimeStruct->tm_mon+1);
ibs.sysTo.wDay = (WORD)(TimeStruct->tm_mday);
ibs.sysTo.wHour = (WORD)(TimeStruct->tm_hour);
ibs.sysTo.wMinute = (WORD)(TimeStruct->tm_min);
ibs.sysTo.wSecond = (WORD)(TimeStruct->tm_sec);
fRet = TLGConnect( NULL, &Error );
if (fRet==FALSE) printf("Error in TLGConect(...)\r\n");
fRet=TLGGetBackupSize (lpszArchivName,&dwSize,&ibs,TLG_BACKUP_EVACUATE,TLG_BAKFMT_CSV,&Error);
if (fRet==FALSE) printf("Error in TLGGetBackupSize(...) [%s]\r\n",Error.szErrorText);
else SetTagWord("U16i_ex_tlg_00",(WORD)dwSize);
printf("executedr\n");
fRet=TLGBackup (lpszArchivName,lpszFileName,&ibs,TLG_BACKUP_EXPORT,TLG_BAKFMT_CSV,&Error);
if (fRet==FALSE) printf("Error in TLGBackup(...) [%s]\r\n",Error.szErrorText);
else SetTagBit("BINi_ex_tlg_09",TRUE);
TLGDisconnect( NULL );
}