Recent content by ulwitch

When do you use Set to assign a value to a variable, and when do you use Select? Set @var1 = 50 or Select @var1 = 50 What if you need to result of a query, like this one: Select @var1 = count(*) from table1

The following is code that works in VBA that utilizes the Excel function "Median" from an Access module... Dim objExcel As Excel.Application Dim dTemp As Double Set objExcel = New Excel.Application dTemp = objExcel.Application.Median(1, 2, 5, 8, 13) .................. I need to be...

I am having trouble referencing values in Frames. <FRAMESET COLS=35%,65%> <FRAMESET rows=30%,70%> <FRAME NAME=LEFT src=Task6.asp frameborder=0 scrolling=no> <FRAME Name=BottomLeft Src=Task6Bottom.asp frameborder=0> </FRAMESET> <FRAME NAME=RIGHT src=Task6Right.asp> </FRAMESET> If the...

Insert a record in one of the tables on the distribution database and check that in 5 minutes, the same record appears in the subscription database. hope this helps, Chris Dukes

No problem...

I need to know how you are calling them from VB. Please post your code.

Is there a way of setting every thing up within the setup.exe (I use Installshield)? -I use Installshield, too, but I haven't tried to do this. I will look into this and if I find anything, I will add it to this post. Does every PC need to have Oracle Client installed ? -Yes, and you have...

paqguy, Try this... Dim crpParamDef As CRAXDRT.ParameterFieldDefinition Dim crpParamDefs As CRAXDRT.ParameterFieldDefinitions 'Open report for manipulation Set crpReport = crpApplication.OpenReport(ReportFilename) 'Create a variable to relate to the report parameter fields Set...

The fields have probably been defined as CHAR(10) rather than VARCHAR(10) Char (10) will always create a field that is 10 characters long. This will be filled with spaces if the fields is actually chorter than 10 Character. VARCHAR(10) will hold any number of characters upto 10...

oops! I forgot to end the procedure. Create or Replace Package HCC.MMA_TYPES AS TYPE ref_cursor IS REF CURSOR; PROCEDURE Plan_Events ( v_sorgid IN varchar2, events_cursor OUT ref_cursor ); END HCC.MMA_TYPES; / Create or Replace Package Body...

Try this in SQL Worksheet. Create or Replace Package HCC.MMA_TYPES AS TYPE ref_cursor IS REF CURSOR; PROCEDURE Plan_Events ( v_sorgid IN varchar2, events_cursor OUT ref_cursor ); END HCC.MMA_TYPES; / Create or Replace Package Body HCC.MMA_TYPES IS PROCEDURE...

No, you do not need to specify the cursor. For clarification, I am going to paste a copy of a vb call to a procedure that I use everyday as well as the procedure that was called. '****************************vb********************* Set cmdStoredProc = New ADODB.Command With cmdStoredProc...

The following sub calls a procedure that doesn't have input parameters. If you do have input parameters, you would need to include the following for each parameter: Dim nParam1 As New ADODB.Parameter 'This next part should be placed right after you set the command type. Set nParam1...

My DSN is a system one. I have isolated the cause? Well Sort of... the DSN works fine until I load Novell client software on the machine. Once that is loaded, you can't log one user off and another one in and have them use the DSN. You have to reboot before a new user can access the DSN. Even...

I still haven't found a solution. Should I post this question in a different forum? I need help here...