ÇÁ·Î±×·¡¹Ö
ù ÆäÀÌÁö ·£´ý ±Û ȸ¿ø°¡ÀÔ ·Î±×ÀÎ
ºñ°ø°³ ¼Õ´Ô ¡¦ 2014-12-09 17:03:50
URL https://te31.com/rgr/view.php?id=study&no=888 ¸ð¹ÙÀÏ È­¸é
ÆÄÀÏ ÀÔÃâ·Â°ü·ÃÇÏ¿© Áú¹®µå¸³´Ï´Ù.

cdb ÆÄÀÏ(¹æ´ëÇÑ dbÆÄÀÏ)À» Àоî csv Çü½ÄÀ¸·Î º¯È¯À» ÇÏ¿´´Âµ¥
row°¡ Áõ°¡ÇÏ¿´½À´Ï´Ù. 88¸¸ row º¯È¯ ÇÏ¿´´Âµ¥ 900 row °¡·®ÀÌ Áõ°¡ÇÏ¿´½À´Ï´Ù.
¾îµð¼­ ¹®Á¦¸¦ ã¾Æ¾ßÇÒÁö °¨ÀÌ ÀâÈ÷Áö ¾Ê¾Æ¼­ ÁÖÀÇÇؾßÇÒ ºÎºÐÀ̳ª Àǽɰ¡´Â ºÎºÐ ÀÖÀ¸¸é Á¶¾ð ºÎŹµå¸³´Ï´Ù. ´«썪´Â Äڵ嵵 °°ÀÌ Ã·ºÎÇÕ´Ï´Ù.

void ConvertIntoCSV(DBF_HANDLE* phandle)
{
        BOOL ok = (phandle != NULL);
        FILE *fp;
        fp=fopen("./memo.csv", "w");

        if(ok && fp)
        {
                size_t count = dbf_getrecordcount(*phandle);
                size_t fields = dbf_getfieldcount(*phandle);
                size_t i,j;

                DBF_FIELD_INFO fieldInfo;
                for(int i=0; i<dbf_getfieldcount(*phandle); i++){
                        dbf_getfield_info(*phandle, i, &fieldInfo);
                        fprintf(fp, "%s", fieldInfo.name);
                        fprintf(fp, ",");
                }
                fprintf(fp, "\n");

                for(i=0; i<count; i++)
                {
                        char temp[60] ="";
                        dbf_setposition(*phandle, i);
                        for(j=0; j<fields; j++)
                        {
                                dbf_getfield(*phandle, dbf_getfieldptr(*phandle, j), temp, sizeof(temp), DBF_DATA_TYPE_ANY);
                                fprintf(fp, "%s", temp);
                                fprintf(fp, ",");
                        }
                        fprintf(fp, "\n");
                }
                printf("csv ÆÄÀÏ »ý¼º ¿Ï·á\n");
        }
        fclose(fp);
}

Àâ´ã | 1379¸íÀÌ Àоú¾î¿ä. 3.142.53.216

0
1 ºñ°ø°³ ¼Õ´Ô ¡¦ 2014-12-09 17:20:39
csv·Î º¯È¯ ÇßÀ¸¸é ´Ù½Ã db¿¡ ¹Ð¾î ³Ö°í ã´Â°Ô ÈξÀ ºü¸£°Ú³×¿ä
2 ºñ°ø°³ ¼Õ´Ô ¡¦ 2014-12-09 19:08:42
¿øº»db¸¦ csv export ÇÑ´Ù.
»õdb¸¦ csv export ÇÑ´Ù.
µÎ°³ÀÇ °Å´ëÇÑ ÅؽºÆ®ÆÄÀÏÀ» diff Çغ»´Ù.

??????

PROFIT!!
3 ºñ°ø°³ ¼Õ´Ô ¡¦ 2014-12-09 19:11:05
¾Æ´Ï¸é Áõ°¡ÇÑ db¿¡¼­ primary Å°°ªÀ¸·Î ¿øº»db¿¡ Äõ¸® Çغ¸´Â ½ºÅ©¸³Æ®¸¦ ¸¸µå½Ã´ø°¡.. ¾²·¹±â row°¡ »ý°å´Ù¸é ¿À·ù°¡ ³¯°ÍÀÌ°í pk´Â Ư¼º»ó Áߺ¹À̾ȵǴϱî.. pk³ª À妽º ¾ø´Âdb¸é °ñ·ëÇϱä ÇÒÅÙµ¥ ±×¸¸ÇÑ »çÀÌÁî ½ºÅ°¸¶¿¡ pk´Ï À妽º¸¦ ¾È°É¾îµ×À»¸®µµ ¾øÀ¸´Ï.. Çà¿îÀ» º÷´Ï´Ù
4 ºñ°ø°³ ¼Õ´Ô ¡¦ 2014-12-09 19:51:10
db°ª¿¡ \n ÀÌ µé¾îÀÖ¾ú´Ù´øÁö.
5 ºñ°ø°³ ¼Õ´Ô ¡¦ 2014-12-10 11:24:58
dbf_getfield()°¡ ¶óÀ̺귯¸®¿¡ ¿ø·¡ Æ÷ÇԵȰǰ¡¿ä, ¾Æ´Ï¸é Á÷Á¢ ¸¸µå½Å°Ç°¡¿ä?

µ¥ÀÌÅ͸¦ ¾î¶»°Ô ÀÐ°í ºÐ¸®Çس»´Â°ÇÁö...
6 ºñ°ø°³ ¼Õ´Ô ¡¦ 2014-12-11 00:03:13
´ä4´ë·Î °ª¿¡ \nÀÌ ÀÖ´Â °Ç ¾Æ´ÑÁö üũºÎÅÍ Çϼž߰ڳ׿©
8 ºñ°ø°³ ¼Õ´Ô ¡¦ 2014-12-11 22:46:25
µ¥ÀÌÅÍ¿¡ \n »ðÀԵǼ­ ±×·±ÀûÀÌ ÀÖ¾ú´Âµ¥
°¢ °ª¸¶´Ù trim ÇØÁÖ¸é µÉ°Å°°±âµµÇÏ°í...-_-;
´ñ±ÛÀ» ÀÛ¼ºÇÏ½Ç ¼ö ¾ø½À´Ï´Ù.
(±ÇÇÑÀÌ ¾ø´Â ȸ¿ø·¹º§)
¸ñ·ÏÀ¸·Î
¡â ÀÌÀü±Û: ¾Èµå·ÎÀÌµå ½ºÆ©µð¿À 1.0 ³ª¿Ô½À´Ï´Ù. [5]
¡ä ´ÙÀ½±Û: c++¿À·ù . .Àâ¾ÆÁÖ½Ç»Ó ÀÖÀ¸½Å°¡¿ä [5]
ÀÌ¿ë¾à°ü | ±¤°í/Á¦ÈÞ | °³ÀÎÁ¤º¸Ãë±Þ¹æħ | ¹®ÀÇ/½Å°í | ¸ð¹ÙÀÏ TE31 | ¼­¹ö ºÎÇÏ : 6%
½Ç½Ã°£ Issue Ä¿¹Â´ÏƼ TE31 [¾ËÁö·Õ] ¨Ï 2002-2024
TOP arrow_upward