EOF and BOF Referral link

Results 1 to 2 of 2

Thread: EOF and BOF Referral link

  1. #1
    Join Date
    Dec 1969

    Default EOF and BOF Referral link

    Please send me a link of where I can learn about BOF and EOF because I really need to understand them

  2. #2
    Join Date
    Dec 1969

    Default RE: EOF and BOF Referral link

    There is really not much to understand.<BR><BR>You can ignore BOF as it is of almost no use, and as for EOF, it simply stands for End Of File.<BR><BR>Think of your recordset as being like a pack of cards. As you deal out the cards (step through the recordset), you mentally check to see if there is another one left to carry on dealing out. If there are no more cards, EOF will be true.<BR><BR>These lines of code simply step through a recordset (like dealing the cards out) until EOF is true, and then stops.<BR><BR>Set Myrs = Conn.Execute("Select * From MyTable")<BR>Do while not Myrs.EOF<BR>Response.Write Myrs("MyField")<BR>Myrs.MoveNext<BR>Loop<BR><BR>He re is a link to MS<BR>http://msdn.microsoft.com/library/en-us/off2000/html/acproBOFX.asp

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts