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

Would it be better to say the following: SELECT field1, field2, field3, field4, effect_dt, field5, field6, term_dt, bus_type, co_id, field8, field9, field10 FROM myTable GROUP BY field1, field2, field3, field4, effect_dt, field5, field6, term_dt, bus_type, co_id, field8, field9, field10 HAVING...

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 using Sybase

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

What I ended up doing is writing the following code to get the network path to the open document: Dim oDoc As Document For Each oDoc In Documents If InStr(1, UCase(oDoc.Name), "MYDOCUMENT") > 0 Then sPath = oDoc.Path + "\" Exit For End If Next Since MyDocument.doc is the...

Word Basic macro

The template is located in the \\Ac0gant053\Contract\Production\Winword\ directory, so I am trying to get the network path of the template. What I am getting is something in my documents and settings directory which looks like a temporary copy of the template word put there.

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

here is the contents of the cppstdin file. cat >.$$.c; rm -f .$$.u; cc_r ${1+"$@"} -M -c .$$.c 2>/dev/null; test -s .$$.u && awk '$2 ~ /\.h$/ { print "# 0 \""$2"\"" }' .$$.u; rm -f .$$.o .$$.u; cc_r -E ${1+"$@"} .$$.c; rm .$$.c I don't know c++ but could this be a make file (c++ standard...

You were right, the first line of the perl script was different than the directory perl was in. I changed it to #!/usr/bin/perl -P and I got rid of the file not found. However I am now getting another error message stating: /usr/opt/perl5/bin/cppstdin: cc_r: not found Do I need to path to...