Search results for query: *

Never mind! Found out my Upd_User_Name length is only 10. Thanks

gentlemen/ladies, Running on MSSQL Server 2000. If somebody can tell me what is wrong with this code. Thanks very much. Code: ____________________________________ UPDATE MM_Refer SET Ref_Stat_Cd = 'D', Upd_User_Name = 'JOHN D NIED', Upd_Date_Time = GETDATE() FROM MM_Refer R...

thanks lbass, it worked like a charm! I can't thank you enough. As usual, you're the expert. I have in my file solutions you've extended to me all these years. Again, thank you!

...Our claim Dept enters an explanation of why they are denying a claim on a field that was initially intended for another use; they enter a "*" prior to the denial reason. Now I have to grab that text after the "*" and include it in a letter. --- Example of a Note entry: This is a claim from...

hi george,(gmmastros) It so happen that we are still on SQL2000. (sigh!) But I was able to put your solution into work, create the table I need prior to the big query, and it works like a charm! If only I can give you 5 stars! you saved my going back and forth from crystal to access to sql...

Denny, Thanks for the heads up. If you can show me the link, it will be much appreciated. Looks like I'm getting no result on my search TIA

I'm trying to create a temporary table needed for another query. This table has multiple records per group as shown. I want to insert a new field (SeqNo) that basically is the seq# of the records within the group. It starts with 1 and increment by 1 for each same MemNum. Select MemNum, SeqNo...

I have a problem setting up my testing server. I have two web apps already running on 2 sites. Nothing fancy, just a search function (master/detail). When I developed them 2 years ago, I had no problems setting up my test server. Actually I’m using the same connection string for this new...

I'm ready to install the CR XI on my PC with CR 8.5 and CR 10 in co-existence. Can CR11 co-exist with my 2 older versions? I'm keeping them for backward compatibility with a viewer program installed on my users but will eventually convert them to XI if/when all of over a hundred reports will...

First, thank you all for your replies. The currencyvar works!. I just replaced numbervar with currencyvar on my formulas. The problem is, my group total does not reset after printing. Its behaving like a running total, meaning it includes totals of the previous groups. Pls help. Again thank...

...I came accross from one the thread here. But i got this error "A number is required here" on my detail formula. MyFormula is {tabname.Svc_Chg} * {tabname.Svc_Unit} and they are both numeric Thank you ----------------- Pls see below: group header: whileprintingrecords; numbervar...

I posted a while back question regarding exporting text to DW. This is a spinoff of that. So okay, I can slice then export a text by selecting HTML as type but how can I do this: 1. retain the original content and text attributes i.e. font, size, color of my text in FW. 2. retain the...

I just got an email offer from BO for their latest ver XI. I'm already running on ver 10 and I'm just wondering whats in it for me to upgrade to the latest. Actually, I'm developing both on 8.5 and 10.0 as my CR viewer installed on users is for the 8.5. I'm continually converting to 10 and...

Thanks to everybody who replied to my post. Especial mention to Swi. YOU ARE THE MAN! The program works like a charm. I checked the output file and sure thing! No more duplicates! Again thank you

I just started with VB 6.0 couple of weeks ago. I have this problem of creating a text file based on a raw data from one of our vendors. My input is a text file with duplicate cert#. How can I create a new text file with only the unique cert#? Thank you very much for all your help.

yes, thank you. I already modified crystl32.dep as per george tip and was able to create an installation exe. But thats not the end of my dll problems; during installation, there's an error to the effect of 'cannot register a dll...' I came accross this and resolved my problem...

Pls help!. I have a VB6.0 program that prints a report using Crystal Report. (Actually, I initially developed the report in CR10)My back-end is an MS SQL server 2000. It works on my development PC but when I run the Package and Deployment Wizard I have this error: "Unexpected error number...

....Open End With With comSave .ActiveConnection = conSave .CommandType = adCmdText .CommandText = "Select * from XL_ClaimsProcessingLog " End With Set rstSave = comSave.Execute End Sub Another question: Normally, where do you keep this codes...

I'm a programmer from a forgotten era. (you know, COBOL, RPG in AS400...) Started with VB 6.0 like 2 weeks ago and man, do i have tons of questions! Anyway, here's my scenario: I'm trying to access an MS SQL 2000 using ADO. I use the property windows and was able to display records from my...

Sorry, I'm on CR10/SQL Server 2000. I finally figured it out last night. And its the same like you r solution. Thank you for reply...