Re: [BEGINNER] Database question dbWhere

2013-06-02 Thread Shawn Blc
Mike, Thank you that's what I'm looking for, unfortunately it's not working though. I'll post to Andre's forum. On Sun, Jun 2, 2013 at 10:05 AM, Mike Bonner wrote: > Oh, and you would get a better response by posting to the dbLib forum. > http://andregarzia.com/forum/ > > > On Sun, Jun 2, 201

Re: [BEGINNER] Database question dbWhere

2013-06-02 Thread Mike Bonner
Oh, and you would get a better response by posting to the dbLib forum. http://andregarzia.com/forum/ On Sun, Jun 2, 2013 at 9:04 AM, Mike Bonner wrote: > dbWhere is part of dbLib (nice library) > > fldOn is an actual field name on a form that you have set up? > > If thats the case it is probabl

Re: [BEGINNER] Database question dbWhere

2013-06-02 Thread Mike Bonner
dbWhere is part of dbLib (nice library) fldOn is an actual field name on a form that you have set up? If thats the case it is probably dbWhere "fldOn", field "fldOn" that you need. so, "fldOn" would be the column name from your table that you are checking and field "fldOn" would contain the text

Re: [BEGINNER] Database question dbWhere

2013-06-02 Thread Mark Schonewille
Hi Shawn, I'm not sure what you're asking. Are you using someone's database library? Which library exactly? What does dbWhere do according to the documentation of the library? Don't you need to connect to the database first, or did you do that already? Are you getting any errors that you can po

[BEGINNER] Database question dbWhere

2013-06-02 Thread Shawn Blc
I have this: on mouseUP put "1" into tDataA["fldStatus"] dbWhere "fldOn", fldOn -- fldOn should equal fldOn in the database put dbUpdate ("contacts", tDataA) into tResult end mouseUP Basically what I want is to make sure that in the dbWhere statement that fldOn from t