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!

  • Congratulations Mike Lewis 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: *

  1. jayfox

    Error 111 foxcode table not found

    Has anybody ever seen this error before? Foxcode table not found, is not correct version or is incompatible Error 111 Cannot update cursor 'client', since it is read only method: load line: 9 Please help!
  2. jayfox

    Error 111 Can't update cursor

    I distributed the app,on a different machine, using a setup program created by installshield. When I sign the exe runs fine. WHen a use sign on I get the error 111. How do I know if the file is readonly?
  3. jayfox

    Error 111 Can't update cursor

    Help - I distributed an app and I can't get it to work on user's machines. The error that I get is Error 111 can not update the cursor since it is read only. The table is not read only. If I log in to the machine and run it the exe runs fine.
  4. jayfox

    Backup exec errors

    Hello all - I have two servers one called Hamlet with windows 2003 and I have a buffalo terastation (don't laugh). Everything is getting backed up, but I still get a list of errors. 1. Backup- Hamlet V-79-57344-33928 - Access is denied. Acess denied to directory. Access is...
  5. jayfox

    Backup files doubling in size

    We compress our database files each night (in RAR format), then FTP them down to one of our servers at a different location. Generally the database files were about 800 megs. They have suddenly doubled in size the last few days. I am not sure what is going on. Any ideas? Thanks
  6. jayfox

    Update table A based on tableB

    It does not like the second select. Server: Msg 156, Level 15, State 1, Line 10 Incorrect syntax near the keyword 'select'. Server: Msg 170, Level 15, State 1, Line 14 Line 14: Incorrect syntax near ')'. Can you have two selects ina row like that?
  7. jayfox

    Update table A based on tableB

    Thanks I'll give it a try
  8. jayfox

    Update table A based on tableB

    Sorry I left out admitdate on table should be included
  9. jayfox

    Update table A based on tableB

    If I have two tables Table A: ID IOL Voced 1234 NULL NULL Table B: ID IOL Voced AdmitDate 1234 1 Null 7/1/2005 1234 2 3 7/3/2005 1234 Null NUll 7/5/2005 I would like to...
  10. jayfox

    crviewer report no display

    Damn! I thought that would work but it didn't.
  11. jayfox

    crviewer report no display

    When I run this I do not get errors but no report displays either. Also if I choose a report that requires a paramter then the parameter screen will display but when I hit OK the report again does not display...I can't figure this out. Any help would be great. Here is my code: Dim crysApp As...
  12. jayfox

    accessing remote server

    I access a remote server with pcanywhere in which sql server resides on that server. I just loaded vis fox on my machine how can I access sql server on the remote machine?
  13. jayfox

    DTS - Tab Delimited Header Question

    I understand how to create the DTS my problem is getting the header record to be included in my text file every time I run the DTS. Would I have to create a seperate table that holds my header record than insert my results into this table. Then execute the DTS?
  14. jayfox

    DTS - Tab Delimited Header Question

    I have a query that needs to be exported to a tab delimited file it alson needs to include the column headers. Everything is fine until I found out I need to include a header everytime which also needs to be tab delimited. How can I go about doing this with a DTS. Should I go about it a...
  15. jayfox

    Insert blank column into temp table

    How would I create a temp table where some of m columns I would like to leave blank heres what I tried but failed: I would like to leave the name column blank: drop table #test create table #test ( id varchar (5), name varchar (40), contact varchar (30)) insert into #test select customerid as...
  16. jayfox

    Remove spaces within a string

    I have some text data with htmls tags in it. I want to remove the spaces with in the tags Ex. <br><br> This is a test <font -1 type> result: <br><br> This is a test <font-1type> I only want to remove the spaces with in the brackets and not all the positions are the same in each cell thanks...
  17. jayfox

    Why does REPLACE behave differently

    I wish I can help you I'm having the same trouble and I can't figure this out
  18. jayfox

    Remove spaces

    That would get rid of the spaces but it will also remove the spaces in between the text I'm trying to pull out. When complete @desc = This is a test. If I do a replace it will read Thisisatest
  19. jayfox

    Remove spaces

    Hi, I'm trying to remove spaces and html tags from a text field. The functions work great when I test them on data I created but when I go to use them on the field where html data is pulled into they don't work. I can't get this function to remove the spaces. In return this function does not...

Part and Inventory Search

Back
Top