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

  • Users: benasumwa
  • Content: Threads
  • Order by date
  1. benasumwa

    Windows 10 And UWP Apps

    Hello, I am trying to wrap my head around this UWP thing. Kindly forgive if I sound rather uninformed. How do I tell that my Windows 10 is UWP compliant? I ran winver and the current version 1709 (Os build 16299.125) What do I need to do in order to develop UWP apps? (want to learn ) What do...
  2. benasumwa

    F/Rlock() with TableUpdate()

    Hi Friends, Still using VFP6. My question is: With the application of appropriate buffering combined with the TRANSACTIONs, is there any need to issue an explicit RLOCK() or FLOCK() or it's advisable to leave them out utterly? Any suggestions will be highly appreciated Time is the father of...
  3. benasumwa

    How does ??? work in VFP6

    Hi friends, I was used to the following type of quick receipt print: LOCAL cPrinter cPrinter = GetPrinter() SET PRINTER TO (cPrinter) ??? "Receipt No. "+TransForm(nReceNo) ??? "Customer "+cCustName ... SET PRINTER TO This would work well in Fox 2.6Dos But when I try the same in VFP6...
  4. benasumwa

    Print Without ejecting paper

    Hi Friends, I have a 40 column receipt being used in a guest hostel for sales. I have created a noraml report to print a receipt for foodstuff bought. One copy for customer and the other for the kitchen. The receipts are usually small with an average of maybe 3 items. But when I print even...
  5. benasumwa

    Water Mark on Reports

    Hi Friends, I have searched the site for any reference to Water Marks on VFP reports but do not seem to make any headway. Is it a feature that can be incorporated on reports, so that for Invoice reprints I could have COPY on the FRX? Any Ideas? Time is the father of truth. Time will tell...
  6. benasumwa

    DEs in production system Defaults to Data residing in development fold

    Hi Friends, This is the scenario: I have a folder containing the source code and test DBFs/CDXs. (C:\DevFolder) I have another folder (C:\ProdSys) containing the EXE app and of course the DBFs/CDXs. Now this folder has real data for production. The problem is that my app's DEs will always...
  7. benasumwa

    DEFAULT clause in CREATE TABLE statement

    Hi all, How do I create a an access table programatically though a connection with the DEFAULT clause included? The clause is available in Design View This statement fails: CREATE TABLE MyTable (MyField1 Numeric NOT NULL DEFAULT 0) But works with the DEFAULT removed. I have a round 100...
  8. benasumwa

    DEFAULT Clause in CREATE TABLE statement

    Hi all, How do I create a an access table programatically though a connection with the DEFAULT clause included? This statement fails: CREATE TABLE MyTable (MyField1 Numeric NOT NULL DEFAULT 0) But works with the DEFAULT removed. I have a round 100 tables to CREATE, but in access database...
  9. benasumwa

    CREATE TABLE SQL Statement

    Hi all, How do I create a an access table programatically though a connection with the DEFAULT clause included? This statement fails: CREATE TABLE MyTable (MyField1 Numeric NOT NULL DEFAULT 0) But works with the DEFAULT removed. I have a round 100 tables to CREATE, but in access database...
  10. benasumwa

    Results of SQLEXEC() into a CURSOR with a specified name

    Hi friends Thanks to all for your helpful tips/hints. I have trouble with SQLMORERESULTS() This is the scenario: =SQLSETPROP(nHandle,"Asynchronous",.T.) nResult=SQLEXEC(nHandle,"SELECT * FROM GLTRANFI","GLTRANFI") nResult=SQLEXEC(nHandle,"SELECT * FROM GLACCOUN","GLACCOUN") The second...
  11. benasumwa

    Fields with FOREIGN REFERENCES

    Hi Friends, I am preparing my table definitions and I am just wondering about whether all fields with FOREIGN REFERENCES to other tables should be indexed. (SQL Sever 2000) Any help? --------------------------- Benson O. A. Infinity Link Limited
  12. benasumwa

    ?Equivalent of SEEK

    Hi Friends, I am converting my legacy systems to client/server architecture. I was used to foxpro's SEEK to find a particular record in a table, now I am stuck at that. Which method is used to find a record? I am using SPT in VFP6. Thanks in advance Benson --------------------------- Benson...
  13. benasumwa

    Query Optimization

    Hi friends! I have a table with 12 months' payroll data for over 17,000 employees. The table has nearly 3 million rows. The field [code] has payroll items such as Basic Salary, Bonus e.t.c. coded with numericals eg 001,100,738 and so on The field [pfnumber] is employee's personal file no...
  14. benasumwa

    Composite Keys vs Single Columns

    Hi friends! I have a table with 12 months' payroll data for over 17,000 employees. The table has nearly 3 million rows. The field [code] has payroll items such as Basic Salary, Bonus e.t.c. coded with numericals eg 001,100,738 and so on The field [pfnumber] is employee's personal file no...
  15. benasumwa

    DateTime Fields (Defaulted to '')

    Hi Friends I am trying to learn SQL Server. I have noted that if I create a DateTime field (on SQL Database) allowing no nulls with default as ''. My SELECT statement requesting this field fills the VFP cursor with "01/01/1900 12.00.00PM" value. 1. Is it a SQL bug? 2. What do I need to do to...
  16. benasumwa

    SPT or Remote Views?

    Hi Friends! I have gathered quite some helpful hints from you guys concerning client/server. I have decided to change my applications (VFP6) to this architecture, may be using VFP9. For learning purposes I have downloaded SQL Server 2005 Express Edition. Just to ask: 1). Out of your...
  17. benasumwa

    An app Running Over a WAN (LeasedLine/VSAT)

    Hi All (bborissov/Mike Lewis: thanks for your post on "Migration to SQL". The Thread disappeared from the list and I got confused. I did not answer back. Anyway I am utilizing your helpful tips, nonetheless) I just had another issue with my foxpro app (EXE) running over a WAN with majorly...

Part and Inventory Search

Back
Top