CJPO's Q&A profile

• SQL Server Creating a UDT Type with create assembly

  I created a UDT Type (using MS Server Express Edition  and Visual Basic 2005 express) but I get some errors: Msg 6556, Level 16, State 1, Line 6 CREATE TYPE failed because it could not find type 'UDTProj' in assembly 'UDTProj'. Msg 6597, Level 16, State 1, Line 6 CREATE TYPE failed. That is my code: Public Structure UDT_interval Private adresse As String Private beginn As Date Private ende As Date End Structure ************in Transact-SQL //register the UDTProj assembly USE TestData; CREATE ASSEMBLY UDTProj FROM 'C:\MS Visual Studio\MyOutput\bin\Release\UDTProj.dll ' WITH PERMISSION_SET = SAFE; // create the UDTProj type CREATE TYPE dbo.UDTProj EXTERNAL NAME UDTProj.[UDTPro ...Show All

• SQL Server exporting more tha 65k rows to excel

  hi all, I wanted to know how to export a report that returns more than 65,000 rows of data to MS Excel, it will fail because excel has a limit of 65K records per excel sheet. What i want to know if there is some way to use multiple sheets (in the same excel file) to show more than 65K records Eg we have 105K rows of data ...can we export 65K records in the first sheet, and the remaining 40K in the second sheet (of the same excel file) Appreciate the Help, Siddharth Hello Siddharth, Using a Table, you can force an explicit page break after a certain number of rows. Because the Excel renderer creates a new worksheet for every explicit page break, you can use this technique to make sure ...Show All

• SQL Server Run time variable setting

  Hi, I want to execute a BAT file using Execute Process task, where I want to select the file path (directory) dynamically using a variable whose value is set at runtime. In simple terms I want to send a value to the "Executable" property dynamically Can some one help me on this This is definitely a possibility. I have done this many times. Follow these steps: Go into the Task and to the left of the task editor click on the expressions. To the right you will see "Misc" and below that "Expressions". Click in the box to the right of the expressions. You should see an ellipse or "..." button. Click it. The "Property Expression Editor" will appea ...Show All

• Visual Studio Express Editions Problem compiling multiple file application

  Hi, I am trying to compile my code from several small files, as it was getting unweildly in a large file. I ave simplified my problem somewhat, and if I could solve this example the rest may flow. file 1: aaa.hpp #ifndef AAA_H #define AAA_H #pragma once class aaa { public: aaa(char *str); void setFile(char *str ); int record_count() ; private: char filename[256]; // filename of the data file for the data int numrecords; } ; #endif file 2: aaa.cpp #include "aaa.hpp" class aaa { public: aaa(char *str) { // Constructor std::cout << "\n\n----------\nData for:" << filename << "\n" ; } ; void setFile(char *str) { strcpy_s( filename, str ); // store ...Show All

• Microsoft ISV Community Center Forums adding text to cell with vba script

  I've done this before but I am completely blanking on what I am doing wrong with adding text or in this case a formula to a cell. The line I have and am getting an error on is Workbooks("DSL Annual Rollup").Worksheets("DSL Annual Rollup").Cells(i, 3)="January!D"&i&"February!D"&i&"March!D"&i&"April!D"&i&"May!D"&i&"June!D"&i&"July!D"&i&"August!D"&i&"September!D"&i&"October!D"&i&"November!D"&i&"December!D"&i Wow, no wonder everyone uses &. + adds the numbers. Anyway, I don't use variant, so ...Show All

