Results 1 to 2 of 2

Thread: Data Control and the '!'?

  1. #1

    Thread Starter
    Lively Member
    Join Date
    May 1999
    Location
    flanders, nj 07836
    Posts
    110

    Talking

    WhaZzZZZzzzzZup fellow progy's

    What's up with this ! directive? I see it however I do not seem to be able to master it

    Aparently you can directly access fields via the header/field title of the current record using !?
    Can this be done with the data control? I tried some combos and I can't find souce because searching by '!' anywhere does no good

    This is what I'm trying..
    iCust_Num = customerDBF.recordset.fields!CUST_NUM

    ps. i'm working with a foxpro db.. hence I have the data control to do most of the opening work for me..

    Thanks guys.

  2. #2
    Your Ad Here! Edneeis's Avatar
    Join Date
    Feb 2000
    Location
    Moreno Valley, CA (SoCal)
    Posts
    7,339
    You do it from the recordset to return the field.
    ADO!PtId=43
    would set the PtId field to 43 in the ADO recordset
    Or x=ADO!PtId would make x equal the field value

    Using a data environment it would look like:

    dataE.tblPatients!PtId=43
    And so on and so forth hopefully that will help you

    You can also use:

    Msgbox Data1.Recordset("PtId")
    To get the value

Posting Permissions

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



Click Here to Expand Forum to Full Width