How to change only the "marked records" table and not all with the same variable.

#1 · December 14, 2021, 10:20 pm

I working with the Neo DB Pro plugin

How to change the string (see picture) "Next Start" but only the "marked record" table and not all with the same variable.

Uploaded files:

You need to login to have access to uploads.

#2 · December 14, 2021, 10:30 pm

dbpStrReplace "Start" "StartTable" "State" "[Start.StartTable.State]" "Next Start"

I tried this but it change all the records table called "State" see picture

#3 · December 15, 2021, 2:09 am

@simon-lundin

dbpStrReplace "Start" "StartTable" "State" "[Start.StartTable.State]" "Next Start"
I tried this but it change all the records table called "State" see picture

I think the problem arises when you try to use a database field syntax (which is for the current record) as your source string.

Please read this Help file section ... https://neodbprohelp.visualneo.com/WorkingwithData.html ... to get a better understanding of how the values in these special variables are automatically populated as you navigate from record to record.

Try this instead ...

SetVar "[desiredSource]" "Next End"
dbpStrReplace "Start" "StartTable" "State" "[desiredSource]" "Next Start"

If you want [desiredSource] to be dynamic e.g. value in current record, try this ...

SetVar "[desiredSource]" "[Start.StartTable.State]"
dbpStrReplace "Start" "StartTable" "State" "[desiredSource]" "Next Start"

Simon Lundin has reacted to this post.

How to change only the "marked records" table and not all with the same variable. - Forum

How to change only the "marked records" table and not all with the same variable.