Re: Replace in Vars's

[hershrev]

I cleared all Var.'s Local and Global and now it works properly.
Thanks to all . hershrev
By the way this the basic recipe for edit SQL for not connected fields.
put these scripts in your card or stack

on openField
  put the text of the selectedField into lOldText
end openField
on closeField
  if gAction = "Edit"
  then
    put the name of the selectedField into lModifyFieldName
    put the text of the selectedField into lFieldText
    delete   word 1 of lModifyFieldName
    delete char 1 of word 1 of lModifyFieldName
    delete char -1 of word 1 of lModifyFieldName
    if lEquery contains lModifyFieldName
    then
      if lOldText <> lFieldText
      then
        replace  lOldText  with lFieldText in lEquery
      end if
    else
      put lModifyFieldName &&"="&"'"& the Text of the selectedField 
&"',"& space after lEquery
    end if
  end if
  put lEquery into gtest
end closeField

on go
  put "UPDATE databaseName&&"SET"&&lEquery&&"WHERE text = text"
end go
 in your button put
on mouseUp
  go
end mouseUp
and comments would be appreciated (even critics)
Thanks hershrev
On Thursday, February 26, 2004, at 05:57 PM, Dar Scott wrote:

On Thursday, February 26, 2004, at 03:31 PM, hershrev wrote:

 I need to replace oneVar with anotherVar in athirdVar  ?
Do you meant replacing all substrings equal to the value of oneVar 
with the value of anotherVar in some variable athirdVar?

   replace oneVar with anotherVar in athirdVar
compiler complains.

This works OK at my house with handler local vars.

Typo?  It should be "with" and not "wiht".

Sometimes a weird character shows up in the script and breaks 
compiling.  Try replacing [hee hee] the entire line.

If that fails, let us know the compiling error.

Dar Scott

_______________________________________________
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution