Search results for query: *

Will this Group By statement work with ANSI SQL: SELECT max(last_updated_dt) as max_dt, field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12, field13, field14, field15 INTO #temp_table FROM myTable GROUP BY field1, field2, field3 HAVING...

Hi, A user is FTPing a text file from a windows network file server to my HP UNIX server. When I receive the file it contains a CR/LF after every record. The file on his end doesn't have these CR/LF. Does anyone know why I would get these and what can I do to correct this? Thanks, Mark

I have two tables I need to run a query on. The first is has a company code and code order, the second has the customer information. I need to run a query that just lists the minimum code order for a customer based on the company code. There can be several rows based on the customer id. I just...

Hi, I am writing a query that uses the max function. I have: SELECT * FROM myTable WHERE term_dt = '01/01/1900' AND bus_type <> "G" GROUP BY id_num HAVING effect_dt = max(effect_dt) AND co_id <> "001" ORDER BY id_num This seems to work, but I am not comfortable with it. Is there a...

Hi I am updating a table and I am not sure update it based on a condition. I am using Sybase 11.92 I want to update from table1 to table2. Table1 has a field called term, it is either a Y or N. Table1 also has a term_date field. Table2 has two date fields, term1 and term2. I want to update...

I am updating a table and I am not sure update it based on a condition. I want to update from table1 to table2. Table1 has a field called term, it is either a Y or N. Table1 also has a term_date field. Table2 has two date fields, term1 and term2. I want to update term1 or term 2 on table2 with...

Hi, I am using windows 7 64 bit version and when I tried to update to SP1, everything downloaded fine, I disabled my spyware and virus protection, ran the file. It didn't give me any errors when it was doing the installation. The system rebooted and when it was applying the updates I got this...

I have a table that the following: Name Address City State Zip Phone_Type Phone Sample data would be: John Smith 1234 Fifth Street Chicago IL 60012 Home (312)5551212 John Smith 1234 Fifth Street Chicago IL 60012 Business (312)444-1212 John Smith 1234 Fifth Street Chicago IL 60012 FAX...

Hi, I have an old VB6 application I am maintaining. We are migrating from Sybase 11 to Sybase 15. I am retrieving information from a stored procedure and populating several fields. The problem I am having is that when I run the stored procedure in Sybase 11, it runs and populates the fields in...

Hi, I have users who are currently using Office 2003. I have a line of VBA code that gets the current network path of a file: BASICDIR$ = WordBasic.[FileNameInfo$](WordBasic.[MacroFileName$](), 5) In Office 2003 this give me something like: \\Ac0gant053\Contract\Production\Winword\ However...

Hi, I am migrating from hp unix to aix unix (version 5.8). When I run one particular perl script I am getting a memory fault (coredump) error. The only thing that I changed in the script was: current (hp unix) - #!/sbin/sh new (aix unix) - #!/bin/sh I am also using DBI instead of CT_LIB to...

Hi, I have perl scripts that are coming from hp unix and being moved to aix unix. On each perl script I have #!/usr/bin/perl -P. When I run this I get an error cc_r is not found in cppstdin file. However when I take out the -P that error message disappears and is replaced by Can't locate...

Hi, I have an old VFP 6 application that uses a select into statement to copy a file to a users root directory. SELECT * FROM address INTO c:\address I now need to copy that file to the users my documents directory. I have 30 users with different my document directory names. Is there a...

Hi, Our group is moving from an old version of HP Unix on an old server to AIX on a new server. There are perl scripts that need to be tested. I copied them from the old server to the new server. However, when I tried to test out the perl scripts, I am getting a file not found error. The script...

Hi, I need to import a text file on a unix server to a sybase table. The text file (mailing.txt) is comma delimited: name, address, city, state, zip, county The sybase file (maillist) I want to import the text file into is: name char(35) address char(50) city char(35) state char(2) zip...

Hi, I inherited a VFP6 program. When I go into design mode the form is truncated on the right side. I tried using the _screen command with no luck. How can I get the form to display correctly? Thanks, Mark

Hi, I am not sure if this could be done, but if I have a combo box using VB6 and I am adding items to it i.e. myCombo.Clear myCombo.AddItem("Green") myCombo.AddItem("Red") myCombo.AddItem("Blue") myCombo.AddItem("Pink") myCombo.AddItem("Purple") myCombo.AddItem("White")...

Hi, I just purchased Microsoft Office 2010 Professional. Before installing it, I uninstalled Office 2007 and rebooted. When I installed Office 2010 the installation went fine. However when I tried to open Outlook, it crashed. After doing some investigating I uninstalled all my add-ins in safe...

Hi, I have a VB6 application that takes a field and formats it using the StrConv function, i.e, "john smith" becomes "John Smith". The problem I am having is if I have a name like "Ronald McDonald" and use the StrConv function I get "Ronald Mcdonald" instead of "Ronald McDonald" Is there a easy...

Hi, I am not sure if this is the right forum but I need to put Sybase Client 12 on a Windows NT server that has SQL Server 7 on it already. Does anyone know if the two are compatible with each other. Will one step on the others toes if they are both running? Thanks, Mark