Select field dynamically

Scriptcase 9 General
#1

Hi,
Is it possible to change dynamically the lookup setting of a field for a select field?
See my lookup setting

image
image757Ă—386 9.3 KB

For example, i would like a select when i am in insert mode and an other one when i am in update/delete mode

Thanks
Guy
v9.6.014

#2

Hi
you can change where clause (onScriptIni)

if (empty({sc_where_current}))
{
sc_select_where(add) = " where cust_id = “.$usr_num.”";
}

I hope it helps

#3

Hi,
It’s for a select in lookup setting in field not for the application
Thanks
Guy

#4

In this case I think you can use global variables like this
select [field1], [field2],…from [table]

1 Like
#5

Good idea. works fine.
Thanks
Guy