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: linousa
  • Content: Threads
  • Order by date
  1. linousa

    VFP Radio Buttons

    Any idea why this construct dosn't work? If Thisform.optiongroup1.Value = 1 Thisform.optiongroup2.Value = 2 Endif
  2. linousa

    How to overcome 254 character limit importing CSV or excel files

    How to overcome 254 character limit importing CSV or excel files? I have a table, I need import CSV with a few columns that are about 1000 characters long, maybe creating 4 fields for each, but how to split them?
  3. linousa

    Print PDF files to a specific printer

    I have a local folder that gets PDF files and depending on their file names I need to have them printed to a specific printer. Example: c:\print\pr1.pdf -> printer_1 c:\print\pr2.pdf -> printer_2 c:\print\pr3.pdf -> printer_3 ShellExecute leaves Acrobat open after printing: lcFile =...
  4. linousa

    Compound index

    Is it possible to create compound index with different orders: field1 asc + field2 desc + field3 asc?
  5. linousa

    ZIP & UNZIP

    What's the best solution to zip and unzip files/folders nowadays?
  6. linousa

    Extract text from pdf

    Is it achievable in vpf or better do it outside? I've been doing it outside for a while, it is fully automated and works fine, but I don't want to rely on third party and wanted to check what's on the table.
  7. linousa

    Export table to text without extra spaces

    Is it possible to export DBF without extra spaces that fill up to field length? Trying to get CRLF characters right after my data: and not(used- copy to "name" sdf):
  8. linousa

    JOIN without .NULL.

    Is it possible to change this query to have blanks instead of .NULL. values: Select t1.*, t2.ends, t2.imbc, t2.ord, t2.csz; from table1 t1 ; left Join table2 t2 ; on t1.unirec=t2.unirec ; into Table currentfile2.dbf Or may be even a better way to accomplish this, what I am trying to do is...
  9. linousa

    import XLSX

    I know there many topics/solutions out there dated all the way from 2007 and I've already spent hours and hours going through them without any luck finding that works well. Some of them will import all the data as memo records, others will have 600-1500 lines of code and when I run them, I get...
  10. linousa

    Merging two table's fields

    I have a question - I have 2 tables with the different fields and one unique key field(id) in both those tables and I need to merge all those 2 table's fields based on that id key field, number of records(rows) should stay the same, only the number of fields(columns) should change. Forgot to...
  11. linousa

    Arrange fields in table view

    Does anyone know how to move fields fast in browse view? Example: I added a new field in the table with 200 fields and as result I get it the last when I browse that table and I need to move to be the first one. It takes a while dragging it by hand. And moving it in table designer->fields...
  12. linousa

    How to pull one list from another

    What's the best way to pull one list from another? Have 2 tables and need to copy complete lines and delete them after: table to be pulled from 50K: janet john john jack joe joe list to be pulled 20K: joe jack
  13. linousa

    Data matrix barcode in FoxPro

    Converting from barcode39 to data matrix, barstring="1234567890asdfghjkl", any suggestions on easiest implementation? Thank you
  14. linousa

    Using Related Tables

    Have five related tables with one-to-one and one-to-many relationships, is it better to unite one-to-one ones together for cleaning and performance purposes? right now, it is a little bit confusing, having quite a few commands done with "tableX.fieldX" addressing. Any good resources(samples...
  15. linousa

    Replace in memo fields

    Have DB with 100K records with multiple memo fields each field have variable data, need to replace all "red" with "blue" in each record including memo fields. Any quick solutions?
  16. linousa

    Function: Mod10 check digit with weights of 7,5,3,2

    Need help writing code snippet for Modulus 10 check digit with weights of 7,5,3,2. As shown below: Thank you!
  17. linousa

    Sorting issues

    I have table, that I am sorting to by several keys(zip+recnum+..), but when I using commands like "replace next 20...", it applies those changes to the records from initial order before sort. So I came up with workaround- saving those tables to txt files after sorting and reopening them again...
  18. linousa

    FOPEN() or APPEND FROM

    How to import data to dbf from text *.DAT file, tried "append from ? sdf", but it is confusing users with it's .txt extension. FOPEN() can't make it to append to dbf.
  19. linousa

    RUN command

    Trying to run external application, but all I get is that MS-DOS window blink once, here is my code: cXFile = "C:\Program Files\abc\xyz.exe" Run &cXFile
  20. linousa

    foxpro IF statement with too many ORs

    If Substr(Alltr(field1),1,1)='#' Or Lower(Substr(Alltr(field1),1,2))='rm' Or Lower(Substr(Alltr(field1),1,2))='sp' Or Lower(Substr(Alltr(field1),1,3))='apt' Or Lower(Substr(Alltr(field1),1,3))='lot' Or Lower(Substr(Alltr(field1),1,3))='bld' Or Lower(Substr(Alltr(field1),1,3))='pmb' Or...

Part and Inventory Search

Back
Top