Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 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: 112715 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Saturday, November 11, 2006 3:55:42 PM         
   


> Hi Mr. Bernard Bout
> I used CA in a form and when i use TABLEUPDATE(0,.T.,"Supplier") I received an error massage ALIAS() not found.
> >
> >
> > 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.

>
>
>
> i accept all the condition of forum

Asif,

The "Supplier" that Bernard refres to is the Alias for a table named "supplier." What is the alias for your table? Use that alias instead of "Supplier."

Ken
You shall know the truth - and the truth shall set you free. (John 8:33)

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