Very Computer

Hi

I have encountered two problems with Delphi 1.0 C/S apps when talking
to Micrsoft SQL Workstation 6.0:

  1. Trying to post changes to a SQL server view accessed via a TTable
     causes the application to hang while displaying the SQL cursor.
  2. Trying to run an update query on a table previously loaded with
     rows by an insert query also cause the app to hang.
     (Interestingly, using TTable.Batchmove to load the rows, and then
     running the update queries, seems to work).

I haven't noticed any other problems, but the two above are
trememdously limiting.

Has anyone else noticed this behaviour? If so, is there a know fix?

Regards
Andrew

With respect to #2, try the following--after running the insert query,
Close and Open the TQuery or TTable to refresh, then run your update query.
Gene

Quote:> Hi

> I have encountered two problems with Delphi 1.0 C/S apps when talking
> to Micrsoft SQL Workstation 6.0:

>   1. Trying to post changes to a SQL server view accessed via a TTable
>      causes the application to hang while displaying the SQL cursor.
>   2. Trying to run an update query on a table previously loaded with
>      rows by an insert query also cause the app to hang.
>      (Interestingly, using TTable.Batchmove to load the rows, and then
>      running the update queries, seems to work).

> I haven't noticed any other problems, but the two above are
> trememdously limiting.

> Has anyone else noticed this behaviour? If so, is there a know fix?

> Regards
> Andrew

On Tue, 04 Mar 1997 18:44:20 +0200, Andrew Klopper

-----------------------------------------

Academisch Medisch Centrum - Amsterdam    
-----------------------------------------