-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
You can also use the revNumberOfRecords function to this end.
On Dec 29, 2004, at 1:59 PM, Trevor DeVore wrote:
On Dec 29, 2004, at 10:02 AM, docmann wrote:
You folks are fantastic! It works exactly as intended now. :)
Geesh, I still don't know how I go
On Dec 29, 2004, at 10:02 AM, docmann wrote:
You folks are fantastic! It works exactly as intended now. :)
Geesh, I still don't know how I got so far off track in attempting
this and clearly need
to revisit the documentation. :(
On a side note, I intentionally entered data that I knew did not
exis
You folks are fantastic! It works exactly as intended now. :)
Geesh, I still don't know how I got so far off track in attempting
this and clearly need
to revisit the documentation. :(
On a side note, I intentionally entered data that I knew did not
exist, just to see what would happen and got a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Oops, yeah, I missed the quotes thing in my example here, too:
on mouseUp
put field "mySearch" into x
replace "'" with "''" in x
put revQueryDatabase(dbID, field "CurrSQL" & " '" & x & "'") into q
if q is not a number then
answer error "Data
On Dec 29, 2004, at 8:09 AM, docmann wrote:
RevButton Named "Search"
on mouseUp
put field "CurrSQL" into tSQLStringPartOne
put field "mySearch" into tSQLStringPartTwo
put tSQLStringPartOne & " " & tSQLStringPartTwo into tSQLQuery
get revDataFromQuery(,,dbID,tSQLQuery,"tMyResults")
end mouse
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
revDataFromQuery does not use the revDatabaseColumnNamed function --
that works quite differently. You want the revQueryDatabase function
instead.
Try this:
on mouseUp
put revQueryDatabase(dbID, field "CurrSQL" & field "mySearch") into q
if q is
Hello folks,
I've been trying to resolve a problem on my own off and on for several
days and just can't seem to get my head wrapped around it all. Even
worse, now with so many attempts and errors under my belt, I have
finally reached the point of almost total confusion. :(
Let's say that I have a
