[BEGINNER] Database question dbWhere

Mike Bonner bonnmike at gmail.com
Sun Jun 2 11:05:53 EDT 2013


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
>>
>
>



More information about the Use-livecode mailing list