Search results for query: *

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...

Use the &quot;OpenSchema&quot; method of your connection object: Dim mConn As New ADODB.Connection Dim rstTables As ADODB.Recordset 'Assuming that u've already open the connection to 'the Access database using mConn: Set rstTables = mConn.OpenSchema(adSchemaTables) With rstTables Do While...

Try to set the default connection options for the server through enterprise manager (right click on the server, properties, connections, and you can see a lot of checkboxes, two of them are ANSI WARNING and ANSI NULLS). This works for me. Specifying SET ANSI NULLS and SET ANSI WARNINGS ON for...

tekomni, Usually what I do to achieve your goal is something like this: Code in Form1 Event UnloadForm(strText As String) Private Sub Form1_Unload() 'during the unload, raise the event and pass 'the text you want to return, 'in this example, i'm returning text 'from...

try this on your populateLocationDetails sub: Private Sub populateLocationsDetails(objSelNode As Node) Dim objList As IXMLDOMNodeList Dim objLocationsElement As IXMLDOMElement Dim objChildElement As IXMLDOMElement Dim i As Integer If objSelNode Is Nothing Then Exit Sub 'On...

just a little addition: actually creating an activeX EXE is almost the same as creating an activeX DLL, it's only that activeX EXE will run on it's own thread. beside using registry/log files, you can define an event in the class inside the activeX EXE and raise the event to notify the main...