Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Elroacho
  • Content: Threads
  • Order by date
  1. Elroacho

    Max from union

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

    Singleton error

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

    Thumbnail list

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

    Extended characters in edit control

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

    A view from two tables

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

    Running an sql script from VS2005 (C#)

    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()...
  7. Elroacho

    Deploying SQL Express database

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

    Please help

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

    Nested Counting

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

    Another Count Question

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

    Calculating Age based on DOB

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

    Detecting events in other applications

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

    Image Editor Toolbar

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

    XML 'Like' Search

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

    Restarting a C# application

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

    date format in the select statement

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

    Slow queries

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

    Output Format

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

    Logging deletions

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

    Logging record access

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

Part and Inventory Search

Back
Top