Hi Igor,
Thanks for the insight. I'm used to doing stored procedures for web
apps, which conditionally execute statements based on state and/or the
presence of variables. Consider this construct, which I built recently
to populate a table with URL for a web spider bot I built:
CREATE PROCEDURE AddLinkInfo
(
@ProviderName VARCHAR(200),
@LinkPath VARCHAR(200),
@LinkText VARCHAR(200)
)
AS
DECLARE @ProviderID INT
-- only store a link if it isn't already listed in the database
IF NOT EXISTS(SELECT LinkPath FROM SpiderBot WHERE LinkPath = @LinkPath)
BEGIN
-- is this a known provider? if not, add it into the DB and
then assign it's new ID
IF EXISTS(SELECT ContentProviderID FROM
SpiderBot_ContentProviders WHERE ProviderName = @ProviderName)
BEGIN
SET @ProviderID = (SELECT ContentProviderID FROM
SpiderBot_ContentProviders WHERE ProviderName = @ProviderName)
END
ELSE
BEGIN
INSERT INTO SpiderBot_ContentProviders VALUES
(@ProviderName)
SET @ProviderID = @@IDENTITY
END
-- do the main content insertion
INSERT INTO SpiderBot (ContentProviderID,LinkPath,LinkText)
VALUES (@ProviderID,@LinkPath,@LinkText)
END
GO
How would I got about re-writing something like this in SQLite? Thanks
again for your help.
Igor Tandetnik wrote:
> "Jason Salas" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
>
>> I'm used to doing lengthy T-SQL programming in SQL Server, so this is
>> kinda new to me. How does one replicate doing IF...THEN conditional
>> blocks in SQLite 3?
>>
>
> One typically doesn't. Instead, one implements complex logic in one's
> application that hosts SQLite.
>
> Igor Tandetnik
>
>
>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
