Leo H's Q&A profile

• SQL Server Selct from a table and insert in other

  Hi I have these two tables.... CREATE TABLE [dbo].[TELEFONICA] ( [DATA_HORA] [datetime] NULL , [NRTELEFONE] [varchar] (255) COLLATE Latin1_General_CI_AS NULL , [TEMPO_SEGUNDOS] [real] NULL , [TIPO_PABX] [varchar] (2) COLLATE Latin1_General_CI_AS NULL , [LOCALIDADE] [varchar] (255) COLLATE Latin1_General_CI_AS NULL , [VALOR_TEMPO] [money] NULL , [VALOR_TARIFA] [money] NULL , [CLASSIFICA_PABX] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [NUMERO_DIA] [int] NULL , [CLASSIFICA_TELEFONICA] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [TIPO_TELEFONICA] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [VALOR_TOTAL] [money] NULL ) ...Show All

• Visual FoxPro use the reccount

  hello all  I use "set filter to" and want to know how much record is match the filter condition. I use the "reccount()"  but it return the result is not I want. it is all the record count Hi, i think you will need to use COUNT command instead. RECCOUNT() is not affected by SET FILTER. ...Show All

• .NET Development how do datacolumn.readonly and datacolumn.allowdbnull gets set using a DA?

  I am using a DA to connect to 4 SQL Server SPs for select, insert, update and delete. The 4 command objects of the DA are set and each command object has the correct parameters. I have some columns which are only in the select and should not be inserted or updated. I have excluded these from the insert and update SPs. Unfortunately, when I call FillSchema, the datatable seems to set these columns as required, even though they are not in the insert/update SPs. I have a timestamp column that gets set correctly as readonly though. So, how do these properties get set in the datacolumn and how do I make these columns readonly/allowdbnull Do I hav ...Show All

• SQL Server QueryResults object and MS SQL 2000 float fields - please help!

    # 1   1   (Rate This Post)   Today, 06:39 PM denisgr Junior Member   Join Date: Dec 2005, Posts: 2 Reputation: QueryResults object and MS SQL 2000 float fields - please help! Hi, I have a MS SQL 2000 server database, and in one of the tables a column is defined as float(8 byte). When I use the QueryResults object on it with getColumnDouble or even getColumnString the returned result is rounded up to one digit after decimal point. All the actual data if viewed through database manager has 2 digits after decimal poin ...Show All

• SQL Server Server Name problem

  Hi, I have chart on a report. If i access a report from the Reportserver by the IP address of the machine, the chart shows up otherwise( i.e if i invoke it with the machine name) it does'nt show What may be the problem Have you tried it with http://localhost from the server Sometimes underlines ( _ ) in servernames have strange effects, whats your servername ...Show All

• Visual C++ How to program with a tape driver through ASPI in MFC?

  I have been looking for some supports for programing with ASPI in MFC for a long time, but still can find nothing. Or the documents were too difficult to understand without examples. I want to control a AIT SCSI tape driver, such as reading, writing and sending command. But how to do this Than just goolge for "ASPI interface" Note that there are no standard ASPI drivers in Window NT, 2000, XP and 2003. You always need to third party driver to use it! (Adaptec, Nero...) ...Show All

• Visual C# ListBox

  Is there anyway to make a ListBox have a picture background I guess not. It might be more practical to design your custom listbox control with a BackgroundImage property. -Mamta ...Show All

• Visual Studio GAT Wrapper

  I am trying to develop a GAT infrastructure for other developers to create GAT tools without having to know all the details of GAT.  Is there a way to execute code when they select "File|New|Project|Guidance Pacakges|Guidance Package Development" (basically, customize the solution that GAT creates for you to develop a GAT tool)   I'd just like to make it easier for my teammates to develop their own GAT tools for use by the dev team we all support.  Anyone else run into this or have thoughts on an easy way to wrap GAT behind a nice user-friendly set of APIs   GAT is powerful, just not very user friendly (at this point) ...Show All

