Hope its possible

[lashwarj]

I am trying to get my listbox to dump new values without deleteing the values already in the system. The user opens a form and a list box is populated with values, the user then can add new values, I wanted to be able to run a test and dump the values not already in the system when the user saves. My code below is giving me a nesting error.




WITH ThisForm.Approval_Name_Info_List
SET DECIMALS TO 0
FOR indx = 1 to .ListCount
SELECT pm_lk_permit_name
M.KEY_ID = (Vpm_id)
M.LINK_TYPE = .ListItem(.IndextoItemID(indx), 2)
M.NA_ID = VAL(.ListItem(.IndexToItemID(indx), 3))
M.KEY_TYPE ='pm'
INSERT INTO pm_lk_permit_name (na_id, key_id, link_type, key_type);
SELECT na_id, key_id, link_type, key_type FROM MEMVAR ;
WHERE MEMVAR.NA_ID <> pm_lk_permit_name.na_id AND MEMVAR.LINK_TYPE <> pm_lk_permit_name.link_type ;

 

[GriffMG]

Hi,

I don't know about what you're tryin to do, but you don't have a closing

next

Regards

Griff
Keep [Smile]ing

 

[lashwarj]

I have my list box dumping to my memvar, then from there i am dumping to a table, I wanted to accomplish that but throw a where clause in the works. If you look in the help and search for insert into it shows how you can do a where, but mine is generating a nesting error

 

[jimstarr]

I don't see ENDWITH or ENDFOR in your code.

Jim