On Tue, Oct 27, 2015 at 8:54 AM, Bob Sneidar
wrote:
> put "SELECT foo FROM tTableName WHERE (bar > 7) AND (animal<>'cat');" into
> tSQL
> replace "tTableName" with tTableName in tSQL -- assuming tTableName
> contains the name of a real table
>
> Looks and reads a whole lot cleaner.
>
>
If it was
What I typically do is:
put "SELECT foo FROM tTableName WHERE (bar > 7) AND (animal<>'cat');" into tSQL
replace "tTableName" with tTableName in tSQL -- assuming tTableName contains
the name of a real table
Looks and reads a whole lot cleaner.
Bob S
On Oct 26, 2015, at 13:25 , Dr. Hawkins
mail
On 10/26/2015 3:25 PM, Dr. Hawkins wrote:
There is a custom property (call it theProp) with a value like
"SELECT foo FROM " & tableName & " WHERE (bar > 7) AND (animal<>'cat');"
So those quotes and & are in the string to be evaluated.
My understanding of parsing is that the first piece shou
On Mon, Oct 26, 2015 at 9:49 AM, Bob Sneidar
wrote:
> Now I get "Abc"45"123(def)" in tTest. I'm not sure what you are expecting,
> but that is what is getting passed to value(). If you asked me to resolve
> that, I would probably toss a few errors, not to mention a few brews, back
> myself.
>
I
Now I get "Abc"45"123(def)" in tTest. I'm not sure what you are expecting, but
that is what is getting passed to value(). If you asked me to resolve that, I
would probably toss a few errors, not to mention a few brews, back myself.
Bob S
> On Oct 26, 2015, at 08:48 , Dr. Hawkins wrote:
>
>
The text I copied didn't have the quotes. I'll try again.
Bob S
On Oct 26, 2015, at 08:48 , Dr. Hawkins
mailto:doch...@gmail.com>> wrote:
put quote & "Abc" & quote & 45 & quote & "123(def)" & quote into tTest
___
use-livecode mailing list
use-livec
On Mon, Oct 26, 2015 at 8:29 AM, Bob Sneidar
wrote:
>
>
> on mouseUp
>put "Abc" & 45 & "123(def)" into tTest
>put value (tTest)
> end mouseUp
>
> tTest results in Abc45123(def) so you are trying to get the value of the
> result of a function called Abc45123() where you pass a value in a
I did
on mouseUp
put "Abc" & 45 & "123(def)" into tTest
put value (tTest)
end mouseUp
tTest results in Abc45123(def) so you are trying to get the value of the result
of a function called Abc45123() where you pass a value in a variable called
def. At run time, do you have a function Abc45
As always, put it into a variable, copy the contents of the variable to the
clipboard, either programmatically, or from the debugger, paste it into an SQL
editor, and it should show you where the error occurs.
Bob S
> On Oct 25, 2015, at 08:19 , Dr. Hawkins wrote:
>
> On Sat, Oct 24, 2015 a
On Sat, Oct 24, 2015 at 5:58 PM, Scott Rossi wrote:
> Is 123 a function? If yes, I believe you need to remove the quotes
> surrounding it.
>
Just some text. I'm trying to concatenated strings, but livecode is
looking at punctuation inside of the quoted literal.
That was a simplified version;
Is 123 a function? If yes, I believe you need to remove the quotes surrounding
it.
Regards,
Scott Rossi
Creative Director
Tactile Media UX/UI Design
> On Oct 24, 2015, at 5:46 PM, Dr. Hawkins wrote:
>
> I am finding that parentheses within strings break value()
>
> put value ("Abc" & 45 &
11 matches
Mail list logo