• Windows Forms dataview count doesn't shows properly.

  Hi I used dataview for a subset of rows , from a datatable. In that subset, there will be zero quantity and non zero quantity rows . and there may situation to move quantity value  from one row to another row.(may be quantity can be moved from an existing row to a newly added row). after that non zero quantity rows has to be deleted. the dataview.item(i).delete works fine for, if I have more than two rows(either non zero or zero). The Problem is if I have Only one zero quantity row and another non zero quantity(newly created. quantity is transferred from that zero quantity to this new row). If I made attempt to delete that zero quantity rows. it deletes both  row.(ie., the dataview.count shows 0 inste ...Show All

• Audio and Video Development Menus not showing up on WinDVD HD (Toshiba Qosimo)

  Hi all, this maybe isn't the right place to discuss compatibility with players but maybe somebody tried to get things to work on a software player before. My project is working fine on Microsofts iHDSimulator and the Toshiba HD-A1 standalone player. But when I try to run it with WinDVD on the Toshiba laptop (the one with HD DVD Rom drive) the software either crashes or just plays the menu video without the graphics. Any ideas Are there any known issues for the WinDVD software Cheers, Gunnar I finally got it working. The problem were relative urls. This works: url('file:///dvddisc/ADV_OBJ/TEST.ACA/Image.png') ...Show All

• Smart Device Development Reg: WM_KEYDOWN

  case WM_KEYDOWN: switch(HIWORD(lParam)) { case VK_T1: // code piece 1 break; case VK_T2: // code piece 2 break; } break; im working on Smartphone 5.0, when i press numkey1 on the phone the "code piece 1" gets executed, rightly so...... but when i press numkey 2, the "code piece 2" doesnt get executed, can you help me through this, i hv no clue why this aint working. ...Show All

• Visual C# Checklistbox problem in new domain...

  Hello, I have a window app written in c# that contains checklistbox. I had the statement clearselected() to clear out the checked checkboxes when the user loads the new case... Everything worked perfectly until my users got converted to new domain. Since they got converted to the new domain, the checkbox is no longer cleared out on pageload. Whatever the user selected in the previous case remained checked for the new case. The problem is: the application will not do anything because there are nothing actually checked (the checkedindices collection is actually cleared)! The user either has to shutdown the app or manually uncheck/recheck the items in order to add them to the checkeditem collection. The situati ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Trying to move ContentManager to another class

  After successfully building the "How to Render a Model" example in the XNA docs, I am trying to move: myShip = content.Load<Model>("media\\ship"); to a separate class and I was getting: Error 1 The name 'content' does not exist in the current context so I changed it to: myShip = Game1.content.Load<Model>("media\\ship"); and then I got: Error 1 'Game1.content' is inaccessible due to its protection level so I changed ContentManager content; in Game1.cs to: public ContentManager content; and now I get: Error 1 An object reference is required for the nonstatic field, method, or property I'm stuck now. Ideas Thanks! Greg I've been hearing that the cont ...Show All

• Visual C++ partial serialize/deserialize a structure

  Hello everyone, I have a large number of strcture instances, the I can not have all of them in memory. So I have the idea of serialize/deserialize partial of them to/from disk. The operation I need on these structure instances is to enumerate elements one by one, and I want to provide applications which use this interface to enumerate elements be transparent to how and which parts of structure instances is written/read to/from disk -- and the application only will feel read from memory. I am wondering whether there are any samples/tutorials to make a reference thanks in advance, George Enumerating elements won't be possible, unless you're using C++/CLI and reflection. For native C++, see http://www.boost. ...Show All

• Visual Basic OCR - Optical Character Recognition

  Hi Everybody, I was recently pursuing code that would allow me to read machine text off an image. The text will only consist of characters a-b, 0-9 and a few special characters (+,=,-,@,&). I have pursued a few third party OCR controls however all require licenses to be fully functional, would anyone know of any third party OCR controls that does not cost anything If not is there anyway i can build my own OCR control that will read machine text Thanks In Advance, TheDarkestShadow Okay cool, ill go check out the Office forums. I actually used the OCR in Microsoft Document Imaging (Start Menu>Programs>Microsoft Office>Microsoft Office Tools>Microsoft Document Imaging) and after ...Show All

• Software Development for Windows Vista Problem with Windows Workflow Foundation RC2

  Hi, I installed WF RC2 and tried running the SQLDatabase Activity Example. But i am not able to view the workflow designer.I get the error which i have mentioned below. "Error Loading Workflow An error occured while loading the workflow.Please correct the following error and try reloading the document to view the workflow. Theme properties can only be changed in the theme configuration dialog." I was able to view the same sample using WF Beta 2.2 version.But after installing the RC2 version i get this error.Kindly help me solve this issue. Thanks in advance. Karthick. Karthick, sorry for the delayed response. If you open the SQLDatabaseDesigner.cs file you will s ...Show All

• Visual Basic unique constraints

  how can i set  empid,logdate and loantype=1 as unique let say   empid            logdate             loanid              1000              1/1/01                1                1000            1/1/01             &nb ...Show All

• SQL Server can't connect to SQLCMD

  dear sirits my first time to work with SQL server 2005 i've installed it and tried to connect to sqlcmd by : run sqlcmd i got errors after that i logged to the database engine normally and created new database and tried again to relogin to the database engine but i failed and faced error:4064 i have three points needed to be answered : 1- SQLCMD loin problem 2- database engine error:4064 3- i need to import .mdb file to my new database regards 1. See your post http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=671937&SiteID=1&mode=1 2. The user you are currently trying to login with does not have the appropiate permissions to the assigned default database or the database does not exist an ...Show All