Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

delphi µ¼³ö³¬¹ý65536ÌõÊý¾ÝÈçºÎ´¦Àí

  ÇëÎÊ,ÈçºÎ½«100ÍòÌõ¼Ç¼һ´Îµ½µ½excelÖÐ,3Q~~
×ö¸öÅжÏÓï¾ä£¬³¬¹ý65535¼´Ð½¨Ò»¸öеÄexcel~~

ÒýÓÃ
×ö¸öÅжÏÓï¾ä£¬³¬¹ý65535¼´Ð½¨Ò»¸öеÄexcel~~

  ¿ÉÒÔÏêϸµãÂð?

excel×î¶àÖ»Ö§³Ö64kÐУ¿Õâ¸ö»¹ÕæÃ»×¢Òâ¡£¡£¡£¡£¡£¡£¡£¡£¡£
Delphi(Pascal) code:
c:=0;
q.first;
while not q.eof do
begin
inc(c);
if c>65535 then
begin
c:=1;
¹Ø±Õµ±Ç°excelÎļþ;
н¨Ò»¸öexcelÎļþ;
end;
µ¼È뵱ǰexcelÎļþ;
q.next;
end;
¹Ø±Õµ±Ç°excelÎļþ;


ÒýÓÃ
excel×î¶àÖ»Ö§³Ö64kÐУ¿Õâ¸ö»¹ÕæÃ»×¢Òâ¡£¡£¡£¡£¡£¡£¡£¡£¡£
Delphi(Pascal) codec:=0;
q.first;whilenot q.eofdobegin
  inc(c);if c>65535thenbegin
    c:=1;
    ¹Ø±Õµ±Ç°excelÎļþ;
    н¨Ò»¸öexcelÎļþ;end;
  µ¼È뵱ǰexcelÎļþ;
  q.next;end;
¹Ø±Õµ±Ç°excelÎļþ;

ºÃÏñ2007²»»áÁË.  ûÓÐ֤ʵ. ²»¹ý2000µÄÈ·Ö»Ö§³Ö65535 .

ÿ65KÐе¼³öµ½Ò»¸öExcel¿Õ°×Ò³ÖУ¬Ò»¸öExcelÎļþ¿ÉÒÔ½¨Á¢N¸ö¿Õ°×Ò³£¬Ö®ºó»¹¿ÉÒÔ½¨Á¢N¸öExcelÎļþ

  ¶àл,ÏÖÔÚ²éѯ¼¸°ÙÍòÌõÊý¾Ý,·¢ÏÖ "temporary table resource limit" ÕâÑùµÄ´íÎó,ÎÒÃÇÓõÄÊǵ¥·þÎñÆ÷,¾­ÀíÈÃÎÒÓÃolapÀ´´¦Àí,,ѧϰÖУ¬´ó¼ÒÄܲ»ÄÜÌṩһµãÕâ·½ÃæµÄÊý¾Ý°¡?

65536Ìõ¼Ç¼²»ÊÇDelphiµÄÏÞÖÆ,¶øÊÇExcelµÄÏÞÖÆ.


Ïà¹ØÎÊ´ð£º

delphi¶¯Ì¬Êý×éÈçºÎÈ¥µôÒ»¸öÔªËØ

procedure DynArrayDelete(var A;elSize:Longint;index,Count:Integer);
var
len,MaxDelete:Integer;
P:PLongint; //4 ¸ö×ֽڵij¤ÕûÐÎÖ¸Õë
begin
P:=PLongint(A);// È¡µÄ A µÄ ......

delphiÖÐselect µÄ whereºóÃæµÄid=±äÁ¿Ôõôд°¡

ÎҵijÌÐòÖÐÓÐÒ»¶Î¸üÐÂijһÌõ¼Ç¼µÄÓï¾ä£º
var
id:=integer;
begin
id:=strtoint(edit1.text);//edit1.textµÄÖµÒѾ­È¡µÃ;
...
...
...
adoQuery1.sql.add('update ¼Æ»®Çåµ¥±í set ¼Æ»®ÈÕ ......

Çë½Ì¹ØÓÚDelphiµÄÊ÷Ðοؼþ

ÇëÎÊDelphiÓÐÊ÷ÐοؼþÂð£¿
ÔõÑùʹÓã¿
Ttreeview 
 treeview.items.addchild(nil(Éϼ¶½Úµã),'°¸·¢Ê±·¢'(text));

raize ¿Ø¼þ°üÀïÃæÓУ¬csdnÓÐÏÂÔØµÄ

²é°ïÖúTTreeViewºÍTNodeÁ½¸öÀà

TTreeView ......

VC Delphi ÄÚ´æËÙ¶È±È½Ï - VC/MFC / ·Ç¼¼ÊõÀà

VC ¿ØÖÆÌ¨³ÌÐò:
#include <iostream>
using namespace std;
int main()
{
const int def_buffer = 1024 * 4;
DWORD t;
BYTE b[def_buffer];
memset(b, 0, sizeof(b));
PBYTE p;
t = GetTickC ......

delphi ±¾µØ×°ÔØÇý¶¯ - Delphi / Windows SDK/API

delphi ÊÖ¶¯×°ÔØÇý¶¯ÎļþÌáʾ£º
RROR (1058): The driver is marked as disabled (Start=4) in its service database entry.
ÊDz»ÊÇÕâ¸öÇý¶¯±ØÐèÒªÓÃINFÀ´°²×°¡£¡£ÓÃ×Ô´øµÄINFÀ´×°ÊÇÕý³£µÄ¡£ÓÃÊÖ¶¯×°ÔؾÍÌáʾÈçÉÏ¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