Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by IvySoe

  1. IvySoe

    Report printing problem

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

    Report printing problem

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

    Report printing problem

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

    TABLE UPDATE PROBLEM- VISUAL FOXPRO 7

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

    TABLE UPDATE PROBLEM- VISUAL FOXPRO 7

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

    TABLE UPDATE PROBLEM- VISUAL FOXPRO 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()?
  7. IvySoe

    TABLE UPDATE PROBLEM- VISUAL FOXPRO 7

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

    TABLE UPDATE PROBLEM- VISUAL FOXPRO 7

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

    TABLE UPDATE PROBLEM- VISUAL FOXPRO 7

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

    TABLE UPDATE PROBLEM- VISUAL FOXPRO 7

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

    TABLE UPDATE PROBLEM- VISUAL FOXPRO 7

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

    TABLE UPDATE PROBLEM- VISUAL FOXPRO 7

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

    TABLE UPDATE PROBLEM- VISUAL FOXPRO 7

    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()...
  14. IvySoe

    TABLE UPDATE PROBLEM- VISUAL FOXPRO 7

    thank you mjcmkrsr. I put end transaction first.
  15. IvySoe

    TABLE UPDATE PROBLEM- VISUAL FOXPRO 7

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

Part and Inventory Search

Back
Top