Search results for query: *

I have a report that groups data based on a formula. EX: formula-A (if field1 = "XYZ" then "A" else "B") Group1 grouped by formula-A I select data with a record selection formula: ((field1 = "XYZ" and field2 = 0) or (field1 <> "XYZ" and (field2 = 0 or field3 = 0))) Does this work...

How can I convert character strings containing international characters to normal characters? (Ex: convert Ñ to N)

I have created a windows application that uses a DataGrid to display and update data from two sql server 2000 tables. I use a DataAdapter to select the data and place in a DataSet, then I link the two tables using a DataRelation. I have two questions related to the properties of the DataGrid...

I am trying to ftp a pc data file to a mainframe dataset using the OBJECTX File Transfer Control (WDFTXCTL.OCX). Has anyone ever used this? I cannot find any help or examples anywhere. I don't know if there is anything that needs to be installed on my pc to use the control. I am using the...

I currently have a process in my vb program that ftp's a text file to a mainframe data set. I do this by executing a .cmd file from the vb program and returning a return value. The .cmd file is as follows: ftp -d -s:\\server\folder\ftptext.txt 10.9.1.2 where ftp is the ftp program that is...

I have a vb6 program that ftp's a text file from a server to the mainframe. The vb program executes a .cmd file that references a .txt file with a put statement. I put code in my cmd file to show me what the return code is. The ftp is completing successfully and giving a return code of 0, but...

I am trying to print a report that was created in Crystal Reports 7.02 from a VB6 program. I created a Crystal ActiveX control on a separate form and call this from my main sub using the following code: frmRptCntl.crwBondRpt.Connect=...

How do I accept a parameter in a VB 6 program from another VB 6 program? In the first program I am calling the other program with a line similar to this: sCommand = App.Path & &quot;\pgmname.exe &quot; & passedparm RunCmd sCommand The question is, how do I bring passedparm into the second...

I am using the full version of Adobe. I tried saving the pdf as an rtf, but this doesn't keep my tables, etc. I saved as an rtf, reformatted it in word, and made my changes. Now I want to convert to a pdf. I setup all of my bookmarks in word, but they are not there when I open up the new pdf.

How can I open a pdf file in Adobe Acrobat 5 and convert this to a word document for editing by one of my users? Also, how can I take a word document and convert to a pdf file keeping its bookmarks?

How can I create a role to use in all databases under a single server, rather than doing them one at a time for each database. I want one role defined for all.

How can I add a logon ID as a system administrator in SQL Server 6.5? In 7.0 you can go into logins, properties, server roles, and then check system administrator. I don't see anything like this in 6.5 though. Any advise?

Thanks Collin!!

As part of the upgrade to SQL Server 7.0 we are changing all &quot;= NULL&quot; to &quot;IS NULL&quot; in stored procs. I have one that declares a parameter as &quot;@parm = NULL&quot;. SQL Server 6.5 nor 7.0 will accept &quot;@parm IS NULL&quot; when declaring. Any advise?

That worked. Thank you so much!!

I am having trouble getting a char(7) that is converted to an integer to pad with zeroes in SQL Server 7.0. The statement is as follows: convert(char(7),RIGHT('0000000'+convert(char(7),convert(integer,isnull(tblname.column*100,0))),7)) This works correctly on 6.5, but when I test on 7.0 the...