Search results for query: *

ok...............I was using the code below, would that do the trick now then as i am checking for an error after each statement (bar the use crmwht statements but I'm not bothered about those really)? so any error with any of the bulk inserts or truncate/indexes will neither insert take place...

Hi I'm new to IIS - we have version 6.0 a new 3rd party software package has been loaded on - a new website created under web sites, called customertest. today the application seemed to hang, and i did a iisreset /restart and it worked ok then ! it seemed to be talking about lack of memory - I...

thanks i get an error now - I know there is an error within the 2nd bulk insert, but using query analyser i get The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. Server: Msg 50000, Level 16, State 1, Line 6 Error in inserting llpg data................. The ROLLBACK...

hi i've got a piece of code below which works fine, i've since added in lines to try and catch any errors, using begin transaction, rollback etc. There are 2 bulk inserts which take place, if either one fails I want to rollback completely, i.e. don't truncate the table, don't drop/re-create...

i have the following sql statement which I'd like to add another inner join to. I have a table called cts_enquiry_services which has two columns I'm interested in, EnquiryTypeID and ServiceID. ServiceID links back to the ServiceID in cts_services, so i want to add an inner join for...

that is exactly what i am thinking......... let me guess, they can do it for us at a cost !!

Hi I'm using a 3rd party software package and doing an insert with 2 columns (neither are identity columns but just numeric) the identity column is columnID (primary key int(4)) the insert statement is ExecQuery_X "CONN_Z","00010::insert into tblComplaint_ISB (crmCallID,CustomerID) Values...

thank you everyone - works a treat Rekcor - I have given your earlier post a star also because once i rewrite them completely i will take that into account thanks again

thanks rekcor I'll take note of that for the future, problem is I've inherited this 3rd party software product and I don't want to (and haven't the time) at this early stage to re-write the whole thing, so that code is their's - I just can't seem to add validation for my custom fields...

sorry ! <script language=JavaScript> function validateEnquiry() { if (document.frmEnquiry.selService.value == '-1') { alert('Please select a Service'); document.frmEnquiry.selService.focus(); return false; } if (document.frmEnquiry.selRFC.value == '-1') { alert('Please...

Hi I have an existing form which I need to mofidy - I have 2 new checkboxes which i want to validate for if they are both checked = false I have tried fitting in this check within the existing validation below but it doesn't call it ? the html for the checkboxes is further below also any...

thanks everyone I eventually have got it working using my code below Dim dbs As DAO.Database Set dbs = CurrentDb Dim stra, strupdatea As String Dim rst As DAO.Recordset stra = "SELECT intStratID, Min(ReviewDate) AS NextDate FROM dbo_tblStratReviews where ReviewDate >= date() GROUP BY...

Hi I've got a main table called tblRiskMain with an identity column called intRiskIDcalled and a column called NextReview (type smalldatetime) sample data ----------- 10, 01/01/2004 11, 01/01/2000 i have another table called tblStratReviews with columns intStratID, intRiskID, ReviewDate...

brilliant thanks !

ok thanks so lets assume it returns 10, then how do i add 10 case statements programatically ? thanks

Hi i've got the following code. I won't know how mnay items will be in List0, because it gets added to frequently. therefore i can never say how many cases I require (in the example below i have used 5) but it might be 12, it might be 14 etc. How can i match the number of case statements to the...

yeah I've given up with conditional formatting....is there any way you can say to move next on the OnFormat detail event procedure, as in move to the next record ? thanks

Hi I have a report rptFormA containing 2 subreports [dbo_tblStratRecords subreport] which has a field intNewID (primary key) and [dbo_tblKeyComponents subreport] which also has a field intNewID the [dbo_tblStratRecords subreport] may have 2 records with the intNewID's being 1 and 10 for...

thanks aa it was the join - I simply removed it ! thanks again

has anybody got any ideas about this ? I'm wondering if its a union that is needed in there somewhere ? thanks