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 derfloh 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: lespaul
  • Content: Threads
  • Order by date
  1. lespaul

    Microsoft Query from excel issue

    I am trying to do a CASE statement from a query into Excel. This operation works fine if I am trying to do a comparison on a text field but fails when trying to perform on a date field. For instance, if I do: SELECT Case When CasPre <> 'TR' then 'Not Traffic' else 'Traffic' end From TableName...
  2. lespaul

    FormatDateTime returning wrong year

    I have a form that allows users to enter a date of birth: ie: 4/16/40 Then when the user processes the form there's a function that checks it's length, adds leading zeros, parses the date and then uses FormatDateTime to just return the year of birth: strTemp := strPostedByDOB; If...
  3. lespaul

    Indy component issue after compile

    So I have a Time Clock program that we built that has been having some issues, so I looked and found that some of the queries were inserting into DB2 Logicals (which is like an Indexed table). So I changed the queries to insert and use the Physical files. That was the only change to the...
  4. lespaul

    Microsoft Query in Excel - nested subquery

    So I am trying to get the following query to run in Microsoft Query so I can return the results into a worksheet. select b.caspre, b.casnum, D.DEFNAM, D.DEFSSN, D.DEFADD, D.DEFCTY, D.DEFSTT, D.DEFZCD, D.DEFDTOB, D.DPHON1, D.DEFSEQ, D.DEFRAC, D.DHAIRC, D.DEYECO, D.DHGTFT, D.DHGTIN, D.BNDTYP...
  5. lespaul

    DBLookupCombo box misbehaving

    I have a crappy program that I am maintaining. The person who did the programming came from an RPG background and had no OO concepts or understanding when he built this program. Anyways there's this piece of code that is supposed to set the DBLookupCombo box to the state of NM when the field...
  6. lespaul

    Tab stops ignored

    I am modifying a form that has many DB aware components. So far all I have done is move the existing components around on the form so they match the position on the paper citation that the entry is done from. I have modified the TabStops for each of the objects so the clerks can just tab...
  7. lespaul

    manipulate Word object programatically

    I have a Word template that has a text box in the footer. This template is called from a Delphi application which uses form fields to populate database information into the document. I need to be able to hide the text box (or delete it if that's an option) when a certain condition is true...
  8. lespaul

    format time in query

    Is there any way to format the timestamp datatype into a normal time value? I have a time field that shows: 10:08:36 AM I'd like to display 10:08 AM I have tried substring and parsing the time apart, but when you convert to a string the : is replace with . and I lose the AM. So now it's...
  9. lespaul

    API Interface

    I need to create a java class that implements an API, can someone point me in the right direction or to a tutorial or something helpful!? We are pushing out a new scanning process using Kofax/Ascent. I'm told that there is a COM interface called KfxReleaseScript used to communicate with the...
  10. lespaul

    open form based on user selection

    I have a main form where the user enters a citation number and selects the type of citation (cbCitationType) it is: Misdemeanor, Traffic, TRACS. I have three forms that have the layout of the different citation types: fMisdemeanor, fTraffic and fTRACS. Depending on what the user has selected...
  11. lespaul

    Modify all cells

    I have an excel spreadsheet with a single column of information: A 001 01 001 03 001 05 001 07 I'd like to run a process that splits that information into two columns. A B 001 01 001 03 001 05 001 07 every item in the collection has the 3 digit space 2 digit...
  12. lespaul

    convert UNC file name to Unix

    So I need to take this: \\servername\folder1\folder2\ and convert it to a Unix file name format: //servername/folder1/folder2 I have tried using replace all, but all the ///// and \\\\\ is very confusing and I can't get it set correctly. Anyone have any idea how to do the replacement...
  13. lespaul

    Process csv file

    I'm trying to take this code that I found in Thread102-839480 and tweak it to process a file a little differently. I have a file with data like: documentid CitNum Path 1245655 02B0050223551 \\server\001301D7.tif The file is currently an excel spreadsheet, but I...
  14. lespaul

    Update query error

    So, I've got what I think is the correct query, but i keep getting the error: Invalid expression. Column qualifer or table S2 undefined here's the query: UPDATE CMPSTAMFE s1 SET s1.chgdscl = s2.chgddsc FROM CMPSTAMF s2 WHERE s1.statut = s2.statut and s1.chgabv =s2.chgabv Here's what I'm...
  15. lespaul

    Java Class in Delphi application

    Is there a way to use a java class in a Delphi application? We have a register application that was built in Delphi. I now have a Java class that determines if a specific fee needs to be assessed. In my register application I need to use the same logic and would rather just use the Java class...
  16. lespaul

    Java class in UDF for Trigger

    So, i've developed my java class and loaded it into the IFS. What I need to end up with is a trigger on a table that calls a function which calls the java class and runs the addCourtCost method of the class. (As is described on p. 325 of the 'Stored Procedures, Triggers and User Defined...
  17. lespaul

    apostrophe in text

    So we have a web page that has a text box where the user can enter something like: Short Description: [highlight white]Judge's Orders[/highlight] however when that gets input into the update query string: strSQL = "Update TableName Set ShortDesc = '" + shortDesc + "'" it doesn't work...
  18. lespaul

    Implementation

    So here I am and I've convinced my boss we need to do some OOAD and we come up with some documentation that shows the beginnings of our objects, methods and properties. We pick a development language (Java) and start creating classes. What do we do with them? What do I create so that these...
  19. lespaul

    Chrome

    Pretty amazing! http://tools.google.com/chrome/?hl=en-US This is a cool comic book explaining how Chrome is different than other browsers and some of the design processes that drove the changes. http://www.google.com/googlebooks/chrome/# Leslie Have you met Hardy Heron?
  20. lespaul

    Completely transparent PowerPoint Slide

    How can I create a completely transparent slide? I am adding custom animation to a my slides and will be running another program at the same time. I want the other program to be visible behind the powerpoint presentation. So the other program is a picture slide show. The powerpoint show is a...

Part and Inventory Search

Back
Top