realbasic-nug
[Top] [All Lists]

More DB Query questions

To: REALbasic NUG <realbasic-nug at lists dot realsoftware dot com>
Subject: More DB Query questions
From: Dave Shirk <dave at pamlicosounds dot com>
Date: Wed, 19 Sep 2007 18:22:05 -0400
Delivered-to: listarchive at realsoftware dot com
Delivered-to: realbasic-nug at lists dot realsoftware dot com
Below is a Select that works:

   s = "select hamlog.entrydate, hamlog.frequency, hamlog.mode,  
hamlog.callsign, "+_
   "callsign.name, callsign.country from hamlog, callsign where "+_
   "callsign.call = hamlog.callsign"

However, I need to use the LIKE clause somehow or someway,
and have not been able to get it to work.

Conceptually, from above:

callsign.call LIKE hamlog.callsign%

Any pointers?

Thanks as always,

Dave Shirk
Oriental, NC


_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>


<Prev in Thread] Current Thread [Next in Thread>