Search results for query: *

So easy when you know how! Thanks a lot guys... I just have to make the rest of the code work now! Sam

Hi How can I (programmatically) obtain the GUID of a DLL that may or may not be registered on the target machine? I'm sure this is easy but I've been searing to 2 days now and not got anywhere... Thanks Sam

Hi Thanks for that. What you had wasn't exactly right as it still returned someone who had not all tasks, but the following works.... SELECT * FROM tblTasks tsk WHERE NOT EXISTS ( SELECT * FROM tblKeyTasks kt LEFT OUTER JOIN tblTasks tsk2 ON tsk2.MeasureID = kt.measureID WHERE...

Hi Thanks for your suggestions but this will give an "any" match, which isn't what I want I think I probably haven't explained what I'm trying to achieve. People do tasks and each one gets entered into tblTasks. People also have one jobtype, called "Type" which (for the sake of this example)...

Hi I'm trying to filter a table on where one of the column values matches ALL values in sub table... this is wot I'm doing := SELECT * FROM tblTasks tsk WHERE MeasureID = ALL (SELECT MeasureID FROM tblKeyTasks WHERE type = tsk.Type) It doesn't...

If you use the DTS Copyobjects (with "Createobject" options turned off), I believe that ignores relationship restraints anyway and just dumps the data into the tables. Failing that BCP definately just dumps the data in, overriding relationship contstraints, but it's not a lot of fun to use. Sam

snag56 Wow, there's obscure solutions and there's obscure solutions! I'd hate to see what your dreams are like. Sam

Sorry, don't want to take anything away from mwolf00, however if you do the following you get the table name and the triggers on it.... SELECT par.Name AS 'Table', trig.Name AS 'Trigger Name' FROM sysObjects trig JOIN sysObjects par ON par.ID = trig.parent_obj WHERE trig.xtype = 'TR'...

Nope. Can you turn your proc into a view? if so you can run a select on that. You could input the results of your proc into a temporary table then run a select on that i.e. <first create a temp table that's the correct structure> INSERT #Temptable EXEC usp_MyProc Note that you can't do...

Firstly this isn't coded correctly. You should have "SELECT * FROM ...." rather than "SELECT 1 FROM ...". Yes your way will work but it is poor coding. But the reason this isn't working is because you have i.suser1 = Null. This coding never returns what you expect as you cannot use = with a...

Unless there's something wierdly and undocumentedly obscure the answer is : No, there is no such thing Of course someone will probably prove me wrong. Sam

The answer is yes..... When you define your connection object make the cursor type property = "adUseClient".. (e.g. adoConnection.CursorType = adUserClient" I think). Then you can populate the recordset. Once you've done that set the recordset's connection object to "nothing" (set...

Thanks . I fixed it just before your reply came in. The problem was that in the report, in the &quot;tables&quot; fieled in the Location form the original database and owner prefix the Proc(usp_rpt_..) value,which is the name of the stored procedure. It was originally...

Hi Can anyone help with a problem that's doesn't make any sense. I am running a CR 8.5 report from VB6. The connection is made via an ODBC. I am setting the location as follows: -------------------------- Dim crxTable As CRAXDRT.DatabaseTable For Each crxTable In report.Database.Tables...

Hi I'm getting a strange behaviour on Flexgrid that I don't believe is as difficult to sort out as I'm finding. I have a grid with 3 cols, n rows. SelectionMode is &quot;1- By Row&quot;, highlight is &quot;1 - Always&quot;. Now, when the user clicks on any row, ONLY the cell in the selected...

Hi all I to have had this problemm bit I FIXED IT..... (cue fanfare of trumpets) You need to pass the connection string to the subreport as well as the main report..... like this ---->>> With CrystalReport1 .Reset .LogonInfo(0) = strLogonString .ReportFileName =...

Cheers, Now you've pointed this out it's obvious Thanks Sam

Hi How can I find out programmatically if a control exists on a form? I'm writing a generic procedure to which a form is passed as a &quot;FORM&quot; object,and I need to know whether a tabstrip exists on the form Cheers

Hi I am trying to use DTS to create and export SQL data to an Excel spreadsheet. I have an ActiveX script task to build the name of the spreadsheet (the name has to include the year/month). The trouble I have is that the Excel connection fails with an error &quot;Cannot Update. Database or...

In a COM component I've written I create an Excel object then do things with it. This works OK on my development machine (both as un-compiled code and as a DLL in my local MTS package), but once I put it on the MTS server it fails at the point of trying to create the Excel object (Set oXL =...