Search results for query: *

Hi, I have the following query which works on SQL Server SELECT MAX(MaxValue) MaxOverAll FROM(SELECT MAX(HISTORY.WHENHISTORY) MaxValue FROM HISTORY WHERE (HISTORY.READCODE = 'ZPSA10' OR HISTORY.READCODE = '137S.00') UNION ALL SELECT...

Hi, I had the following Select statement embedded as one of the rows of a bigger query: (SELECT DISTINCT CLASSIFICATION.READCODE FROM CLASSIFICATION WHERE CLASSIFICATION.PATIENTID = ANYBODYPAT.PATIENTID AND CLASSIFICATION.READCODE = 'C10.00' AND CLASSIFICATION.ROWINACTIVE = 0) As DIA...

Hi, I am a bit of a newbie to dreamweaver and I need help. I am trying to create a selection list with thumbnails and a vertical scrollbar. Any ideas? Thanks in advance. Kevin.

Hi, I am writing a windows CE application for Pocket PC 2002/3. I have a wide string containing extended characters which I read from a text file. If if output the string to another text file I get the following... FSV AUTÓMODELLEZÕ EGYESÜLET Which is fine. However if I try and output...

Hi I am trying to create a view from two tables. Table 1 Sales Cust_ID | Name | Genre | Sales Person | Last Order | ------------------------------------------------------------------------------------- A123 | John | Fiction | Bill |...

Hi, I am trying to figure out a way of running an sql script into an sqlexpress server. I have been looking at the sqlcmd tool, attemping to use this in a spawned process. example... System.Diagnostics.Process proc = new System.Diagnostics.Process()...

I have two applications and one database. One application sits on a server with the database. This application runs each night and updates the database. The other application is installed on a number of PCs connected to the server. This application only reads from the database. I have all...

Hi, I have a project that has two applications and a database on a SQL Server. A client application is to sit on networked PC and the other server app with the database will sit on a server. (note: the two apps do not talk to each other and use the database independently). All was well and I...

Hi all, I have the following SQL statement that works fine... SELECT distinct ANYBODYPAT.NHINO NHINO, ANYBODYPAT.USERID USERID, ANYBODYPAT.ETHCODE ETHCODE, ANYBODYPAT.GENCODE GENCODE, ANYBODYPAT.DOB DOB, CLASSIFICATION.READCODE READCODE, ANYBODYPAT.ISCAREPLUS...

Hi Guys, I have trawlled the forum but can't find the answer to this Count problem... I have a querry that results in something like this: user_id | item_id | is_member | sales_rep ------------------------------------------ 123 | aa | Y | bob 123 | bb | Y...

Hi, I have a table that contains a date of birth. I would like to add another column for age and if possible automatically, maybe using a column formula, calculate the age based on the DOB column value. Can this be done this way? Cheers, Kevin.

Hi, I am about to emberk on a project but need some advice. Is there a way of picking up mouse click events in other applications (Microsoft mainly but others would be great if possible)? In particular the clicking of menu options and toolbar buttons. I would need to know the application and...

Sorry if this seems like a stupid question but I want to used the Image Editor toolbar to draw some simple rectangles on my windows form (actually it is a user control form). The problem is when I add the Image editor toolbar it is disbaled and I can;t click on any of the bottons. What to I...

Hi, I'm working on an application that searches through an XML document to find data. All works well for exact string but I now need to expand it to include a 'like' search (e.g. pick out a node using a search sting 'TEST' and finding a node containing 'MY TEST SEARCH' as text. Any Ideas...

Hi, I'm trying to write some code that will closed down and restart my application once it have completed a code download using the Updater application block (InProcess method scenario). I've tried the following: //CheckUpdate is my class for checking and downloading updates. //Returns true...

Hi, I'm trying to write a simple select statement that includes a date, however I want to drop the time do all I get in the record set is dd/mm/yyy. Any ideas? Cheers in advance

Hi, I need to access three tables to produce a report in VB but its dog slow. Firstly I get a list of customers from one table then I need to look through two more tables to pick out certain data from any record with a matching Customer ID. Basically my program runs a Select * for the three...

Hi, I've been asked to extract data from a datadase in the following format..... &0,"REPORT","2","0" &1,"ID","SURNAME","FORENAME","ADDRESS_1" &2,"PROD ID","TEXT","VALUE1" $1,"1","BECKLES","DAVID","75 FIR TREE APPROACH" $2,"19990830","Sample product 1","90" $2,"20030202","Sample product...

Does anyone know how to log when a record has been deleted from a table. I'm using Interbase 7 and I need to know who, when and what if possible. Cheers.

Hi, Does anyone know of any method or software that logs the records a user has viewed in a particular table. Cheers,