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 strongm 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: *

  • Users: Steve Yu
  • Content: Threads
  • Order by date
  1. Steve Yu

    how to send Esc code to Epson LQ-590II for draft, courier, etc.

    Hello colleagues, https://www.tek-tips.com/threads/sending-printer-command-from-vfp.76448/ Above is an old thread that deals with exactly the same issue as I'm having now. My code: mpname = GETPRINTER() SET PRINTER TO NAME &mpname SET DEVICE TO print SET PRINTER on ??? chr(27) + "x" + "0" &&...
  2. Steve Yu

    How secure is MS SQL on the Internet vs behind firewall inside a LAN

    Hello, Our main concern is hacker. I understand there are many access control mechanisms within MS SQL to control user access. Bur what if a hacker somehow figured out the sa credentials, or otherwise gained access to the file system of the server from the public web portal on the Internet ...
  3. Steve Yu

    Westwind Web Connection server on LAN: can SPT (MS SQL) work ?

    Hello colleagues, We have a working Web Connection server on a LAN (internal web) that employs .dbf and .idx only currently. Is it possible to add SPT coding to access the MS SQL tables that are on the same LAN concurrently ? This is our effort to expand exiting desktop applications to include...
  4. Steve Yu

    oAuth 2 protocol, Microsoft Azure cloud services

    Fellow colleagues. Does VFP have commands that is capable of reaching endpoints that's only accessible via oAuth 2 protocol based on Azure ? There are sample codes in various languages except VFP in GitHub. Just wonder if it's feasible with VFP code alone (one of our guys wrote a routine in C#...
  5. Steve Yu

    Report Form printer setting binding

    Hello, Wanted to force printouts to drawer #4 of the network printer (Canon) but all went to default bin regardless. In Windows server printer setting, the custom profile, TRAY4, pops up as default profile but the actual printer setting viewed in paused print queue still shows the default...
  6. Steve Yu

    label printing question: how to print a label in .ZPL format to a Zebra printer with report form ?

    Hello, No problem with embedding a .PNG image file in a report form that would send the label directly to the the specified printer. How do you accomplish the same with a .ZPL label ? Can only find instruction that entails clicking through Zebra printer preference, locating the .ZPL in some...
  7. Steve Yu

    Data encryption at rest, VFP vs MS SQL

    Hello, Need help. What is data encryption at rest (vs not at rest) ? Are VFP tables encrypted ? Even though .dbf tables can't be viewed with Word or text editor, I don't think they are encrypted, correct ? How about MS SQL, are tables encrypted as default (we have the 2019 version) ? One of our...
  8. Steve Yu

    1115 Invalid operation for the cursor.

    Hello, Need help. Got this error trying to run any Alter Table command (alter column for example) against the cursor which was created via SPT SqlExec(). But ONLY when the cursor was empty. If I inserted several records first, then the same Alter Table command would work. Very odd. Steve Yu in...
  9. Steve Yu

    How do I do APPEND FROM in SQL

    I've converted an application package in vintage dBase code to SQL, using strictly SPT basic constructs. old VFP logic: use arymst && archive append from armast && current month activities now I have to do (simplified): armast && sql cursor scan insert into arymst && sql table endscan...
  10. Steve Yu

    State of VFP, is DBF a viable platform going forward, or SQL server is better

    Hello, Very glad I found this forum where VFP is still actively discussed and seems people still actively working with the technology. Having delayed our migration plan many years (don't fix something that's not broken), we finally decided it's time to move forward. Questions and concerns: 1...
  11. Steve Yu

    VFP migration path, MS SQL anyone ?

    Hello, We have a 30-year old character based package coded in xBase and ported through various VFP versions to 9.0 currently, with little coding changes; no forms, no popup menus, just plain old @ say get. It has been heavily modified with myriad of features and enhancements and it performs...
  12. Steve Yu

    VFP 9.0 SQL select command on .dbf

    We have a 30-year old SBT package that was written in dBase III and ported over the years to VFP 3,6, and now 9.0. It is working great and we don't want to change anything. I'm looking to try get around the VFP restriction that same .dbf can not be opened in more than one work area. The need is...

Part and Inventory Search

Back
Top