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...

Thanks guys. Was starting to get a little frustrated there. All is working now.

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...

Cheers, you are a genius. It works a treat. Can't see why that worked and the other didn't, but hey who are us mere mortals to questions Microsoft's code?

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...

Thanks, tat is very helpful. I'll try coding that into my program and let you know how I get on, thanks, Matt

I'm using IBM COBOL FOR OS/390 & VM 2.2.1 (in an MVS mainframe environment). TonHu, what version of COBOL is that for? I can probably do this, just the way I'd be doing it would be byte by byte as I can't really see how my output format would look tho. I've done the fixed field length with...

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...

Sorry about the above post, I did include the code, but I was posting from where i work and it is behind a firewall that strips VB code i think. I will post the code tomorrow as I don't have it with me right now. Thanks for your suggestions. I am using VB6 to connect to an Access 97 database. I...

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])...

Thanks a lot everyone for your help and support, I kinda worked out the first way (the subprogram route), but it is very useful to know the JCL parameter way. Matt

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

Thanks for your advice, I have now rectified the problem. You were right in thinking i meant alphabetic rather than alpha-numeric data. I did use a similar approach to what you mentioned. As to why the field should contain an incorrect value, I don't expect this to occur. I just needed to code...

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)...