[BEGINNER] Database question dbWhere

Mike Bonner bonnmike at gmail.com
Sun Jun 2 11:04:43 EDT 2013


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
>



More information about the use-livecode mailing list