need some help with coding...i want to be able to search my table first off...i want to be able to update the table, ONLY if the record IS NOT ALREADY THERE. i dont know if a CASE command will work here or not....please help.
You can't UPDATE the table if the records are not there, but you could INSERT them.
Can you post some data and want you want to do? I think this is not a difficult job, but who knows
Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP
INSERT INTO "ripedata" (matteridstring)
select distinct
f.matteridstring
from contacts c, parties p, fileinfo f, listbox l, events e
where
c.contactid = p.contactid and
f.fileno = p.fileno and
f.filetype = l.id and
e.fileno = f.fileno and
f.isactive = 1 and
e.title like '%Converted to LL%' and
e.date >= '01/01/2007' and
f.matteridstring is not null
this is what i thought would work but isnt quite it....i did some research and thought maybe a CASE command might work somehow, but im not sure....
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.