pjhunter's Q&A profile

• Visual FoxPro MS SQL Server or VFP Database???

  Hi every one, hi MVFPs, I am working with SQL Server database, but I wonder that I've got some big problem with SQL table that has more than 500,000 records. If there are about 50 connections access to that table with select, update,,, task, the SQL will become very slowly and return error message as: ....query out of time,,, or dead lock.... If I work with VFP database, there are about more 100 connections with command "use" the table, and so often tasks to seek, select, update.... but It still work well even if not too fast. And I have a VFP table with more than 1,5 billion records working hard like that. So now I don't know if I will working with VFP database or getting SQL instead because of the more security of usin ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Build for Xbox 360 and Windows in one project

  I have created a Visual Studio project template that can be built for either Xbox 360 or Windows, by selecting the correct platform in the VS IDE. There's nothing particularly clever about this, it just uses some of the conditional abilities of MSBuild projects to merge the properties of an Xbox 360 XNA project with a Windows XNA project. There's a slight problem though - the VS Express C# IDE has, by default, disabled the build configuration and platform settings to present a simpler interface to beginners. In order to use this project template you need to re-enable these features and should probably have a reasonable understanding of what they do. This could be the reason that the XNA devs have mentioned that building for both platforms ...Show All

• Community Chat Automator for Windows

  What I am looking for is something that is equvalent to the OS X Automator for Windows (preferably both XP and Vista). I have a few repatative tasks that I have to perform in my daly work and if I had something like the Automator in OS X for Windows I would be able to script those tasks and save extra clicks and some time every day. For example I would like to copy a word file that I have sitting on my desktop and then once it is copied to that directory I would like to have it e-mailed to a certain person. Right now the best way of doing this that I know of is to add a shortcut to the "Send To" context menu for the folder location that I want the file copied to and then use the "Send To" context menu as my poor man' ...Show All

• Software Development for Windows Vista XPS and StartDoc

  I was trying my application on the latest Beta 2 release of Vista and found some weird features when writing out to XPS. In my application the user has the option of going into a print layout window. This layout window allows the user to place the desired application related objects on pages for printing. When the user goes into the dialog, I go create a printerDC based on the default printer and hang on to that DC until the user closes the layout window or changes to a different printer. While in this dialog, the user can change how the objects are layed out and print at any time. Inside I call startDoc with just the application name and when saving to an XPS the first time, the XPS file is generated successfully. If I write to a di ...Show All

• SQL Server Msg 8621: The query processor ran out of stack space during query optimization

  I got the above error when I tried to execute the following query delete from BUSINESS_ASSOCIATE where ba_name is null As you can see the query isn't exactly complicated. What the table does have is lots of dependancies. I got SSMS to show me all the dependancies and there are literally hundreds (maybe thousands - I'm not going to count them all) of dependant tables and i suspect that is what is causing the problem. So what do I do about it This is a valid data-model (industry standard in fact) but SQL won't let me delete data from this table and that's a huge problem for me. Any advice about how to progress would be welcomed. -Jamie Jamie Thomson wrote: Hi guys, I sure can. ...Show All

• Audio and Video Development Associating Markup with Specific Titles?

  I want to create three menu systems and I want them associated with three specific Titles. So really I have three different views. Can I put those into three separate markup files and associate them to the appropriate title You could make them three different applications and load the application in the <title> element that would use it. This has the advantage that you wouldn't be polluting each application with graphics it doesn't need, but the disadvantage that you'd have to do something extra if they needed to share information of any sort. If the menu systems are completely independent, then making them 3 different applications is almost certainly the way to go. ...Show All

• Visual Studio Express Editions slideshow

  how can I alter this code so it displays a different image every minute.....like slideshow thanks PictureBox1.Image = Image.FromFile _ (System.Environment.GetFolderPath _ (System.Environment.SpecialFolder.Personal) _ & "\Shell2.jpg" ) ok thanks I will have to play with it renee cos at the moment every time I enable the timer the pc hangs.... maybe the pc is not up to the task......cos there is smoke coming from it at the moment.....only joking ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. ID3DXSprite Positioning

  I was wondering if anyone knows how ID3DXSprite generates the quad that it renders when drawing billboards in 3d space ...Show All

