Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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?

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