Search results for query: *

Hi there. I've been struggling with this for a bit now and it might just be a quick algorithm and I'm missing something. I'm using VC++ 2005. I have 5 panels (all the same size) on a windows form and I want them positioned across the width of the form. I want one panel on the leftmost side...

Hi dave. That sounds plausible, but I'm not sure I understand what you mean by "set my column header formulas in the report based on those fields

Does the Report Creation API require a license?

I want to send fields to a crystal report at runtime, depending on the user's selection in a VB6 program. Is this possible? I'm using a dbaseIV database and ADO (DAO) in Crystal to set up the report and ADODB in VB6.....

I want to send fields to a crystal report at runtime, depending on the user's selection in a VB6 program. Is this possible? I'm using a dbaseIV database and ADO (DAO) in Crystal to set up the report and RDC in VB.

Aright. Thanks to both of you. I'll try it out and I always put BEGIN/END, even with one line of code :-)

SQLSister: So its like an optional parameter? How then, in the stored procedure do you check if the value has been passed in or not? NoCoolHandle: I thought of that....I'll consider it but I don't like all that useless data being in my tables....

You know what...I can't do that explicit word 'null' thing...some of the parameters are integers and won't accept that. I can't have 0 either...0 is meaningful in this case.

You mean pass the word 'Null' to the main SP that will then pass it to the appropriate individual SP? I'd rather have the blank spaces than the word 'Null' tho...not sure if it makes a difference performance wise. How else can I check in the main SP to tell which individual procedure to update?

Yeah, I've had the same problem with the Refresh method... I've got another question about this main SP that I'm creating.... Say for one value, I pass in NULL and the value in one of the tables was previously 2...I do want this updated to NULL. Because of this, I cannot use the logic that if...

Okay thanks. That's what I will do :-)

Hi. I've got one table with multiple children tables off it. I've got individual SPs for each of the tables that either updates the record or insert it if it doesn't exist. I have to update the tables thru VB6 and I'm not sure about something. Can someone tell me if its better to have...

I set up the running total to get the Sum of that formula...

I pass in the starting value from a VB application. I'm using an ODBC connection to the report and when I open the recordset, I send in the starting value... Using the formula I created, I did a running total on that but its giving me some huge numbers that aren't correct.

I have a report set up like this and I need to write a function that calculates a running total to get the Net values (from a starting value which is supplied). Say the starting value is 20, the results should go: Field1 Field2 Add Sub Net ------------------------------------- 12...

In my view, I'd like to do a subtraction on two fields, but both values can contain nulls. When one field has a value and the other is null, the calculation returns null. Can someone show me how to do this so it adds the value that's not null to the null one and get an actual value?

Okie dokie. That's what I thought. Thank you.

I'm using a stored procedure to insert records into an sql db through Visual Basic (very new to sql server programming). My question is, should I be performing error checking in my program code or in the stored procedure itself? (Error check such as make sure an entry is a number or string...

Thanks for the advice. This is my first time creating a database on the SQL Server....also first time with SPs and Views.

Okay, I'll create 3 different SPs, even thought it will be the exact same code in each.