Search results for query: *

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...

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...

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...

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...

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...

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

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...

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 &...

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

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...

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...

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

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...

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! :)...

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

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)...

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

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