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'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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.