Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Bernard Bout
  Where is Bernard Bout?
 Brisbane
 Australia
 Bernard Bout
 To: Asif Hussain
  Where is Asif Hussain?
 Karachi
 Pakistan
 Asif Hussain
 Tags
Subject: RE: VFP 9 and SQL Server 2000
Thread ID: 112331 Message ID: 112676 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Friday, November 10, 2006 10:18:39 PM         
   


> Thanks Experts,
>
> Thanks for your cooprate and the ideas which you given me are very benefitical for my project.
>
> I done some working in CA. How can I manage Adjustment to send updates manully please help me.
>
> In my project I have a invoice like purchasing or sale invoice.
>
> 1,First table contain the Supplier detail (Only 1 entry in a invoice).
>
> 2,Secound table contain the Main Purchase table ((Only 1 entry in a invoice).
>
> 3,Third table is detail of purchase (Many entry).
>
> I want that my user update or add any row in form the data not send update till user push the [Save] button.
>
> I hope you also help me in future and new project are well supported.
>
> Your Well Wisher
> Asif
>
>


Asif

Either you have not looked at the code or you have not followed it. The code I posted is exactly what you asked for for updating multiple tables.

You use the same code as I posted earlier.

You add another method called SAVEDATA
In that method you have code like this:

IF NOT TABLEUPDATE(0,.T.,"Supplier")
RETURN .F.
ENDIF

IF NOT TABLEUPDATE(0,.T.,"Purchase")
RETURN .F.
ENDIF

IF NOT TABLEUPDATE(0,.T.,"Detail")
RETURN .F.
ENDIF

IF NOT TABLEUPDATE(0,.T.,"AnyOtherTable")
RETURN .F.
ENDIF

etc.

If any of the tables do not update or you get an error then the SAVEDATA() method will return .F. and the complete transaction will be rolled back.

ENTIRE THREAD

VFP 9 and SQL Server 2000 Posted by Asif Hussain @ 11/7/2006 12:41:55 PM
RE: VFP 9 and SQL Server 2000 Posted by Ken Murphy @ 11/7/2006 3:05:53 PM
RE: VFP 9 and SQL Server 2000 Posted by Asif Hussain @ 11/8/2006 7:43:20 AM
RE: VFP 9 and SQL Server 2000 Posted by Ken Murphy @ 11/8/2006 1:03:55 PM
RE: VFP 9 and SQL Server 2000 Posted by Bernard Bout @ 11/9/2006 7:03:53 AM
RE: VFP 9 and SQL Server 2000 Posted by Asif Hussain @ 11/10/2006 1:36:57 PM
RE: VFP 9 and SQL Server 2000 Posted by Bernard Bout @ 11/10/2006 10:18:39 PM
RE: VFP 9 and SQL Server 2000 Posted by Asif Hussain @ 11/11/2006 5:22:32 AM
RE: VFP 9 and SQL Server 2000 Posted by Ken Murphy @ 11/11/2006 3:55:42 PM
RE: VFP 9 and SQL Server 2000 Posted by Ken Murphy @ 11/10/2006 8:05:26 PM
RE: VFP 9 and SQL Server 2000 Posted by Bernard Bout @ 11/10/2006 10:11:40 PM
RE: VFP 9 and SQL Server 2000 Posted by Ken Murphy @ 11/11/2006 1:50:48 AM
RE: VFP 9 and SQL Server 2000 Posted by Bernard Bout @ 11/12/2006 3:25:06 AM
RE: VFP 9 and SQL Server 2000 Posted by Mike S @ 11/14/2006 12:04:52 PM
RE: VFP 9 and SQL Server 2000 Posted by Ken Murphy @ 11/14/2006 4:14:54 PM
RE: VFP 9 and SQL Server 2000 Posted by Bernard Bout @ 11/15/2006 4:31:51 AM
RE: VFP 9 and SQL Server 2000 Posted by Mike S @ 11/15/2006 9:33:27 AM
RE: VFP 9 and SQL Server 2000 Posted by Ken Murphy @ 11/15/2006 1:16:07 PM
RE: VFP 9 and SQL Server 2000 Posted by David Jo @ 11/11/2006 4:54:56 PM