• Visual C# how can i change the string?

  hi all i'm coding an evaluator program.in these program i'm taking a equation with x parameter.the equation is str1 and the x parameter is ara.ara is char.the code is below.but i cant replace the x parameter with ara.where's the mistake while (index < str1.Length) { c = str1.Substring(index, 1); if (c== "x" ) { str1.Replace( 'x' ,ara); MessageBox .Show(str1); } index++; } Also, the rest of the code snippet (manually searching the string for an "X") is pointless. The replace it going to do it's own search (and not replace anything of no "x" is found). The entire thing can be replace with just str1 = str1.Replace("x", ar ...Show All

• SQL Server Getting "Report Server WMI Provider error: Not Found" while configuring Reporting Sevices Integration WSS 3.0 and Sql 2005

  I'm Getting "Report Server WMI Provider error: Not Found" when trying to Grant Database Access while configuring the Reporting Sevices Integration. Logging in fine to the DB. Tried all the WMI troublshooting and can't find any issues there. Any tips Many Thanks!! Hi Prash, I'm using WSS3.0 + MOSS 2007, so switch RS to "SharePoint Integrated Mode" would be best fit and thus can use the RS wbe part to render the reports in an easy way. However, I can still not pass the "Grant Database Access" page, it pop-up: The group name could not be found Any advice Paul ...Show All

• Windows Forms SendKeys.Send("+?") doesnt work ?

  Hi, I wrote a transliteration conversion program with Keyboard Hook, works like a charm, except of one thing - combination SendKeys.Send("+ ") doesn't work ("A" here is a russian "A", and "+" means SHIFT). All other letters work fine: SendKeys.Send("+ ") SendKeys.Send("+ ") SendKeys.Send("+ ") ........................ No problem, except SendKeys.Send("+ "). It is the same as SHIFT+SendKeys.Send(" ") - doesnt work either. In two words, I can't print a capital russian A, by pressing SHIFT-a. Any ideas why SendKeys.Send doesn't work with only this letter hi, Please go through the below link. Hope this gives you some idea. http://msdn2.microsoft.com/en-us/library/system.windows.forms.sendkeys.send(VS.80). ...Show All

• SQL Server SSIS FTP Task Variable Remote Path invalid

  I am working on the SSIS FTP Task that transfer file from one FTP server to local location, rename the file name, and finally transfer the renamed file to another FTP server. So I defined 2 FTP tasks. For the FTP file receive operation, I need the remote path to be updated by a script and pass to the user define variable. So I set TRUE to IsRemotePathVariable. In the RemoteVariable, I set User::FTPSourcePath where the variable is set in the script with "/DMFTP/filename1.jpg" For the FTP file send operation, I set TRUE to IsRemotePathVariable. In the RemoteVariable, I set User::FTPDestPath where the variable is set in the script with "/DestFTP/" After all the setting, the FTP Task box show me the error as " ...Show All

• Visual C# Change System Timezone Programmatically

  Hi, By using System.Timezone.CurrentTimezone I can get the DST Dates of it, is there a way to change the system timezone so that i can use the CurrentTimezone for other timezones Thanks HI, to make things clear, I would like to change the Timezone of the System (Programmatically using C#) then I will use the System.TImezone.CurrentTimezone to do the things I wanna do. Thanks ...Show All

• SQL Server Reporting Actions - optional parameters

  I`m trying to build a Reporting action based on an Analysis Services Cube that passes parameters to a predefined Report. With one optional parameter it sometimes works, but always fails when adding a second one with the error message picted below. ______________________________ A list of actions for the selected items cannot be obtained because of the following error. Action(Report Action) (1, 1) Typkonflikt beim +-Operator. Systemfehler: Invalid procedure call or argument. This error may have occurred because the definition for at least one action is not valid. Verify the definition for each action using the Actions view. ------------------------------ ADDITIONAL INFORMATION: Action(Report Action) (1, 1) Typkonflikt be ...Show All

• SQL Server How do you get the last modified date column in SQL Management Studio

  In 2000, the last modified date was show as a column when viewing the various database objects. So, after a long off-line session with a copy of a database, you could sort the query list, by last date modified, and script the recently changed queries to a file. It was very easy to see exactly what was changed recently. How do you do this in 2005 thanks Custom reports and the same kind of reports as the reports that come with SQL Server 2005 except that you can create your own. So you could create a report for database, attach it to the Object Explorer node of any database and the report will run and show you information about all the table in that database. Custom Reports are unrel ...Show All