Expected value

[forskare]

This script is expecting a value. If I ' out the last 3 lines, the name prompt will appear. As soon as I add the 4th line, then the error message expected value appears.

What is the expected value and what do I need to change to make this work?

t = table.open("Acctitems")
vstring = ui_get_text("Retrieve a Name","Enter a Name")
vlen = len(vstring)
query.filter = "left(acctitems->name,vlen) = vstring
ndx = t.query_create()
vrecords = ndx.records_get()


Thanks much,

kenn

[Stan Mathews]

RE: Expected value

query.filter = "left(acctitems->name,vlen) = vstring"

[forskare]

RE: Expected value

Hey Stan,

Got any lense cleaner for my glasses?

Now it's telling me that the filter expression is not logical.

Thanks,

kenn

[Stan Mathews]

RE: Expected value

Ken,

You shouldn't need the "acctitems->" but it shouldn't hurt. You shouldn't need "var->vstring", but it couldn't hurt to try.

Try the interactive tab on the code builder, past in one line at a time from your script, see what happens, i.e.,

t = table.open("Acctitems")
vstring = ui_get_text("Retrieve a Name","Enter a Name")

Then type ? vstring

vlen = len(vstring)

? vlen


test = "left(acctitems->name,vlen) = vstring"

? test
.........

[forskare]

RE: Expected value

Stan,

I may have a problem with the interactive window. When I click on Code, the word 'check' is greyed out. Does this have to be activated somehow? Also, the debugger states 'No Source Available'.

Thanks,

kenn

[Tom Cone Jr]

RE: Expected value

From Code tab of control panel:

Select View
Select Code Editor
Select Interactive Tab

[forskare]

RE: Expected value

Thanks, Tom. I was going at it a bit backwards.

kenn

[forskare]

RE: Expected value

Guess I was wrong. Following you directions, I pasted the code in the interactive tab, clicked on Code and everything is greyed out. The code check is not available.

kenn

[Stan Mathews]

RE: Expected value

YOu can't use code check in interactive mode. Paste in a line, position the cursor in that line, hit the enter key. This makes Alpha attempt to execute the statement.

If you get no error, the line is ok. If you want to see a result, use ?, as in

result = left(acctitems->name,vlen)

? result

Alpha then displays the value returned.

[forskare]

RE: Expected value

My Code editor seems to be out of service. No matter what I try the code menu is greyed out (entire column). (The Script tab is OK)

Perhaps someone could try this in their code editor, substitute the table and field names and see what happens?

t = table.open("Acctitems")
vstring = ui_get_text("Retrieve a Name","Enter a Name")
vlen = len(vstring)
query.filter = "left(acctitems->name,vlen) = vstring
ndx = t.query_create()
vrecords = ndx.records_get()

records_get is not the name of an index, is it?

Thanks,

kenn

[forskare]

RE: Expected value

Here are the errors; which translates to?

ndx = t.query_create()
ERROR: filter expression not logical

vrecords = ndx.name()
ERROR: Argument is incorrect data type

Thanks much,

kenn

[Peter.Wayne]

RE: Expected value

try this, it should work:

t = table.open("Acctitems")
vstring = ui_get_text("Retrieve a Name","Enter a Name")
vlen = alltrim(str(len(vstring)))
query.filter = "left(name,"+vlen+")='"+vstring+"'"
query.options=""
query.order=""
ndx = t.query_create()
vrecords = ndx.records_get()

[Peter.Wayne]

RE: Expected value

this might be a little clearer:


query.filter = "left(name,"+vlen+")=' "+vstring+" ' "

i separated the single and double quotes to make it
more obvious.

[forskare]

RE: Expected value

Hi Dr. Wayne,

I pasted your version as follows:

vstring = ui_get_text("Retrieve a Name","Enter a Name")
vlen = alltrim(str(len(vstring)))
query.filter = "left(name,"+vlen+")=' "+vstring+" ' "
query.options=""
query.order=""
ndx = t.query_create()
vrecords = ndx.records_get()

This time there are no errors but there are also no results. The sought after name does not come into view. Entering a few letters and a wild card * is OK? Anyhow, I tried entering a name w/and w/o the wild card, typing the complete name.

Thanks,

kenn