Search results for query: *

Hi all! I've been searching for a while, maybe you can help: I need an SQL Server Agent job to rename a file with the original filename + yesterday's date. I figrued out that I should use an Operating System (CmdExec) job step like this ren test.txt test-%date%.txt but I'm stuck with...

Hi all! I'm using the PrintDocument class for a printout in my application. In the OnPrintPage event handler, I populate the graphics object using the DrawImage() and DrawString() methods. The document can have up to 140 pages and is printed from the local workstation (a Windows 2000 machine)...

I'm sorry to bother you with this question - maybe it is really a newbie issue, but I'm new to the SQL Server Agent. I've written a script that calls a stored procedure on a linked server. If I execute this script on the local server, all is doing fine. Then I tried to execute this script...

Hi all! I've stumbled over a new problem and have not found anything yet on the Internet: I call a stored procedure (by another vendor) this way: DECLARE @return_value int, @AnzahlBenutzer int, @BenutzerSendefehler int, @Fehlerprotokoll nvarchar(max) EXEC @return_value =...

Hi all! Imagine a System.Collections list (e.g. an ArrayList or a HashTable) containing person objects with surnames. If you wanted to search this list for all people whose surname starts with a specific string (e.g. "Sm" when wanting to find "Smith", "Smithers", ...), which System.Collections...

Hi there! I hope one of you has already worked with owner drawn combo boxes. In my custom combobox, I have set DrawMode = DrawMode.OwnerDrawVariable, and the items in the drop down list all have variable height. This is working so far - but: How can I adjust the total height of the drop down...

Hi there, I'd like to know if the following is possilbe in C#: Consider the enum "DayOfWeek" which is already built into the .NET framework. I'd like to create a constant one-dimensional array whose elements should be addressable by the DayOfWeek enum, for example (pseudo-code!) const...

Hi all! I've got a form that depends on a query having the following two parameters: month, year (integer). If the user opens the form from the main access window, he has to enter both parameters before the form opens, and this is intendedly so. However in some circumstances I'd like the user...

Has anybody ever tried to open a .CSV file (comma separated values) with more than 256 values in a row with Excel? I get an error then. What I need is a possibility to somehow get the values of the columns 257, 258, ... into Excel. My file looks like this: 10.342,3.251,9.345,... (about 300...

Hi all! I'm programming a very RAM-expensive thing and I've come over the following problem: Until now, when all available RAM was used up on my test machine, Windows started to swap and the application got very slow. All of a sudden, the swapping didn't start any more when RAM was used up...

Hi all! I am working at an event simulation covering the evaluation of a self-organized TDMA network. With the time my code base got really big. After I started to run the simulation with a lot of actors (800 and more) the RAM consumption went up, though I had been very careful to free all...

I hope this is kind of the right forum for my question... I have been searching for a c++ programming environment (or an editor) under Linux/Unix that supports code completion in the Delphi/VisualStudio style (type a point and get all functions/properties/variables listed), and I have not found...

Consider this table: ID | Number | Name 1 | 10 | X 2 | 11 | Y 3 | 12 | ABC 4 | 13 | X ID is the primary key, and there is a unique index on Number. My program loads the table for editing (ID is read-only, Number and Name are modifiable), then checks through each line if...

Since we updated to the newest MySQL version (Windows) some of our queries do not work any more. It's reproducable by this (dummy) query: SELECT B.ID from ((SELECT * from A) AS T1 INNER JOIN B a ON B.ID = T1.ID); This works with 4.1.7, but not with 4.1.11, unless the parentheses are removed...

I'm using MySQL 4.1.7 and InnoDB tables. I'd like to lock some tables for (write and) read of other users during a transaction, like this: START TRANSACTION; LOCK TABLES T1, T2; ... ... UNLOCK TABLES T1, T2; COMMIT; Since I have AUTOCOMMIT=1, this does not work: "You should not have AUTOCOMMIT...

Hi all! I'm trying to sum up values from several columns, that way: id | val1 | val2 | val3 | type1 | type2 | type3 | val* are double columns, type* are integer columns. I'd like to select the sum of all val_i columns where the value of the type_i column = 4, so for this expample row id |...

Hi all, I am wondering why my program needs more memory the longer it runs - well it should not. I assume that I am doing something wrong with the dynamic arrays I'm using... I've got a fixed array of dynamic arrays holding records, e.g.: TReservation = record Directed: Boolean; Source...

Hi there, My program accesses an InnoDB database. I sometimes have to lock a table for a quite long time (10 seconds or so) to update, where I also forbid reading the table with a LOCK TABLE ... WRITE. When other users then try to access this table I don't want the program to be blocked for 10...

Hi there, I came over a strange thing today, that is: I have got an object A that manages several other objects and always passes them a reference to itself - using @self in the code. In two different procedures of this object I evaluate @self: procedure A.Proc1 (...); var temp: Pointer...

Is this a bug or a feature: I first create this simple table. CREATE TABLE Test ( ID INT UNSIGNED NOT NULL AUTO_INCREMENT, Name VARCHAR(10) NOT NULL, PRIMARY KEY (ID), UNIQUE INDEX (Name) ); Then I try to add the following two records: INSERT INTO Test (Name) VALUES ("Muller"); INSERT...