Recent content by IvySoe

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.