[BEGINNER] Database question dbWhere

Shawn Blc shawnlivecode at gmail.com
Sun Jun 2 12:17:34 EDT 2013


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 <bonnmike at gmail.com> wrote:

> 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 <bonnmike at gmail.com> 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 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 that you are using for your
> match.
> >
> >
> > On Sun, Jun 2, 2013 at 8:19 AM, Mark Schonewille <
> > m.schonewille at economy-x-talk.com> wrote:
> >
> >> 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
> >> post here?
> >>
> >> --
> >> Best regards,
> >>
> >> Mark Schonewille
> >>
> >> Economy-x-Talk Consulting and Software Engineering
> >> Homepage: http://economy-x-talk.com
> >> Twitter: http://twitter.com/xtalkprogrammer
> >> KvK: 50277553
> >>
> >> Use Color Converter to convert CMYK, RGB, RAL, XYZ, H.Lab and other
> >> colour spaces. http://www.color-converter.com
> >>
> >> We have time for new software development projects. Contact me for a
> >> quote.
> >>
> >>
> >>
> >>
> >>
> >>
> >> On 2 jun 2013, at 13:48, Shawn Blc wrote:
> >>
> >> > 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 the form = fldOn in the database.
> >> > _______________________________________________
> >> > use-livecode mailing list
> >> > use-livecode at lists.runrev.com
> >> > Please visit this url to subscribe, unsubscribe and manage your
> >> subscription preferences:
> >> > http://lists.runrev.com/mailman/listinfo/use-livecode
> >>
> >>
> >> _______________________________________________
> >> use-livecode mailing list
> >> use-livecode at lists.runrev.com
> >> Please visit this url to subscribe, unsubscribe and manage your
> >> subscription preferences:
> >> http://lists.runrev.com/mailman/listinfo/use-livecode
> >>
> >
> >
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



More information about the Use-livecode mailing list