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: *

  1. gfrlaser1

    Relaional data query with replace

    Worked perfect!!
  2. gfrlaser1

    Relaional data query with replace

    Thanks again! I did try to figure out a way to use SQL. Not my strong suit. I found you have to use SQL a lot to really be proficient with it. I'll give that a shot for practice. :-)
  3. gfrlaser1

    Relaional data query with replace

    Thanks!! I will work with this. Helps a lot.
  4. gfrlaser1

    Relaional data query with replace

    I have two databases I am trying to replace a fields in one. I know it might look crude, just after functionality. My question is why does the statement on the very last line only replace one record that matches when the usaworking has multiple records that match the customer field? SET SAFETY...
  5. gfrlaser1

    xml to table as character problem

    I am importing from an xml using simple statements such as: Xmltocursor("&Mxm", "cxm", 512) however, on field in the xml is needed as character I my new table. The problem appears to be that there is a '-' in the xml field. As an example in xml it is 45987-8. on import to cursor, the field...
  6. gfrlaser1

    open view without login screen

    That worked Olaf! Thanks!!
  7. gfrlaser1

    open view without login screen

    No. that didn't work either. I checked and indeed no password is required. Should I be trying a connection string instead? I don't know what Management Studio is.Has me stumped on what to do.
  8. gfrlaser1

    open view without login screen

    In the query, I used remote view wizard, opended data2 dbc, selected ODBC data source, selected my data source. This appears fine. In the ODBC Data Source Administrator, I have the userid stored. It is named it Mycom. It appeers to be fine. Again, there is no password required.
  9. gfrlaser1

    open view without login screen

    Ok, this looks like it will do what I want and get me closer to finishing this. However, I am in Connection Designer. I used the drop downdown to highlight my data source, filled in Userid, there is no password, and added data2 to the database field box. I then checked off never for 'when login...
  10. gfrlaser1

    open view without login screen

    Creating and using remote views is new to me. I figured out how to create a remote view using the wizard. Now I am attempting to create a small program that opens the view and copies it to a dbf file. So far so good. I have this: USE Data2!mycom IN 0 ------------------> login screen opens up...
  11. gfrlaser1

    Searching drive for a string

    yes! Thanks to you all. Mike your sample code was something I can understand adapt to my needs. Have a great 4th everyone
  12. gfrlaser1

    Searching drive for a string

    thanks for the replies. This looks a bit over my head. I will give it a shot though.
  13. gfrlaser1

    Searching drive for a string

    I've searched this forum with no success. What I am trying to do is locate a string of text in one file, in one folder of one drive on my network. The string is always unique. For Instance, I want to find the string "123456789123456" that is contained in any of the many .csv files in the folder...
  14. gfrlaser1

    Copy a PDF to a new PDF

    Thanks Olaf. I was sure there had to be a simple simple solution.
  15. gfrlaser1

    Copy a PDF to a new PDF

    This code works great for me to open a pdf however, what I want to do is not open it but have it saved as a new pdf. For instance when the operator chooses MYPDF from the form, it would not open it per se, rather it will copy it, create the temp.pdf and then open TEMP.PDF. I want to do this to...
  16. gfrlaser1

    Cursor jumping around

    It seems "thisform.tdisplay.refresh" was in the timer and not the init. I think that's what it was.
  17. gfrlaser1

    Cursor jumping around

    turns out it had to do with the clock. Got it solved.
  18. gfrlaser1

    Cursor jumping around

    This is something i've not seen before. My cursor is bouncing around in the field of a form. generally it is moving to the right most of the field as I enter information into it. Doesnt seem to matter if its a text field or a date field. I have tried using different fields as the control source...
  19. gfrlaser1

    link in email

    Thanks everyone, finally got it to work great thanks to your input.
  20. gfrlaser1

    link in email

    One more question if I may. One of my folder paths is: Y:\Digital Output Files\Working One-Off's\data. I am adding the final path as a variable <<mpre>>(for instance "\53698". When I hover over the final link in completed email,it looks perfect however, once I click the link it says "cannot...

Part and Inventory Search

Back
Top