Luciano Evaristo Guerche

I have some VB6 programs which uses MAPI to send email messages and after updating to Windows XP + Outlook 2002 they stopped working due to Microsoft Outlook security prompt. As I found no way to curstomize (say which programs can and cannot send mail) or even turn it off, I just downloaded Express ClickYes - auto-click the Outlook security prompt and installed it. If you, like me, do not afford paying an employee to stay 24 hours a day, seven days a week in front a computer, just clicking the "Yes" button, then give Express ClickYes - auto-click the Outlook security prompt a try.

Q: When I try to compile the procedure below I get the error Must declare the variable '@TableType'. Can you guess why the following stored procedure does not compile?

CREATE PROCEDURE #SystemTablesAndColumns
AS
DECLARE @TableType TABLE (id int, name sysname)

INSERT INTO @TableType
(
 id,
 name
)
SELECT id,
       name
FROM sysobjects
WHERE name LIKE 'sys%'
ORDER BY name

SELECT @TableType.id AS TableID,
       @TableType.name AS TableName,
       syscolumns.colid AS ColumnID,
       syscolumns.name AS ColumnName
FROM @TableType
  INNER JOIN
     syscolumns ON @TableType.id = syscolumns.id
ORDER BY @TableType.name,
         syscolumns.name

RETURN

CREATE PROCEDURE #SystemTablesAndColumns
AS
DECLARE @TableType TABLE (id int, name sysname)

INSERT INTO @TableType
(
 id,
 name
)
SELECT id,
       name
FROM sysobjects
WHERE name LIKE 'sys%'
ORDER BY name

SELECT TableType.id AS TableID,
       TableType.name AS TableName,
       syscolumns.colid AS ColumnID,
       syscolumns.name AS ColumnName
FROM @TableType AS TableType
  INNER JOIN
     syscolumns ON TableType.id = syscolumns.id
ORDER BY TableType.name,
         syscolumns.name

RETURN

Just read Keeping Secrets Secret: Steganography with .NET, an interesting article from DevX

I have heard of Microsoft's Wallop through MSDN's Channel 9 and Randy Charles Morin and wonder what should I do to get into. If you know how, please, drop me a line.

I have a VB6 program, which uses Microsoft XML 4 and which was raising a GPF error every time I run it. Changed the program to use Microsoft XML 3 and it stopped raising the error. Lesson learnt: New versions = bugs = errors;

Just read it: http://www.livejournal.com/users/ea_spouse/
 
If you're in the software industry and you recognize this story, remember this: your employer doesn't own you nor is it your fault some project is late on schedule (there are people responsible for that, you just write software).

You work to live, you don't live to work.

JY found the most original resume I've ever seen. I immediately forwarded it around the company. If he ends up getting hired, I'll let you know. But it sure did get attention!

This is the OS I am:

Which OS are You?

[Via Scott Densmore]