Hi All,
Anyone know how to mimic a keypress within the mousedown event? When the user left clicks the mouse on a listbox, I want to add a CTRL press with it.
Hi all,
When using the GetString method to decode bytes into a string, I am having an issue where the string is incomplete. The decode works fine and the return string can be used as a value into a textbox or messagebox, but not for reference to a file path or anything of that nature. I am...
Hi All,
Using SQL Server 2005 w/ SP2 I have a simple select query with a parameterized WHERE clause that in Management Studio runs nearly instantly, everytime. Using the same login, when I run the same query using SQL RS the results (only 6 rows) takes upwards of 5 minutes. If I look at the...
Hello all,
I am looking for a way to query a PC on my domain either by IP or PC name and find out the user name that is currently logged in. Anyone have any starting points on this?
best regards,
Bill
Hi all,
While trying to install IIS on a WIn2003 Standard edition, I get an error: "Setup cannot copy file xxxxx.xxx (it happens on every IISx file it looks for) Please insert the service pack 2 cd-rom and retry" I installed sp2 from windows update. I can point the setup to the directory that...
Hello all,
I have a report with a table and a chart. It uses dataset1 as the data source.
All works fine.
I create a new dataset called dataset2.
The queries are exactly the same. The only differences between the 2 datasets is the database server and the fact that one of the columns is a...
Hi all,
Search is not working still, so I have another one. How do you change the login name for dbo? I want the dbo account to carry the sa login. I created the database under my login and it is now dbo's login.
regards,
Bill
Hi all,
Is there a way to generate a script from existing user roles that will include all permissions that role carries?
i.e.
grant execute on <table1> to <role>
grant execute on <table2> to <role>
etc.
thanks in advance.
Bill
Hi All,
Is it possible to pass a multi value parameter from one report to another using the "jump to report" feature?
ie;
I have report A that has a mutli value parameter (para1). This report has a link with the action property set to jump to another report(Report B). Report B requires the...
Hi All, Can someone give me a hand with the syntax to accomplish the following?
Table A
SERIAL UPTIME_MINUTES
A123 60
B456 50
C789 40
Table B
SERIAL REASON DOWNTIME_MIUNTES
A123 POWER 10
A123 WATER 20
A123 POWER 50
B456 ICE 10
C789 FIRE 50
C789 POWER 40
desired results
I want...
Hi all,
I am using SQL RS 2005 and need to find out if it is possible to use the "jump to report " action and have the report open in a new window?
regards,
Bill
Hi all,
Can someone explain to me why MS returns the following values with these function calls?
convert.toint16(1.5) = 2 (this is expected)
convert.toint16(2.5) = 2 (huh?)
convert.toint16(3.5) = 4 (this is expected)
convert.toint16(4.5) = 4 (huh?)
the same is true for math.round. Can someone...
Hi All,
I have an issue when I alter a stored procedure. For instance, I have 3 different SQL 2K servers. All 3 are identical. Recently I made a change to a SP on all 3. On 2 of the servers , all was fine. The SP ran as usual. On the third, when I run the altered SP, it will just hang. Very few...
Hello all.
I need a hand with a query, and need to ask for your brain power. This is very similar to a post I made in the past, which I thought I had working, but I still have an issue.
I have 2 tables
Table MAIN_TABLE
F_NAME
L_NAME
MINUTES_WORKED
Table VACATION_TABLE
F_NAME
L_NAME...
Can someone explain to me why I can convert.tostring and Ctype the ExecuteScalar result if a command object with no issues, but if I use the Trycast operator the value returned is always nothing?
Say my sql text returns the string value "Tek-Tips"
Convert.tostring(cmd.ExecuteScalar) returns...
Hello,
In my quest to find a workaround for the lack of support for FTP to an AS400 in CF 2.0, I have set up a hidden share on my AS400. My thought behind this is to do a simple file copy from a Windows based machine to an AS400. Problem is the AS400 is going to require credentials to allow the...
Hi all,
I am getting an odd error during an FTP to an AS400. It happens completely at random. I can sometimes ftp 50 files with no error, and other times 2 errors in a row with the same files. This machine can FTP via CF 1.1 without error as well as with any other FTP method I have tried. Like...
Hi All,
When I open a particular project in VS2005, VSS prompts me to check out the startup form. When I close it it prompts me to save changes to that form. No changes have been made. Does this sound like a VSS issue or is VS2005 modifying the project on load?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.