Search results for query: *

I am attempting to insert values in an SQL server 2000 database table into an Excel spreadsheet. I've tried the same code on an Access database (with the connection string modified) and it works fine, but when I run it on my SQL server table it falls over with a Run time error - 1004 Application...

Does anyone know where on the system tables i can find information as to whether a table has a primary key or not? I've tried using sysobects and sysindexes (keycnt), but this doesn't appear to be correct. I'm attempting to add primary keys to existing tables and want to check whether they exist...

How do I add a primary key to a column that already exists. I've tried: ALTER TABLE dbo.CensusSourceData_Ilot ALTER COLUMN Column1 ADD CONSTRAINT Column1_pk PRIMARY KEY but that doesn't work. It seems a simple thing to do, but I can't see how to do it anywhere on the web. Any help would be...

Does anyone know how to automatically turn off warnings in an Excel VBA module? I need to automatically confirm that I want to keep data on the clipboard to paste later, and then to automatically overwrite an existing file without prompting. If anyone knows how to do this it'd be great. I have...

Does anyone know of any ways to create a csv file output from a COBOL prog? This is with varaiable length fields, depending on what the fields contain. So if a field contains 10 it will output 10 as 2 bytes, whereas if it contains 1000 it will output the 4 bytes. If anyone knows anyway to do...

Is it possible to add a progressbar to a form on which a query is running, like when you run a query in Access? I have tried various things, but have not found a way to do this. If anyone knows it would be most helpful. Also when I run the code below from a click even on a command button the...

I am try to write some code that will inside a loop define and create two queries - the first a crosstab query, then from this run a make table query on it to make it permanent. Inside my For Next loop I have the below code: sql_1 = "TRANSFORM Sum([Sample].[" & sumvar & " 2002])...

Does anyone know if it is possible to construct a COBOL program on a MVS mainframe and pass arguments to it in much the same way you would pass arguments into a VB program? If anyone has any advice please let me know, thanks, Matt

I am looking for some help with a COBOL problem: the problem is basically verifying an variable length input file is a valid record and if not change the input file definition to correct for this. The code as is stands is: 03 FILE1-RECORD. 04 FILE1-INFO1 PIC X(90)...