Search results for query: *

Trying to re-use the hard-disk from my old laptop as a USB storage device. Removed the disk from the laptop, popped it into a nice new enclosure and plugged it in to my desktop PC at work (where I have administrator priv's). No joy. What happens is this: - The PC recognises a USB mass storage...

Am using a UNION query to collate two disparate queries, and then want to use that query nested within another. This is what I have: SELECT DISTINCT cid, logdt, MIN(closedt) FROM ( SELECT cid, logdt, closedt FROM Call C WHERE datediff(ss, C.logdt, C.closedt) < 21600 UNION SELECT c.cid...

I'm trying to report (using CR10) on an Oracle database table which has this structure: PersonID Status StartTime EndTime So far, so straightforward. Now a person can go through a four stage process: Stage 1 - Idle, indicated by Status codes of I (idle) or O (off) Stage 2 - work assigned...

Hi, I know this is probably simple, I'm just having one of those days today. I have a table tblEvent, with three fields: ID Emp_ID Status - takes either 1 or 0 I need to write a query that returns one row for each Emp_ID and then two separate count columns - one that counts how many times...

I'm graphing some data that has hour of the day along the x-axis. What I've actually got along the x-axis is a formula field which takes the form Hour({MYTABLE.TIMESTAMP}) My problem is this - there are some hours of the day where there is no data, and those hours get missed off the graph. So...

Hello, Apologies if this is a simple question. Am running CR10, querying an Oracle database, connected via OLEDB. Am using a Command in Database Expert, SQL as follows: SELECT ID_NUMBER, EVENT_TIME FROM ALL_EVENTS Also have a Parameter Field called StartDate, which a value of type Date. I...

Sorry if this is a dumb question. I need to run a query that returns the two records with the earliest date for each reference number. Also, I need to return a numeric value of 1 or 2 to indicate the position. For example, if my data was: REF DATE 111 1/1/2005 111...

I'm using Word.Open and Documents.Add to open Word from my VB6 app and create a new document. I'm then pasting the contents of the clipboard in. This all works. So far, so unspectacular. However, the text I'm pasting in from the clipboard is HTML. Since I'm only doing all this so I can use...

Does anyone know of any ActiveX control that I can use in my VFP5 project that will display both WMF format images and DWF format? (DWF is a popular CAD format). Just to further complicate things, the control needs to be freeware! I can find controls that display WMFs or DWFs but not both.

Not sure if this is the right forum - please redirect me somewhere else if not. I know I can use conditional SSI to include a file based on the query string part of the URL, i.e. <!--#if expr="${QUERY_STRING} = /new/"--> <!--#include file="newmenu.htm" --> <!--#endif --> But what I want to...

Not sure if this is the right forum - please redirect me somewhere else if not. I know I can use conditional SSI to include a file based on the query string part of the URL, i.e. <!--#if expr="${QUERY_STRING} = /new/"--> <!--#include file="newmenu.htm" --> <!--#endif --> But what I want to do...

Hello. I have a DTS job that pumps out a delimited text file. It's scheduled to run once a month and that works fine. I've edited the Job to use notifications, so that an email address gets notified that the job has completed, either successfully or unsuccessfully. Is there any way to append...

Probably a stupid question... I'm using a Transform Data Task to pump the results of a query out to an Excel spreadsheet. What I want to do is essentially this pseudocode: If FieldA = -1 Then Return TextStringA Else If FieldB = -1 Then Return TextStringB Else Return TextStringC...

Hi, Have a Word doc on a SharePoint page - how can I force this to be opened in Word rather than IE when it is clicked on the SharePoint page? Thanks.

Am using SharePoint Portal Server 2003 with a SQL Server back end. Have set up a discussion board but need to know how the content of the discussion board is stored in the back end, so that I can query it directly and run a report to summarise the content of the discussions. I've found a...

Hi, I know it sounds like an odd thing to ask, but I have a one-off need to create a mail merge document in Word that lists the Title, Forename and Surname from an existing data source (another Word doc) all on one page rather than one record per page as in a conventional mail merge. Is this...

Hi, Is there a way I can check dependencies in a VFP5 project. I need to change the structure of a table field but before I do I want to check everywhere it's used in the project... so is there a report or something I can run in VFP5 that will tell me everywhere that table field is used...

This is no doubt obvious and easy, so apologies in advance. I'm using VFP5 and need to query a table and ONLY return those records marked for deletion. How can I do this? Thanks.

Is there a VFP equivalent to the EVAL() function in VBA? For those unfamiliar with EVAL(), it can be used to evaluate an expression that results in a text string or a numeric value. Amongst other things, it can be used to evaluate/construct function names on the fly, e.g. Dim intI As...

I'm using VFP5 on a project I've inherited from a long-gone developer. I've just installed VFP5 on my XP desktop, and all seems to work well. I've copied all the source code from an old NT3.51 box to my PC and it loads up fine in VFP5. I can even build an APP or an EXE as long as I don't check...