Programming with dBASE - Lookuprowset Problem on saving

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Lookuprowset Problem on saving

Michael NG

2006-02-06, 3:23 am

I used one master table and set two fields's lookupsql to two tables and use
listbox to contain it. It works fine during browsing, but when I change the
value of these two fields on the fly and save, the first statement :

fmember["typeidmemb"].value = val(oCGI["typeidmemb"].righttrim())

got a error message - Invalid subscript reference

the second statement :

fmember["TITLEID"].value = val(oCGI["TITLEID"])

seems being saved but actually it generate a null value.

Any idea on this ? Thanks in advance.

Michael NG

Bruce Beacham

2006-02-28, 8:25 pm

Michael NG wrote:

> fmember["TITLEID"].value = val(oCGI["TITLEID"])

Perhaps
fmember["TITLEID"].value = val(oCGI["TITLEID"].value)

Bruce Bacham

Sponsored Links