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!

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

Recent content by JDSmith14

  1. JDSmith14

    New to Delphi.Net

    Hi I'm new to delphi and was wondering where i can find some good examples on developing delphi.net web apps, or any books for delphi.net
  2. JDSmith14

    GIS viewer for Delphi

    Thanks for the help Steven - Much appreciated! Johan
  3. JDSmith14

    GIS viewer for Delphi

    Thanks Steven I did mean autoCad. Do you know where I can find these ActiveX components? Johan
  4. JDSmith14

    GIS viewer for Delphi

    Hi I am looking for a GIS viewer of some sort for Delphi 2005. I need to view a DWG (Caddie file) or DXF. Does anyone know of a component that is available? Thanks Johan Smith
  5. JDSmith14

    Launching help from Delphi 2005

    Hi I am trying to launch a custom help file from withing delphi with the following command: Application.HelpFile := 'c:\temp\myhelp.hlp'; Application.HelpCommand(HELP_FINDER, 0); Nothing seems to happen. This code used to work in Delphi 6, but not in 2005. Any suggestions would be...
  6. JDSmith14

    $IFDEF

    Thanks for the help and comments- Highly appreciated Johan
  7. JDSmith14

    $IFDEF

    Hi I am trying to do the following in the uses clause of a form: Uses {$IFDEF X} FormX, {$ENDIF} {$IFDEF Y} FormY, {$ENDIF} other units.....; Form X and FormY has the same name in Delphi - Let's say MyForm. In other words, If I have a button on the main form of the...
  8. JDSmith14

    Count a timestamp field

    Hi Everybody I have a Log table that logs all transactions for all users of a system. I have the following fields: User Name : String Transaction Time : TimeStamp Action : String How do I get the total number of transactions PER TRANSACTON TYPE let say for a month? For exampe: User1 ...
  9. JDSmith14

    Query for Report

    Thanks Druer You are the man! I eventually got a sample working with the following code: SELECT T1.ProjRef, SUM(T1.IT1) AS JanTotal, SUM(T2.IT2) AS febTotal FROM (select ProjRef, sum(InvoiceTotal) as iT1 from ProjectActual where (YEAR(ProjectActual.SourceDocDate) = 2006) AND...
  10. JDSmith14

    Query for Report

    Thanks Druer I tried your suggestion in a view just to test. In principle it works fine, creating the table with day, month, year, project refrence and amount spent. My problem is still however to query out a value per project per month for the 12 months of the financial year. I need the...
  11. JDSmith14

    Query for Report

    Hi I have a table containing predicted cashflow for a certain project for a certain date. Example: ProjNum|Date |Predicted amount| 1 |11/11/2005|2000 | 2 |01/01/2004|3000 | Then I have a similar actual expenses table: ProjNum|Date |Spent amount| 1...

Part and Inventory Search

Back
Top