[sqlite] User defined functions and SQL Expressions

[brettg]

Hello.  I've written a UDF named ENCRYPT.  I want to do something like this:

  UPDATE Employees SET EncryptedName = ENCRYPT(LastName + ', ' + FirstName)

The UDF gets called, but not with my data - rather something like "0.0".  Kind
of weird.  Does Sqlite handle SQL expressions inside the parentheses?  I also
tried this but without success:

  UPDATE Employees SET EncryptedName = ENCRYPT(LastName) + ', ' +
ENCRYPT(FirstName)

Thx
-brett





----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.



-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------