|
[x]
Posted via EE Mobile
|
||
Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
||
| Question |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: |
// Start of DFM --------------------------------------------------------------------------------------------------
object Form1: TForm1
Left = 312
Top = 103
BorderIcons = [biSystemMenu]
BorderStyle = bsSingle
Caption = 'Form1'
ClientHeight = 377
ClientWidth = 505
Color = clBtnFace
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -11
Font.Name = 'MS Sans Serif'
Font.Style = []
OldCreateOrder = False
PixelsPerInch = 96
TextHeight = 13
object Button1: TButton
Left = 16
Top = 16
Width = 161
Height = 25
Caption = 'Test '#39'LoadFromDataSet'#39
TabOrder = 0
OnClick = Button1Click
end
object ListBox1: TListBox
Left = 192
Top = 16
Width = 297
Height = 345
ItemHeight = 13
TabOrder = 1
end
end
// Start of PAS --------------------------------------------------------------------------------------------------
unit kbmst01;
interface
uses
Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs, StdCtrls,
ADODB, DB, KbmMemTable, ActiveX;
type
TForm1 = class(TForm)
Button1: TButton;
ListBox1: TListBox;
procedure Button1Click(Sender: TObject);
private
procedure UpdateStatus(Value: String);
{ Private declarations }
public
{ Public declarations }
end;
var
Form1: TForm1;
implementation
{$R *.DFM}
procedure TForm1.Button1Click(Sender: TObject);
var
sQuery,
sAlias: String;
adoDataSet: TADODataSet;
kbmMemTable: TkbmMemTable;
begin
sQuery := 'SELECT * FROM DUMMY_TABLE';
try
CoInitialize(nil);
adoDataSet := TADODataSet.Create(Self);
adoDataSet.ConnectionString :=
'Provider=SQLOLEDB.1;' +
'Integrated Security=SSPI;' +
'Persist Security Info=False;' +
'Initial Catalog=MASTER;' +
'Data Source=localhost';
UpdateStatus('PreQuery');
adoDataSet.CursorType := ctOpenForwardOnly;
adoDataSet.CommandText := sQuery;
adoDataSet.Open;
UpdateStatus('PostQuery');
kbmMemTable := TkbmMemTable.Create(Self);
UpdateStatus('PreLoad');
kbmMemTable.LoadFromDataSet(adoDataSet, [mtcpoStructure]);
UpdateStatus('PostLoad');
UpdateStatus(Format('RecordCount (%d)', [kbmMemTable.RecordCount]));
FreeAndNil(adoDataSet);
FreeAndNil(kbmMemTable);
CoUninitialize;
except
on E:Exception do
begin
CoUninitialize;
raise Exception.Create(E.Message);
end;
end;
end;
procedure TForm1.UpdateStatus(Value: String);
begin
ListBox1.Items.BeginUpdate;
ListBox1.Items.Add(Format('[%s] %s', [FormatDateTime('hh:mm:ss:zzz', Now), Value]));
ListBox1.TopIndex := ListBox1.Items.Count - 1;
ListBox1.Items.EndUpdate;
end;
end.
// Start of SQL --------------------------------------------------------------------------------------------------
SET NOCOUNT ON
IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE [NAME] = 'DUMMY_TABLE' AND TYPE = 'U')
DROP TABLE DUMMY_TABLE
DECLARE @CREATE_TABLE VARCHAR(8000),
@COUNTER INT
SET @CREATE_TABLE = 'CREATE TABLE DUMMY_TABLE (RECORD_ID INT,'
SET @COUNTER = 0
WHILE @COUNTER < 100
BEGIN
SET @COUNTER = @COUNTER + 1
SET @CREATE_TABLE = @CREATE_TABLE + 'FIELD' + CAST(@COUNTER AS VARCHAR) + ' VARCHAR(36) DEFAULT NEWID()'
IF @COUNTER < 100
SET @CREATE_TABLE = @CREATE_TABLE + ','
ELSE
SET @CREATE_TABLE = @CREATE_TABLE + ')'
END
EXEC(@CREATE_TABLE)
SET @COUNTER = 0
WHILE @COUNTER < 2000
BEGIN
SET @COUNTER = @COUNTER + 1
INSERT INTO DUMMY_TABLE (RECORD_ID) VALUES (@COUNTER)
END
SELECT * FROM DUMMY_TABLE
SET NOCOUNT OFF
|
Advertisement
| Hall of Fame |