meaning if you want to find all records where (material type = wood and name = plywood) or (material type = steel and name = stainless" then you are going to have to break the array into sub parts. that would be very heavy on the database, the other option is if you are only looking for Wood - Plywood and not any kind of wood, then you could just splice the strings together just as the sql does for the list i.e.
local stringvar FullName := {table.materialtype} & " - " & {table.materialname};
fullname in {?PSampleType}
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 06 Feb 2013 at 12:04pm
I am not sure how to split something that is already an array ans use it in the select statement and you cannot use LIKE or instr() on it.
Are you stuck with the concantenated field or can you create two different params to choose the fields as seperate options? or can you just create one static list that allows you to select each type seperately?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
lol, Didn't think of it being an array.
