Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mark1110
  • Content: Threads
  • Order by date
  1. mark1110

    Group By Question

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

    FTP Adding Extra CR/LF After Every Record

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

    Need help with Group By in Query

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

    MAX function question

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

    Update Question

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

    Update Question

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

    Error Updating To SP1

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

    Getting Multiple Rows Into One

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

    Sybase 11 to Sybase 15 slowness

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

    Moving To Office 2007 Broke VBA Macro

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

    memory fault (coredump) error when I run a perl script

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

    perl -P option

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

    Copy File To My Documents Folder

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

    File Not Found Error

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

    import text file into sybase table

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

    form truncated in design mode

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

    Grey out item in combo box

    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")...
  18. mark1110

    Outlook 2010 Crashes With Microsoft Exchange Add-In

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

    String conversion problem

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

    Sybase Client And SQL Server 7

    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

Part and Inventory Search

Back
Top