Search results for query: *

Thanks, I used the following query SELECT ; IIF(len(chrtran(alltrim(field1), "1234567890", "")) = 0, ; PADL(ALLTRIM(field1),10,' '), ; number) AS NewField1 FROM test ORDER BY 1 because 1A comes after 9. Vikas Burman Product Lead coVeda technologies pvt ltd., Chandigarh www.coveda.com

Hi All, In a character field both numeric and Character values are being stored. Select <field> from test order by <field> gives Output like this 1 10 2 3 A etc... Is there any functions avaliable to get output like 1 2 3 10 11 A etc...

Hi Mike/Kilroy, Thanks for your help. For the Checkbox Column Enabled and Visible is .T. and ReadOnly is set to .F. .ColAbsorbed.Enabled = .T. .ColAbsorbed.ReadOnly = .F. .ColAbsorbed.Visible = .T. and CurrentControl of the Column is Check box only. Still I am unable to Check the Check...

Dear All, I have a check box in a grid with the column sparse property set to .F. I am unable to Check the Check box. But I could able to Check the check box, after putting the focus in any other grid column. Below is the Sample code for the Grid Configuration. <vfp>...

Hi Can anyone point to some resource/site where I can find more information on the mantioned subject. I want to create an MS Outlook profile as part of the setup from within my application. I'll ask all the required input from the user and will create/delete profiles as an when required...

Hi Pankaj Thanks for the solution. This will solve our problem. Actually we have now switched to treeview instead of ksoutline (in cQOS/vizKat) and hence the question. Actually I had the solution which uses _DBLCLICK and seconds() for this - but I was looking for a more elegant solution -...

Thanks for the responses, but the problem is still there: 1: If I use This.SelectedItem.Key in DblClick of the treeview, then suppose if user selected one node once and than DblClick on a empty area in the treeview control, I will still get the node value in This.SelectedItem.Key but actually...

The DBLClick works when user double clicks on a blank area and not when a node. Like NodeClick I want a NodeDblClick. Scenario: I want to add a node item contents into some grid when user double clicks on a node in the tree view. Vikas

Hi I want to have an event which fires only when user DoubleClicks a Node in Treeview. Does any one knows about this - how to do this? Thanks Vikas

Hi all I have created the install set of my application using InstallShield that comes with VFP 7. Everything is fine, but if I delete some files which are part of the install set, it automatically recovers them from the install set. Since this activity is a common activity and the files...

Well, The simplest way can be comparing the file contents like: lcFile1 = filetostr(<file>) lcFile2 = filetostr(<file>) if lcFile1 == lcFile2 ** same else ** different endif Vikas

Thanks everybody for providing various views to the problem. Though I can use low-level file functions but I thought if I use filetostr() it would be easier. The text I am dealing currently is not that big but still the context, I am writing code for, can get text files so big hence the...

Well Chris, With virtual memory and swapping in place RAM can go to sizes more than physically installed on the machine. Anyways the question is whether filetostr() can handle files of sizes like 80mb or 2gb types. Vikas

Thanks Lewis for a quick reply. That I read in MSDN. But I can also do this: replace alias.memofield with filetostr(<file>) Now Will this work if the <file> size is 80mb or so? Vikas

Does anybody know about the limitations with StrToFile() and FileToStr() functions, if any? I am specially interested in knowing that what is the maximum size of a file these functions can read/write? An early response will help. Thanks Vikas

Thanks Jim That much I had already attempted before writing to this forum. Thanks anyways for your efforts. Vikas

Hi Parthi Use the MS Communication controls on a VFP Form - Use the properties/methods of the control to check mails directly from Outlook folders and you can also use VFP Timer control to call these checks automatically. Hope this will help. For more details you can again ask giving the...

Hi all I have developed a COM Addin DLL for MS Word to write report from VFP to Word. Now I want to do the same for QuarkXPress. Is this possible? Does QuarkXPress supports following concepts: a) Template Document b) Bookmarks in the document c) Something as COmAddIn DLL d)...

If you want to close the form - issue CLEAR EVENTS in the QueryUnload() event.