Search results for query: *

The following always seems to evaluation to the first '100' case and doesn't get to the else. What is wrong with my case? any ideas? :-( CREATE PROCEDURE spprintTopRFAByVenue ( @ServiceVenue INTEGER, @DateFrom VARCHAR(30), @DateTo VARCHAR(30), @TopNNum INTEGER ) AS -- -- Work done: -- 1)...

I'm using VB6 /SQL6.5 and CR9. Sorry I looked through heaps of posts and cant solve this one. Dim ConnectionInfo As CRAXDRT.ConnectionProperties Set ConnectionInfo = Report.Database.Tables I recieve and error message saying the 'report' variable is not defined. When I define it eg Dim...

Hmm, a prickly one here. [evil] I wish to highlight the mimimum of a number field 'AgeAtDiagnosis' in a report. I have a running total (#RTotal0) and can get the minimum of the number field in the report footer. (I think a running total was necessary as AgeAtDiagnosis contains 0 values). I now...

This one has been driving me batty for some time .. BACKGROUND: Using VB 6 /SQL and Crystal 8.5. A previous developer linked CrystalReport1 to a VB form and set the following: CrystalReport1.WindowParentHandle = frmPrintPreview CrystalReport1.Destination = crptToWindow...

BACKGROUND: (Using CR 8.5) I have a report that uses two stored procedures, one for the main part of the report and one for the subreport link. One parameter: ‘@RequestID’ from the main report is used to select info for the subreports, this link is working fine. :-) THE QUESTION: How do I...

CR8.5 /SQL Sorry, I'm obviously missing something here, read several threads, but no help. I have two groups and wish to allow the user to choose to use the second (sub) group or not. They always want to see all records. I have a string parameter @Group1 passed in, but I don't know how to...

What property /code can I use to see what header column the user clicked on. This will then allow me to sort the grid on this column. I'm not sure I want to use .Row = 0 as I normally bypass processes when this is true. I've also looked at: .Col .MouseRow .MouseCol I presume I'll be...

MachineA (Wn98) has SQL Query Analyser 6.5 installed. I recently installed VB6, SP5 and MSDN on MachineB (WinXP) and have Enterprise Manager -cool :-) What CD do I use to install Enterprise Manager on machineA? Rob Hasard (VB6 /SQL 7.0)

I have been struggling with this one for some time. Several reports use this and I want to return the title (an integer field) where possible, but return a space for those with a 0 value. Can anyone come up with code that acts like ISZERO? much like ISNULL? SELECT 'Client' = p.Surname + ', '...

I have setup a deliberate error in this sp to test rollback. But it does not rollback and I'm getting an error message. (I think the rollback and commit are in the wrong spots. Can anyone advise please). SQL Error Message = Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK...

Update does not allow ORDER BY. How can I select the row with the largest Duration -an integer column? SET ROWCOUNT = 1 UPDATE #contacts SET Prov1ID = cd.IDCode FROM tblGContactDetails cd WHERE cd.contactID = #contacts.ContactID AND cd.Type = "Provider" ORDER By cd.Duration DESC -- cant...

Hi, this is my first attempt at rollback. (Using VB6 and TransactSQL) I have a stored procedure 'spLoopProcWithRB' which creates two rows for each client listed in a working table (normally a couple of hundred). This works for a small number of clients, ie Ok for 100 but does not create all...

Can anyone assist with a 'how to progress' reply here please. I have a complex select statement to perform in a stored procedure which gathers information for Crystal Report which is then used for presentation. Before begining the stored procedure I know the PersonID's I want. They are in a...

I hoping this is an easy question for someone. I have a MSFlexGrid which the user can add and remove columns from via command buttons. Just to look nice I want to finish their addition /subtraction off by sorting the grid (my code is fine here) and moving back to the top of the grid. I cant get...

I am writing a stored procedure for a report. The user is shown a list of all clients in a grid on a form. They then remove the database clients they do not want. The procedure selects the basic list of clients, then I wish to remove some clients from the working table. Ie SELECT PersonID...

I have looked at several posts here but no answer. I have a simple 8 bit BMP image on a command button that works fine on some forms, but not others. Initial forms are OK, but once the user has navigated via SSTab and this code it shows the image behind it, but it works fine. Is the code here...

I am recieving timeouts here and I cant work out why. Only retrieving on a table. 1) Table Creation script: if exists (select * from sysobjects where id = object_id('tblIdentityMapping_Person') and sysstat & 0xf = 3) drop table tblIdentityMapping_Person GO CREATE TABLE...

Hi, I'm hoping this is a simple one. I am using a record set to grab one record from a working table. When I am done with the recordset ('adors2') I wish to delete the record from the table. (A bit like a to do list). I recieve no error messages, but the record is not deleted. Code: 'break...

Phew, been looking at posts re this here and my head is about explode. First time dealing with RichTextBoxes. When I add text to a RichTextBox all text is made bold. How can I add text to the end of the RichTextBox before I print it with specific formats? Do I: 1) Format the text and then...

I have written a stored procedure that should be simple. The problem is I get an integer answer (0 or 1) when dividing two real variables -I want a two decimal place answer, you can see I have experimented with CAST and data types and I doubt I need as many variables as I have. I have cheated...