Recent content by Rock4J

Thanks so much Olaf.. It works after some adjustment: use account in 0 use gl in 1 local nbal select tr_date,entry_ref,desc,source_cd,ref1,ref2,acct_no, ; iif(amount>0, amount, 0000000.00) as debit, ; iif(amount<0, amount*-1, 0000000.00) as credit, ; 000000.000 as balance ; && my foxpro...

I have done this : local nbal select tr_date,entry_ref,desc,source_cd,ref1,ref2,acct_no, ; iif(amount>0, amount, 0000000.00) as debit, ; iif(amount<0, amount*-1, 0000000.00) as credit, ; 0 as balance ; from 'c:\documents and settings\administrator\desktop\transact.dbf' order by...

Thanks Olaf, Please verify if this code is correct: select tr_date,entry_ref,desc,source_cd,ref1,ref2,acct_no, ; iif(amount>0, amount, 0000000.00) as debit, ; iif(amount<0, amount*-1, 0000000.00) as credit, ; 0 as balance ; from transact order by acct_no,tr_date COPY TO "c:\documents and...

Thanks Olaf, I need some time to create the code. I'm confused to work with both transact.dbf and account.dbf at the same time (key: acct_no). I'm don't much knowledge in this. I do understand the scan code is something like do-until/while-loop in vb classic. Regards, Rocky

What I'm trying to do is actually, exporting the query result into excel, because the original program are written in DBASE programming and I don't have any knowledge about DBASE programming. That's why I hope at least I could get the data for the DBF tables using Foxpro Command windows. :)...

Thanks again Olaf ! :) Does the scan code can be done in the COMMAND windows ? I found a code like this: Local nBal nBal = account.ytd_bal Select cards Go top Scan nBal = nBal + debit - credit replace balance with nBal endscan go top but I do not know how to implement it in the...

Thanks so much Olaf for the clear explanation and alternatives. :) Regards, Rocky

Thanks a lot Vilhelm-Ion.. I used the 0000000000.00 and it works.. I don't know how to use the CAST function, but at least my problem solved. next, I want to INNER JOIN "Transact" Table with another table named "Account" and use the "opening balance" for example the fieldname is "ytd_bal"...

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

Wow ! it works XWB .. Thanks so much.. [thumbsup2] By the way, I'm still using XP too. Regards, Rockyhttp://files.engineering.com/getfile.aspx?folder=6d639303-6a13-45a2-b657-4b465dff8c87&file=inserted_successfully.JPG

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

Thanks jbenson001 ! Regards, Rocky

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

YES !!! FINALLY I GOT IT !! Woohooooo!!!! xD It's my mistake.. I use the same COMPUTER NAME for both the windows 7 and Windows XP Mode.. LMAO!!! Silly me.. xD Regards, Rocky

Ok, I have solved this problem myself. And I want to share the solution. It might helpful for somebody else in the future, 1. Run the Windows XP Mode 2. Click on "Tools" at the top menu and select "Settings" 3. Click on "Networking" and change the "Adapater 1" value appropriately. (I prefer to...