It's common practice in stored procedures to suppress the row count returned by updating your stored procedure by using "SET NOCOUNT ON" EXAMPLE: [snippet=]ALTER PROCEDURE [dbo].[storedprocedure_name] @YR_CDE [char] (4) ,@TRM_CDE [char] (2) ,@Begin_DTE [datetime] ,@End_DTE [datetime] AS SET NOCOUNT ...

I use RDP to access virtual servers. Just X out of RDS it'll warn you saying your session window will close but any open programs will continue to run. Consider other administrators. Generally, you'll only have 2 licenses to remote into a server unless you buy additional LICs. If you only have two l...

Followup:

A less elegant but easy fix is to put in a second "Current Values" text box to receive the array variables.

That gives me a field for current values and a second field (listbox) to push values into the database.

I like Phil Pendlebury post idea of removing the X in the title bar. I'm using MS 14 * Go to the dialog editor * Click the background or title bar to give the whole form focus * Look at the properties window should say something like "Properties for: dialog" * scroll down in properties to BORDER ICO...

Thank you Hagchr! That really helps and does exactly what I need, to highlight a value in listbox based on a variable. :D As you pointed out it does seem to be an issue with SelectedItems since TEXT works just fine. Such a pity, but makes sense that reading/writing a value is different from changing...

Hi, I'm trying to highlight values in a listbox based on values i read in from a table using DBQuery. array_Vars.jpg The values are correct compared with the db table. I then use SetDialogProperty to update the dialog with the variable values. PROBLEM: only the Text boxes update. ListBoxes do not up...

I love it when it works

So big picture is that you just have to find the right Property you want returned.

Edit Box: Text
ListBox: SelectedItems
Check Box: State
ComboBox:

I have a form with both "Edit" and "ListBoxes" I can see the values for each type update in the watchlist as I step through my code. Problem Values from Edit Text properties are fetched properly using GetDialogProperty but values from ListBoxe Text properties fetch the entire list of entries in the ...

Hi there is no File Open in my main menu. I see it documented, I'm in Ver 14

Is there a shortcut, or other way to get to it?

//FYI the Database Reference is here:

https://www.mjtnet.com/blog/2008/04/15/ ... functions/

Thanks, my issue was with the spacing.

I had used the %s to stitch things together as per posting:
http://mjtnet.co.uk/forum/viewtopic.php?f=2&t=6457



Related links:
viewtopic.php?t=6856
viewtopic.php?t=1653

I want to concatenate String Part1 + CO_ID_string (from a user input window) + String Part2. How do I do this? Not yet in the online MacroScheduler docs. Those have really helped . let>string_part1 = DECLARE @RC int DECLARE @CO_NUMB varchar (15) SET @CO_NUMB = ' Input>CO_ID_string,Enter the CO_ID, l...

Ah, I see now. It's returning the number of rows affected. Works. Many thanks. quoting from: https://www.mjtnet.com/blog/2008/04/15/using-macro-schedulers-database-functions/ Modifying Data To perform any SQL statement that does not return data use the DBExec command. E.g. DBExec can be used for a D...

I have a simple script that calls a SQL stored procedure using DBExec since my stored procedure returns nothing. When I run/debug and hit the DBExec line I get the error: Missing parameters in function call (minimum of 3 expected) How do I interpret this error/fix my problem? I thought that DBExec i...