Psst.. new poll here.
[email protected] web/email now available. Want one? Go here.
Cannot use outlook/hotmail/live here to register as they blocking our mail servers. #microsoftdeez
Obey the Epel!
Paste
Pasted as Plain Text by hdghg ( 12 years ago )
CS = ("Provider=SQLOLEDB;Data Source=YT077\SQLEXPRESS;Initial Catalog=demobase;User Id=sa;Password=1234;");
con = new ComObject("ADODB.Connection");
con.ConnectionString=CS;
con.Open(CS);
// считать из таблицы Counters значения pList и pMark
CountersRead = New ComObject("ADODB.Command");
CountersRead.ActiveConnection = con;
CountersRead.CommandText = "SELECT * FROM COUNTERS WHERE TableName='PLIST' OR TableName='PMARK'";
CountersRead.CommandType = 1;
CountersWrite = New ComObject("ADODB.RecordSet");
CountersWrite = CountersRead.Execute();
while CountersWrite.EOF = 0 do
If CountersWrite.Fields("TableName").Value="PLIST" then
pListIndex = CountersWrite.Fields("Counter").Value;
endif;
If CountersWrite.Fields("TableName").Value="PMARK" then
pMarkIndex = CountersWrite.Fields("Counter").Value;
endif;
CountersWrite.MoveNext();
enddo;
Revise this Paste
Parent: 58871