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: Benny Thomas
  Where is Benny Thomas?
 Jeddah
 Saudi Arabia
 Benny Thomas
 Tags
Subject: RE: Bernard CA New Tutorial Part 3
Thread ID: 208997 Message ID: 209452 # Views: 4 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Monday, December 29, 2008 3:41:41 AM         
   


> Dear Mr. Bernard,
>
> >
> > What is the exact error?
>
> Following is the error displayed when I try to run the form:
>
>
>
>
> It seems, cursor is not being created. On clicking Test Connection, I get the message "The Connection was successful". Also on the Data Access page,I can see the tables in the Northwind database and select orders table. No problem anywhere, but when running the form there is no cursors (crsOrders). What am I missing? FYI, I have made a separate class and form to make the same updatable cursor from Native table (Northwind) and it is working ok.
>
> Another issue:
>
> I entered the following commands in VFP Command box:
>
> oConn = SQLSTRINGCONNECT([Driver={SQL Server};server=benny\sqlexpress;database=northwind;Trusted_Connection=yes;])
> ? oConn
> 3 (a positive number) - no error
>
> ? EVALUATE(oConn)
>
> In reply I get the error message "Function argument value, type or count is invlaid". Why?
>
> Benny

Since I cannot see your class from here in Australia, I cannot say what the problem is. Also I don't know which tutorial you are following since I am here in Australia and you are in Jeddah.

Eric has provided 2 excellent facilities - Image and file uploads. I suggest you use the latter so that we can be sure we are on the same page.

After he was supposed to have gone thru my tutorial to you, Samir entered the grid name as grd_crs_customer instead of grdCrsCustomer and then complained about errors. How did I know? He uploaded his class and I had a look.

You leave a lot to the imagination and assumption. For instance,

1. You don't say which tutorial you are talking about. If it is CREATING & USING CA CLASSES – A SIMPLE TUTORIAL PART II then what can I say? You obviously did not follow it correctly. I just did and it worked exactly as in the tutorial.

2. You don't say whether you are using SQL Server or VFP Native tables
3. You use the EVALUATE function wrongly and then say you have an error. Please look up EVALUATE usage in the help file. What do you get when you type:

?EVALUATE("oConn") 


which by the way is the correct usage? I am sorry but this tutorial is about CA's not usage of all the other VFP commands. That is beyond the scope.


>>What am I missing?

How would I know from way over here? How do I know what step you missed or added or changed? Send me a sample please.

Bernard

** If you see someone without a smile, give em one of yours :) **
My Blog 8-)

ENTIRE THREAD

Bernard CA New Tutorial Part 3 Posted by Samir Ibrahim @ 12/23/2008 1:18:40 PM
RE: Bernard CA New Tutorial Part 3 Posted by mike castillo @ 12/23/2008 2:14:59 PM
RE: Bernard CA New Tutorial Part 3 Posted by Samir Ibrahim @ 12/23/2008 3:47:39 PM
RE: Bernard CA New Tutorial Part 3 Posted by Bernard Bout @ 12/24/2008 2:23:22 AM
RE: Bernard CA New Tutorial Part 3 Posted by Benny Thomas @ 12/24/2008 7:44:25 PM
RE: Bernard CA New Tutorial Part 3 Posted by Bernard Bout @ 12/25/2008 1:09:05 PM
RE: Bernard CA New Tutorial Part 3 Posted by Benny Thomas @ 12/25/2008 6:57:17 PM
RE: Bernard CA New Tutorial Part 3 Posted by Bernard Bout @ 12/27/2008 6:57:21 AM
RE: Bernard CA New Tutorial Part 3 Posted by vivek deodhar @ 12/27/2008 5:58:12 AM
RE: Bernard CA New Tutorial Part 3 Posted by Bernard Bout @ 12/27/2008 7:04:00 AM
RE: Bernard CA New Tutorial Part 3 Posted by Mike Yearwood @ 12/27/2008 4:06:01 PM
RE: Bernard CA New Tutorial Part 3 Posted by vivek deodhar @ 12/29/2008 5:42:39 AM
RE: Bernard CA New Tutorial Part 3 Posted by Mike Yearwood @ 12/27/2008 4:07:55 PM
RE: Bernard CA New Tutorial Part 3 Posted by Benny Thomas @ 12/28/2008 2:04:35 PM
RE: Bernard CA New Tutorial Part 3 Posted by Bernard Bout @ 12/29/2008 3:41:41 AM
RE: Bernard CA New Tutorial Part 3 Posted by Benny Thomas @ 12/29/2008 9:35:38 AM
RE: Bernard CA New Tutorial Part 3 Posted by Bernard Bout @ 12/29/2008 6:02:04 PM
RE: Bernard CA New Tutorial Part 3 Posted by Mike Yearwood @ 12/29/2008 8:45:10 PM
RE: Bernard CA New Tutorial Part 3 Posted by Bernard Bout @ 12/30/2008 2:50:22 AM
RE: Bernard CA New Tutorial Part 3 Posted by Bernard Bout @ 12/30/2008 2:56:26 AM
RE: Bernard CA New Tutorial Part 3 Posted by Mike Yearwood @ 12/30/2008 4:01:38 AM
RE: Bernard CA New Tutorial Part 3 Posted by Bernard Bout @ 12/31/2008 5:39:06 AM
RE: Bernard CA New Tutorial Part 3 Posted by Mike Yearwood @ 12/31/2008 4:11:38 PM