On Sep 19, 2009, at 3:45 PM, Ed Leafe wrote:
>> The problem we're having is with the scope. The traceback says:
>> "invalid syntax" pointing to the tubes.run_no=Thisrun line. What's
>> proper syntax for the scope argument?
>
> There are a couple of things wrong. First, since you are testing
> equality, you need the double-equals, not the single equals. Second,
> since the scope expression will be evaluated in a method in which the
> name 'ThisRun' is most likely not defined, you need to supply the
> actual value. Try using something like:
>
> bizTubes.replace("result", "Invalid", scope="tubes.run_no==%s" %
> ThisRun)
OK, I've had a chance to dig into the code, and I think I know what
your problem is. Since the replace is happening at the data set level,
the scope needs to be the column name *only*, not the table.column
format. So try this:
bizTubes.replace("result", "Invalid", scope="run_no==%s" % ThisRun)
BTW, I've also notice that the code in replace is very slow and
inefficient. I'm looking into improving it now.
-- Ed Leafe
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/[email protected]
