Recent content by victora

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!

Good morning to all, I have a portion of a text field that I need to include on a letter but its a little tricky(at least on my part). Heres the narrative: 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...

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

CR 10/SQL Server 2000 I'm using the 3 formula method 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...

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.