Search results for query: *

I have written a SP in SQL2000. It accepts a variable number of params (using @hcode int = null ) . The SP works fine from Query Analyser - Exec slValidation_Criteria 145,5,2 Here 3 of a possible 4 params are passed - the resultset is displayed fine - 186 hits. Then I try and call the sp...

I have a SQL Sp that has a variable no. of params (uses = NULL in the declaration). This works fine if I use this SP in a CReport, within the s/w, but I somehow need to code in VB this NULL values bit ... Can anyone help ???? This is the code presently : Call De1.slFind_Errors_Rpt(hcode...

Cheers mwolf00 using CAST did the trick ! Many Thanks Suel

I have written the following SP. This can have have aany or all of the 3 parameters. In Enterprise Manager, on checking the syntax of the SP it says it is OK. When I try and test this in QA I get the following message : 'Syntax error converting varchar value 'and hospcode =' to a column of data...

I need to create an Office style toolbar - cut,paste, copy, print etc. I know how to create a toolbar - using the imagelist, but how do I code the Office functions to the toolbar buttons ??? Any examples would be very helpful Cheers Suel

I have a control SSTab1 - with 5 tabs. The 5th tab contains validation errors, and I would like the caption 'Errors' to appear in red, if errors occur for the particular record being viewed.... I only appear to be able to change ALL the tab caption font colors ...... Has anyone found a way to...

Can someone please help me on this one ? I know changing Windows properties can be done using API, but what does WINAPI call this 'Highlight' property ? Any help with this code would be much appreciated ... Thanks Suel

I have a form containing a Combo Box (cboYear). On Form Load I fill the combo box . Then using a retrieved recordset (vrs) I put the recordset value into the combo. ie cboyear.listindex = vrs!syear This works fine, except the text is highlighted Is ther some way to turn this off, until the...

Thanks ... I think I was trying to make things harder than it actually is !!!! Thanks again Suel

I am using VB front-end with SQL2000 DB. I have retrieved a recordset (ADODB), I am stepping thru' each record in the recordset using .movenext, but I need also to move thru' each field in each record. Is there some way to do a 'fieldcount' to make a loop ?? example FOR liErr = 1 to Fieldcount...

Cheers ! It worked a treat Suel

I am accessing a SQL2000 Db using VB6 front end. I need to be able to return a ADODB recordset in Sub_1, and then pass each record in that rs to another routine Sub_Validate eg Sub_1() ' open the recordset set rs = new adodb.recordset rs.open "select * from SQLtable1", DE1,cnn1 if...

Using SQL2000 VB 6 I have created a DTS package and saved as a VB file.(Module1.bas) I have then edited the file (Module1.bas), and set the necessary references to MS DTSPackage .... I'm sure this is a really dumb question , but how do I get this to actually execute ? Example code anyone...