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

    VFP Radio Buttons

    VFP9SP2. Created a new form from scratch and it worked![banghead] Now will be checking why it doesn't in my app... Thank you.
  2. linousa

    VFP Radio Buttons

    it doesn't change selection...
  3. linousa

    VFP Radio Buttons

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

    How to overcome 254 character limit importing CSV or excel files

    It worked, thank you guys! [bow] P.S. atlopes, Will it be hard to add field overflow feature to CSVProcessor? [thumbsup2]
  5. linousa

    How to overcome 254 character limit importing CSV or excel files

    Sorry guys, I never used OOP in vfp before! atlopes, When I am call it from button.click event on the form with your snippet: myearwood,
  6. linousa

    How to overcome 254 character limit importing CSV or excel files

    Added csvp.prg with: DEFINE CLASS CSVP_AllVarchar AS CSVProcessor FUNCTION ScanNumber (Source AS String) AS Number RETURN .NULL. ENDFUNC FUNCTION ScanLogical (Source AS String) AS Boolean RETURN .NULL. ENDFUNC FUNCTION ScanDate (Source AS String, IsTime AS Boolean...
  7. linousa

    How to overcome 254 character limit importing CSV or excel files

    How do I change field types? Is it possible to have them hard coded, all be varchar's?
  8. linousa

    How to overcome 254 character limit importing CSV or excel files

    Came up with the temporary solution, assuming max 508 character limit for each of those 4 memo fields: Select *,; LEFT(variabletext1,254) As v11, ; LEFT(Substr(variabletext1,255,254),254) As v12, ; LEFT(variabletext2,254) As v21, ; LEFT(Substr(variabletext2,255,254),254) As v22, ...
  9. linousa

    How to overcome 254 character limit importing CSV or excel files

    Not sure how to call table designer on cursor, so I save to free table(copy to). This is what I get now: It is possible to split to varchar/character instead of memo?
  10. linousa

    How to overcome 254 character limit importing CSV or excel files

    1. Header: Greeting,NameLine,straddress,strAddress2,strCity,strState,strZip,strRegion,strPostalCode,strCountry,strCustomerID,ExpDate,YearMember, VariableText1,VariableText2,VariableText3,VariableText4,AdditionalText,strCompanyName,MemberType,Num 2. Is it possible to split >254 character columns...
  11. linousa

    How to overcome 254 character limit importing CSV or excel files

    Atlopes, How do you override field types in CSVProcessor? It randomly creates memo and varchar fields for values with >254 characters. Also, how do you format "overflow" field names(when it creates extra fields for values with >254),it names them ? Also, when I add it to my project, getting...
  12. 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?
  13. 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 =...
  14. linousa

    Compound index

    Is it possible to get field4 with desc sequence number for the field2 on the fly? Or will need to loop it? Or run query? field2 field4 z 4 z 3 z 2 z 1 y 3 y 2 y 1 ...
  15. linousa

    Compound index

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

    ZIP & UNZIP

    What's the best solution to zip and unzip files/folders nowadays?
  17. 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.
  18. linousa

    Export table to text without extra spaces

    I can't believe how easy it was. [thanks]
  19. 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):
  20. linousa

    JOIN without .NULL.

    SET NULLDISPLAY TO '' did the trick and UPDATE might be a better choice, because REPLACE and SEEK/SCATTER/GATHER will be a bit slower as both tables around 500K records. Thank you Olaf and as always you've been of great help!

Part and Inventory Search

Back
Top