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 Chriss Miller 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: Rock4J
  • Content: Threads
  • Order by date
  1. Rock4J

    SQL debit & credit from amount (with negative and positive sign)

    Hi, My SQL Code is like this: select tr_date,entry_ref,desc,source_cd,ref1,ref2,acct_no, ; iif(amount>0, amount, 0) as debit, ; iif(amount<0, amount*-1, 0) as credit, ; 0 as balance ; from transact order by acct_no,tr_date But unfortunately the field for "Debit" do not show any amount, but...
  2. Rock4J

    ASP Classic - Form to MDB Database (Error 0x80004005)

    Hi, I try to learn a tutorial to send data from a html form to MDB database but I receive this error: Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /MyWeb/form_to_database/add_to_database.asp, line 35 The code is like this: 1. form.htm...
  3. Rock4J

    ASP Classic - Form to MDB Database (Error 0x80004005)

    Hi, I try to learn a tutorial to send data from a html form to MDB database but I receive this error: Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /MyWeb/form_to_database/add_to_database.asp, line 35 The code is like this: 1. form.htm...
  4. Rock4J

    Could not find TREE on Windows XP Mode (in Windows 7)

    Hi there, I have a new computer with Windows 7 Pro operating system in my work place, The server is Novell 4x Server and I've been looking for a way to use Novell Client software from Windows 7 and I've read about Windows Virtual PC and Windows XP Mode. I have installed Windows XP Mode on the...
  5. Rock4J

    Acer Aspire 4730Z - Could not switched on after contact with water

    Hi, I want to know if the notebook still can be rescued after contact/flowed (sorry, my english is weak) with water due to chilling problem. Please view the picture that I have attached. Please tell me if the notebook still can repaired if i change the switch panel. Any help or info are...
  6. Rock4J

    What does Calculate Sum(Val(Evaluate(My_Var))) stand for?

    I'm trying to change the following foxpro code to visualbasic code:- Select TableOrCursor Calculate Sum(Val(Evaluate(A_Field_Name))) to My_Var Can anybody help me? Regards, Rocky
  7. Rock4J

    Help me to understand some foxpro function

    Hi, I'm trying write a VB program to replace a Foxpro program.. but i'm stuck in this problem. I could not find a way or formula to replace this foxpro code: Select Table_Name Calculate Sum(Val(Evaluate(Field_Name) to My_Var What I thought was, My_Var is a Total Sum of Field_Name. So I...
  8. Rock4J

    SQL Command

    Hi, I have code to access Foxpro DBF table as written below: Dim VerifyConnection As Boolean Dim sql_dbfcon As String Set dbfcon = New ADODB.Connection sql_dbfcon = "DSN=Visual FoxPro Tables;UID=;SourceDB=" & dbfpath &...
  9. Rock4J

    Report - label doesn't appear in second page (VFP6)

    Hi, can anybody help me to solve this? probably there is code that I can use to prevent the label from disappearing in the second page. :) Regards, Rocky
  10. Rock4J

    DBase 5 - Printing Report Date in dd/mm/yyyy

    Hi, I hope i can get help here. The DBase program usually print out report with date format dd/mm/yyyy. but after I reformat the computer (because of system failure), and installed back the DBase program, it turn out the date of every report print out is mm/dd/yyyy. My friend did try to add...
  11. Rock4J

    Error 91 - running from win98 (application written in winXP)

    Hi, I'm writing a VB6 program in Windows XP, and then I try to run the program in Windows 98. An error #91 (Object variable or With block variable not set) appears. here is what I write in the code: Dim fso As Scripting.FileSystemObject 'FileSystemObject Dim ts As TextStream Dim tsURL As...
  12. Rock4J

    How to Determine If A Table/Cursor Is Empty?

    As per thread184-785663 I'm looking for a code that can Determine if a table is empty. Using ADO-Recordset in VB I usually use ".Recordcount", as simple as that. I believe there is a right way to do it in Foxpro. and hopefully it support "VPF6". Please help. Thanks. :) Regards, Rocky
  13. Rock4J

    How to manipulate table FIELDNAME?

    Hi, I have a table that looks like this: Tablename: Dchkroll.dbf Fieldname -> Name , Empno , D01, D02, D03, D04, D05, D06, ... , D29, D31 (D01 to D31 is referring to working days which holding working-hours for the day.) I want to manipulate the D01-D31 (1 to 31 without the 'D') from the...
  14. Rock4J

    Syntax Error (Create Cursor)

    Hi friends, I'm trying to write the following code but, there was syntax error when I test it. Create cursor C:\Work\Payroll\WHAnalysis.dbf free; (Name C(50),; Empno C(10),; Dworkn N(8),; Hoursn N(8),; Dwork N(8),; Hours N(8),; DiffHrs N(8)) Any comments is appreciated. Thank you! :)...
  15. Rock4J

    Foxpro interface problem

    Hi, I have just installed foxpro 5 and foxpro 6 into a new PC, but there is interface problem that I could not fix. Please help me to determine this problem and help me solve it. Please refer to the attachment. Thank you. Regards, Rocky
  16. Rock4J

    Do+While...EndDo (adding new row)

    Hi, I am editing a project. here are some of the code: CODE 1: Table Create Cursor cDenom ; ( m100 N(5),; m50 N(5),; m10 N(5),; m5 N(5),; m2 N(5),; m1 N(5),; m05 N(5),; m02 N(5),; m01 N(5),; m005 N(5),; m001 N(5),; dpay N(10,2)...
  17. Rock4J

    why there is 'select' without 'from' in the code

    Hi, i'm newbie in foxpro and i'm trying to learn it. Please help me to understand the following issue: usually SQL code for 'select' is: >> SELECT * FROM [Table_Name] but why there is: >> SELECT [unknown/Table_Name] ?? Thank you in advance.. :) Regards, Rocky
  18. Rock4J

    How to 'Round' (with 2 deimal place) to either X.X5 or X.X0 only?

    I want to round up and down any float/double value (with 2 decimal place), but I want the last decimal to become either 0 or 5 only. For example: 6.42 => 6.40 and 6.45 => 6.45 and 6.47 => 6.50

Part and Inventory Search

Back
Top