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,

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

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

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

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!