Recent content by alfredp77

Hi all... I write a simple program to simulate keystrokes to another application. Basically I use AppActivate and SendKeys, so it is something like this: 'make the app active AppActivate(strWindowTitle) SendKeys(strKeys) It works fine for standard windows applications (Notepad, Excel, Word...

Try this: create table #report( systemname sdatetime gbl_cpu_total_util gbl_num_cpu ) insert #report select b.systemname, a.datetime, max(b.datetime), null,null from globl a inner join configuration b on a.systemname = b.systemname and b.datetime <= a.datetime group by b.systemname, a.datetime...

the other way to avoid the recursion call (other than dky1e already mentioned) is like this: if update(SHDEL2) return and to make sure you only update one row of data each time (only the updated data, not the entire table), you should do a join with the &quot;inserted&quot; table. update...

Hi, I have a stored procedure that does a query to JDE running in AS400 (I configure this as a linked server). I use OPENQUERY to execute the queries. I execute the stored procedure from Query Analyzer there is no problem, and the execution time is really fast. But when I execute the stored...

do you pass your recordset to another form to do some other processing? if yes, then you should also release those as well, if not, like strongm said, setting it to nothing only decrements the reference count and not deallocating the object itself. in the below example, the recordset object...

Use the Microsoft Script Control component. Put it in your form, then use the Eval method: Dim intTest As Integer intTest = ScriptControl1.Eval(&quot;10+10&quot;) intTest will have the value of 20. Hope it solve the puzzle :-)

I've been using VideoSoft VSFlexGrid Control (7.0) and FarPoint Spread 3.0

sorry, not quite clear with what you mean by &quot;How can I automaticlly open the table it is requesting and skip that step of having to open it. I am selecting the table on the init() of the form and it is fills my treecontrol with what I need. . .but it asks to open it again. . .??? &quot...

The easiest way is to use the Microsoft WinSock control and read it's LocalIP property.

the vwcount is not a view, it is an alias for the query: select company.company_code, count(member_id) total from Company, Members group by company.company_code

I think we can make it simpler: Select * From Models Order by replicate('0',12-len(KeyCode)) + KeyCode, description

if you are using SQL Server 2000, then you can use &quot;INSTEAD OF&quot; triggers. Check out this link to find out how to use it: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro01/html/sql01a17.asp

I've mail you the code. Hope it helps :)

1. remove the GOs from your stored proc. sql will start another batch after GO. so after your first GO, everything else will not be part of CREATE PROCEDURE statement. 2. your storproc parameter is wrong, you must concatenate 'DSTOMESSAGING\' and @UserID, store it to a variable then pass it to...

That's possible. Ok, first of all, you cannot achieve such thing using an activeX DLL, because DLL will run in-process, that is, in the same process space as the EXE that invokes it. So it is impossible to access variables/objects in the same DLL that is invoked by another EXE. You can do it...