Search results for query: *

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

it doesn't change selection...

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

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

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,

...FUNCTION ScanBinary (Source AS String) AS Blob RETURN .NULL. ENDFUNC ENDDEFINE Calling it: Do 'csvp.prg' LOCAL CSVP AS CSVP_AllVarchar m.CSVP = CREATEOBJECT("CSVP_AllVarchar") If m.CSVP.Import(GETFILE(), "tmpCSV") = 0 Select tempCSV * BROWSE Else * an error occurred ENDIF Getting:

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

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

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?

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

...Added csv,csv-processor and namer in programs. Calling it from button click event on the form: DO "csv.prg" LOCAL CSV AS CSVProcessor m.CSV = CREATEOBJECT("CSVProcessor") IF m.CSV.Import(GETFILE("csv"), "tempCSV") = 0 SELECT tempCSV BROWSE ELSE * an error occurred ENDIF Thank you!

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?

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

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

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

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

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.

I can't believe how easy it was. [thanks]

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

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!