Search results for query: *

From looking at your code, I agree, you can not close form number one before you create form number two. When form number 1 is closed, you have nothing anywhere. You should do something like this: //*** THIS WILL CREATE YOUR FORM 2. Application.CreateForm(TForm2,Form2); //*** THIS WILL OPEN...

Oops, silly mistake. Got it.

Oops, I need one more thing on here. What if I have something like this: SELECT fLastName, fFirstName, fDateCreated, CASE fDateCreated WHEN BETWEEN '1/1/2001' AND '1/1/2002' THEN 1 ELSE CASE fDateCreated WHEN > '1/1/2002' then 2 else 3 I can't get this working

Jim, Thanks a million. That looks like it is exactly what I want to do. Josh

I have a Stored procedure that I want to have an 'if' statement in my SELECT statement. Can I do this. Here is an example of what I want to do: ALTER PROCEDURE AS SELECT fFirstName, fLastName, if(fLastName = 'Smith') then 1 as intTest else 2 as intTest, fPhone FROM tbEmployees Any help...

Thanks for the help. This makes sense. I added some more indexes to my tables and now the stored Procedure is much faster the first run. Thanks again.

I have a stored procedure that when I run it for the first each day, it takes 2 minutes to finish executing. After my first run each day of the stored procedure, it only takes around 5-6 seconds to run it. Does anyone have any ideas why this is or what I can do to speed up my first run of the...