Search results for query: *

Hi Olaf and Nasib, I also tried to set printer , paper size using that printer in the report. but came out the same result. it seems whatever the setting of the report(no default setting, or with default page and printer setting), the same error result came out (the first page is ok, second...

Mike, I removed all default page and printer setting of report.frx from expr,tag,tag2 columns. And if paper length setting causes error, the alignment will be out always, isn't it? now, the problem happen for the first time print after power on the printer.

I have problem in invoice printing with dot matrix printer (EPSON LQ 2170). when print more than 1 pages report, the first page is fine,then the printer skip the second page and print page 2 on 3rd page with the alignment is move up. and 3rd page skip again and 4th page also the alignment is...

in save button click, before begin transaction block of TABLEUPDATE() and REVERT things, following is done to control unique value. any suggestion for improvement :) select pgrh_fil if !flock() =messagebox("File is locked by another user, Please try again later",0,"File Locked") return 0...

Unfortunately, try catch does not support in visual foxpro version 7...

Hi MK, Can you explain a bit more why your second indexseek() use sivd_fil. the table that want to move the record when matching record from sivd_fil is ssod_fil. shouldn't it be ssod_fil in second indexseek()?

sivd_fil is actually a view (named sivd_view) created under dbc. when user select a row in a grid(datasource=sivd_view) and click delete button, sivd_view current row is user selected row to delete. before delete, search related field of sivd_view current selected row data in ssod_fil, then add...

Hi Olaf, When i force adding duplicate rows and click save to make tableupdate(),program stopped at tableupdate() line and the error raised in AERROR(). I did it to test AERROR() raised or not. BTW, can you all share any source about debugging and tracing , how to use visual foxpro debugger...

Hi, I am searching sivd_fil deleted row field in ssod_fil to add back deleted quantity into ssod_fil. Thanks for the code. I will try it.

I get the point getting return value in one line of all TABLEUPDATE() cannot know which TABLEUPDATE() return .F. , I will cascade my TABLEUPDATE(). I will set IFORCE to .F. But , how comes it didn't add back quantity to ssod_fil and pgrd_fil at the first time, and it is when I key in again...

I re-enter manually the problem document sales invoice exactly(delete it first and key in again) to generate error again but nothing wrong. so, it is clearly no logic error in coding. and it is single user. I tested my TABLEREVERT area and AERROR() area by forcing error (eg: force adding...

Hi Olaf, My understanding of your statement is wssuccess will be .F. if only last TABLEUPDATE() returns .F. for below, am I right? wsuccess = TABLEUPDATE(.T.,.T.,'pgrh_fil') .AND. TABLEUPDATE(.T.,.T.,'pgrd_view') .AND. TABLEUPDATE(.T.,.T.,'ppoh_fil') Isn't it like ( .F. and .T. and .T.)...

Hi Olaf, thanks for sharing. My problem is happened for single user. Sorry for long post. 1... The grid data is sivd_fil 2....When select grid line and click delete, it gets the record no of selected line of sivd_fil, select ssod_fil and seek sivd_fil.ssod_no and ssod_line, if found()...

thank you mjcmkrsr. I put end transaction first.

Thanks Olaf and mjcmkrsr, I update my code as your advice and will wait and see the result a few days. and will post the result again.

I will try with IForce=.F. FYI: the process is : When deleting records from sivd_fil (has reference record in pgrd_fil, and ssod_fil) 1. look for related record in pgrd_fil,ssod_fil and restore back quantity (did not delete record or anything else, just seek and update data if found) 2. then...

1. tables in dataEnvironment buffer mode is 5. 2. two tables (itrd_fil, itrh_fil) are set buffering mode in Form.init event with =CURSORSETPROP('Buffering', 5, 'itrh_fil'), =CURSORSETPROP('Buffering', 5, 'itrd_fil') and not included in dataEnvironment. Following is code block in Form->Save...

I am using Visual Foxpro 7 and foxpro database and foxpro exe is placed on server. user create shortcut from pc to server to use the application. When updating multiple records of different tables from foxpro Form Save button, data of quantity field holding numeric value of quantity cannot...

But, I still couldn't find out the reason of the error. My software folder structure : I have 3 modules , each with individual database and exe . For example, AP (account payable), AR (account receivable), GL (General Ledger). Each module folder structure is ...

Thank you so much guy!!!! It was a great help! The problem was solved with the code by mjcmkrsr. FYI: I set db path on main program with global variable as lcDataPath = "..\appkg\dbf" It has been working all the time since before yesterday afternoon. And the problem only cause on server to...