General information
Category:
Coding, syntax & commands
I guess I am not making myself clear.
I have a data environment in Visual Basic called dbfDataEnv. I can open the designer and look at the tables, browse them, see the contents of the fields.
It is connected to my form via dbfConn.
My vfp database, projdbc, contains a table, cmdlist, with a field, cmnd.
I would like to place the field value in a private variable, tmpcmd, so that I can then do some manipulations on that variable. Neither the field or the variable are associated with any objects on the form. The things I want to do with the variable would be completely behind the scenes, unknown to the user.
I define tmpcmnd in the form load section with the following statement:
dim tmpcmnd as string
I just can't seem to get the syntax right on this to place the value of the field cmnd located in table cmndlist into the variable tmpcmnd.
I have tried syntax such as the following:
tmpcmnd = dbfDataEnv.dbfConn.cmdlist.fields("cmnd")
or
tmpcmnd = dbfDataEnv.dbfConn.cmdlist.cmnd
Neither works.
I have also tried:
set tmpcmnd = dbfDataEnv.dbfConn.cmndlist.cmnd
That doesn't work either.
I have combed the texts available to me. There are no examples that seem to fit my situation as most are pulling the from cursors created by sql statements as a command in the dataenvironment rather than looking directly into an existing table.
Any help would be appreciated. Thanks.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only