Search results for query: *

I have an export from a 3rd party application in a tab delimited format. The exported file is flat text, tab delimited, and was designed to be fairly generic for importing into a DB (SQL, DB2, Oracle, etc). One field in the export is text. According to the app's documentation, the destination...

I need to add some additional text to a text field. We'll call the field NOTES. Assume that NOTES on a record contains a value of 'This is the first note, added on 04/18/10 4:26:08 PM.' I need to make the field have a new value of: 'This is the first note, added on 04/18/10 4:26:08 PM. This...

I have a document template that uses find/replace tags. A 3rd party application opens the template and saves a new instance of a document after doing a find/replace on the tags. For example, the address section of the letter may look like: <<CUSTOMERTITLE>> <<CUSTOMERNAME>>...

I need to total the differences between two columns into Over/Under totals. I need to know how far over Column A is than B, when value in column A is > B, and vice versa. I'm not talking about the net difference, but more of an IF logic. Example: ColumnA ColumnB 10 5 10 8...

SQL 2000, possibly moving to 2005 Mode 80 I have a set of purchased apps that use SQL security rather than Active Directory. Each user needs their own SQL account with full read/write/exec rights as the apps use combinations of stored procs and direct updating. Within the apps, users have...

Assume the following: SQL Server 2000. Application AppX uses SQL security (not Active Directory). UserBob is a valid AppX user and is allowed to make changes to data using AppX. AppX uses a SQL database named DataBaseX. Scenario 1 UserBob opens AppX, which makes an ODBC connection to DatabaseX...

I can't add any fields to my reports. That includes text boxes. All I get is the outline of the field and the little "ghostbusters" circle and slash. This is happening on all reports that I open for editing. they are not "read only" files. Does anyone have any idea what I've done? I've closed...

Report structure: GH1 (Insurance Claim Number) GH2 (Policy Coverage) D ({Person} and {LossesPaid}) I'm building a report for an insurance company that will tell them every time the company has paid out more than the policy limits. An insurance policy has "per person" limits and "per...

I am attempting to provide users with a combo box to select a time in 30 minute intervals between 6:00a and 7:00p. I then store that time (along with a date captured in a 3rd party date control) in a SQL table in a datetime field. This works fine. When I retrieve the recordset, I can get the...

SQL 2005 I'm scheduling a VB app to be executed through SQL Agent (CmdExec). A fellow developer said that he thought I could set this up to pass any errors rasied in the VB app back to SQL instead of displaying a pop-up box like VB normally does. The idea, of course, is to use SQL's...

This isn't really a security question, but of all the Tek-Tips forums, I suspect that this is my best shot at finding someone with some information. I have a user who is reporting an error to our Help Desk. I need to know the exact steps she's taking to get this error, but she doesn't know each...

I have a DB that I have gotten a good backup of. This DB is used for training. I want to give the trainers the ability to restore the backup and effectively restore them to their pre class session state. I've written an app that executes a restore command when they click a button. I want to...

Crystal 7 Report has the following sections: RH PH GH#1 GH#2 GH#3 Details a (Hidden) Details b (Hidden) GF#3 GF#2 GF#1 RF PF Details a is a "header" section. It contains the labels for the records returned in Details b. When I double-click GH#3, I want to see: Details a Details b record 1...

I'm creating a routine where I need to drop a Stored Procedure. I only want the command to execute if the SP exists. How can I get this information to know if the SP exists or not? Thanks in advance. Monkeylizard Sometimes just a few hours of trial and error debugging can save minutes of...

I'm creating a routine where I need to drop a Stored Procedure. I only want the command to execute if the SP exists to avoid any failures. How can I get this information to know if the SP exists or not? SQL 2005 Thanks in advance. Monkeylizard Sometimes just a few hours of trial and error...

When new users login and anew profile is created, they all default to Short date format of M/D/YY. I know how to manually change this in Regional and Language Settings. Can MM/DD/YYYY be made the default short-date format for all users, including new ones as their profile is created...

Can I make a formula return a Null? If NOT IsNull ({Date1}) and ({Date1}>= Date2}) and {Date1} <> DateTime (1900, 01, 01,00, 00, 00) Then ({Date1}-{Date2}) else <<NULL>> <-- I want to make it return a Null here The dates are comparing some customer service response times. A Value of 0...

n00b Avaya question here. I'm writing a PC app (SQL Script or .Net, undecided) and I need to be able to find available agents in an ACD for live-transfer workflow routing within my application. If I know the ACD number, can the Avaya database be queried by an external application to find the...

VB6. Application has a form that allows users to import images. It uses a DriveListBox control to set the source of the images. This has been working fine, but I know it's only a matter of time before users begin upgrading their cameras and XP stops giving the drive letters. Any suggestions on...

I've just read Mr. Hammerman's FAQ 149-1220. I understand what it's doing, but how do I use it? I've never built an array in Crystal before, so start from the beginning if you can. I'm building a report that will look sort of like this bad ascii example below: ****************...