Desmond:
As others have pointed out, the error isn't from the SQL, it's a control
that can't find its controlsource.
You said "using the init method". Are you running this SQL in the init
method? If so, then that's the problem. Init() doesn't run until _after_
the objects are created. You need to run the SQL in the Load() method, so
that the cursor exists before the controls get initialized.
Dan Covill
At 19:45 04/29/03 +0000, Desmond Lloyd wrote:
>Have a custom method on a form that selects some data into a cursor...
>Here is the code...
>
>SELECT Dd_discounts.client_id, Clients_all.*, Dd_amids.am_inits,;
> Dd_discounts.am_id;
>FROM dealerdisc!clients_all INNER JOIN dealerdisc!dd_discounts;
> INNER JOIN dealerdisc!dd_amids ;
> ON Dd_discounts.am_id = Dd_amids.id ;
> ON Clients_all.client_id = Dd_discounts.client_id ;
> into cursor c_client
>
>When I run it I get the following error:
>
>'field' phrase is not found.???
>
>I've seen this recently using the init method of a form...
©2003 Dan Covill |
