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!

  • Congratulations TouchToneTommy 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. clipper01

    API .NET .DLL -- unusable in VFP!

    Here is an outline example of using wwDotNetBridge to connect to the Stripe API . Shows the main structure , was a tester/curiosity project ,but can confirm all works and seems similar to your case Here is the VFP side , a 'Hello World' example , you can follow the links to the Fox2Net class ...
  2. clipper01

    Connection to SQL Server Best Practices

    Stanley, to be honest I did not take it beyond the stages described. I relied on the assistance of the Zywall 'expert' , so if you could find one ( or similar ) , they might offer experience of working in similar scenarios
  3. clipper01

    Connection to SQL Server Best Practices

    far as I recall it was something like this The LAN was subnet 192.168.15.xxx SQL server sat on subnet 192.168.50.xxx , and nothing else there 192.168.15.xxx had full in/out access to 192.168.50.xxx , but none going the other way , locked by Zywall box Outsiders were redirected to...
  4. clipper01

    Connection to SQL Server Best Practices

    Stanley In the past did something very similar using a DMZ approach ( de-militarized zone ) . This requires an extra hardware firewall , I used Zywall , check their site. You end up with your SQL server fully visible on the LAN side , but on the WAN side they come in through a separate IP...
  5. clipper01

    Converting Excel to DBF

    This problem was recently covered and a superb solution provided by the incomparable Mr Vilhelm-Ion Praisach. I've used his utility to import xlsx files of about 30,000 + lines , no problems. Thread reference : Import to Memo Fields 2 thread184-1755524 Usage is as simple as...
  6. clipper01

    Import to Memo Fields

    Vilhelm yes , seems that your file versions are mixed . The file on your download site on prior email, although it says version 1.3.1 is dated 04/09/2015 , the file you linked on this post is dated 25/09/2015 , still says version 1.3.1 but it works perfectly. Many thanks for sharing this...
  7. clipper01

    Import to Memo Fields

    Vilhelm , downloaded & tested version 1.3.1 but still has the same issue. You can test with the sample zip files in the previous email. Does seem somehow related to the mismatch between the 6-digit dbf character field and the excel 6-digit field which excel naturally insists on seeing as a...
  8. clipper01

    Import to Memo Fields

    Vilhelm , this is a super little utility and actually "almost" solves a client issue that I have had. He has a file of about 27000+ price breaks that is created in Excel 2010 and needs to be updated from time to time to a price break file in his VFP app . Up til now, I've had to save the file...
  9. clipper01

    Move to Win Server 2012 R2

    I had a similar problem, after switch to server 2012, apps crawled , had set on seperate virtual server, smb2 disabled etc etc. Tried all the kind of things above, finally fixed when the network hub was replaced with managed switch for that section. It does seem there must be some change in the...
  10. clipper01

    Web Service Woes...

    re dotNet,depends what stage you are at, if just starting, do a Hello World forms application and google VFP / Interop to get going. A typical user screen looks almost the same as VFP, grids , text-boxes , combo's etc re "few hundred" , Sqlite locks the full data-base for an update, but the...
  11. clipper01

    Web Service Woes...

    Fully agree, once you get into web services, then you realise the lmits of VFP. The reccomended dotNet method is to use the NuGet package, Microsoft.AspNet.WebApi.Client. This means you do not have go messing about figuring out all the complications of HtttpRequests, building up magic...
  12. clipper01

    Move to Win Server 2012 R2

    Just a follow-up to the vexed question of OpLocks , SMB etc. Had a site that recently moved from Server 2003 to Server 2014. Response time on some busy screens went from 10 secs to 300 seconds. I had maade sure that the upgrade put VFP on a seperate virtual box , this box had SMB switched off...
  13. clipper01

    VFP Refresh() VS C# Refresh()

    Sean M , that's me , long time ago used clipper , hence nickname
  14. clipper01

    VFP Refresh() VS C# Refresh()

    Hi Nro , like any who move from VFP to .Net , you still keep 'thinking' VFP for quite a while. For example, you assume that there is some equivalent to e.g. the Init and Refresh methods in VFP that conveniently bubble down from the parent form to the controls. You also assume that normal 'best...
  15. clipper01

    Email automation VFP9 and Outlook 365

    Does that not defeat the whole purpose of Office 365, user then has to go back and buy Office "desktop" It's just as easy to use the Exchange Server itself to do the mailing. The construction logic of the emails will not change, all that changes is that you will call the Exchange API instead of...
  16. clipper01

    Email automation VFP9 and Outlook 365

    There may be other ways to do this using the Outlook client, but the approach below will certainly do it. This is another great example of using the wwDotNetBridge approach, covered in a recent thread. Means that instead of dealing with the Outlook "client" , you use the services of the...
  17. clipper01

    confused re adding CreditCard Payment to our VFP9 app

    Also bear in mind that when you look at all of the reviews of these various systems, they generally talk of " integrating to web-sites " etc. But what makes the dotNetBridge angle really interesting from a VFP view is that the linkage is direct form-to-form , so e.g. your VFP form could pull...
  18. clipper01

    confused re adding CreditCard Payment to our VFP9 app

    True, and don't forget to include Stripe in the line-up, amazing success story of Patrick Collison, who incidentally is back in 'town' at the web summit in Dublin this week
  19. clipper01

    confused re adding CreditCard Payment to our VFP9 app

    Regardless of which you choose , WorldPay , Paypal , Authorize or other, the dotNetBridge method is still an excellent way to integrate to your VFP application, presume its a Card Not Present situation. They ALL have C# interfaces and LOADS of support , ZERO of them have VFP interfaces and...
  20. clipper01

    confused re adding CreditCard Payment to our VFP9 app

    Interesting timing, if you look at the recent thread on linking VB.net to FoxPro, we all agreed that wwDotNetBridge is exactly the way to add these kind of dotNet API capabilities to a VFP application. While it is true that you could integrate authorize.net with FoxPro ( see the sample codes...

Part and Inventory Search

Back
Top