• Visual Studio Team System Do not have all services for MS SQL to run setup...

  Do not have all services for MS SQL to run setup... I installed the april version but it does not seem to have all the services... Could anyone give some help... I have a DVD of MS SQL but it just will not stay in my DVD drive heh it just pops right back out... More info My OS is WindowsSvr2003 Enterprice (Downloaded) and I used to have Windows XP Home but when my computer stoped working I had to delete all portions and format my hard drive clean and install an old version of windows so I could download WindowsSvr2003 thats all well that stuff was useless I'm sorry I can not subscribe... and I need a copy on ms sql developers edition I ...Show All

• Visual Studio Express Editions numeric data from database always displays as a date???

  Hi, I was wondering if anyone can shed any light on the followong (not sure if it's an Access or Vb problem). I am using an Access database with a field with numbers in in the format 00:00.0 (i.e 01:32.46 ) When I add this field to my form ( I have tried textbox, masked textbox set to 00:00.0, datetimepicker, datagridview) I get a date of 30/12/1899 00:01 displayed all the time. Also when I preview data it displays the same. I've also tried changing the data type(from the data source window, right clicking on the field and customise, then setting data type to various types) but this seems to default back to "date time" all ...Show All

• Windows Forms Blank forms

  I am using Visual Basic.NET with Visual Studio 2005 Beta 2 050215. I am trying to launch forms from other forms in an OOP way but all I'm getting are blank forms. Something like Dim c As New frmCustomer( Me ) c.Show() Me .Hide() only produces a blank form with no title or controls. Also, another funny behaviour is that when I come to choose a startup form from the project properties I only get one form (whilst I have some 4 others). Any ideas Eureka! The 'problem' was that I placed a parametrized constructor in my forms. This of course annulled the free parameterless constructor. I also forgot to call InitializeComponent fr ...Show All

• Visual Basic Loading Notepad as a Process

  Hi, The code below is for a service that fires every 10 seconds. If it doesn't find an instance of Notepad running, it loads it up. Please note that Notepad is only for a test, the final version of the software will run a program once at 22:00. The problem I have is that Notepad isn't loading fully. I get a Notepad.exe in the task-manager, but despite setting the properties, the actual Notepad application doesn't load for user-interaction! Can someone explain to me what I'm doing wrong please TIA Imports System.ServiceProcess Public Class Service1 Inherits System.ServiceProcess.ServiceBase Private _ProcessRunning As Boolean = False #Re ...Show All

• Visual Basic KeyEvent Questions

  I know how to get the key event of the application that I am working on, but how do I use the keyevent classes to capture general keystrokes For instance, if I want to mask a textbox to only allow numbers (I use VB.NET 2003), then I would monitor the keyevents for that specific textbox. What do I do if I want to mask a key or several keys for an entire program Would I have to put a mask everywhere or is there an easier way to do this. If you must know what this is for, then here is the skinny. My friend and I are what you would call pranksters. He just wrote this program and slipped it on my machine that made my mouse control go completel ...Show All

• SQL Server Getting sample databases in Management Studio

  How to get sample database AdventureWorks and AdventureWorksDW deployed in Management Studio. I selected to install sample database entire feature on my local hard drive and I can see it did installed all the .mdf,.ldf,.dim,.cube and the rest in C:\Program Files\Microsoft SQL Server\90\Tools\Samples\ How can I get the database in Management studio. I tried to use Attach db and it didn't worked, gave me following error Msg 1813, Level 16, State 2, Line 1 Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted. Msg 602, Level 21, State 50, Line 1 Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. ...Show All

• Visual C# Any good examples of how to use Applications settings

  Hi, I'm trying to use Application settings to persist the size of a window between sessions in c# Express. I've tried following the help files but it's all way too complex - I can work up to comlpex once I've got something working!  Does anyone know if there is a simple 'how to' anywhere, covering the basics What code do I need to add (to save ) What are the steps in the designer Many Thanks for any help Baffled The most painless and simple example of this is at: http://www.microsoft.com/uk/msdn/events/archive.aspx#section_p5 Go to the Winforms and and Smartclients section and view the preserving appl ...Show All