Devart Forums

Rnest

after autogenerating SQL in MSQuery editor, params/values are replaced by "?"
e.g.:
INSERT INTO [dbo].[CRGRID_TEST]
([Id], [Name], [Country], [City], [Street], [BirthDate], [Job], [Hiredate], [Sal], [Remarks])
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Rnest

Thank you very much. This is the best solution and resolves the problem, especially when combined with TMSNotification.OnChange event handler.

Rnest

OK, message sent.

Rnest

SQL Server version: 10.50.1600
NativeClient: 10.52.4000.0

Rnest

OnChange event handler is null in this project.
In this case it may be message forced by sqlNativeClient library (?) so maybe there is any way to handle it, eg by making some tweaks in SDAC Library sources?

Rnest

In my project I'm using TMSChangeNotification component to reflect changes in my SQL tables. In some situations (eg. app error), SQLBroker queues are orphanded, hanging on server. Then, after next run of application, message "The subscription timeout expired" is displayed. How to avoid/hide/handle this message?

Rnest

Autogenerated update, insert, strings are invalid in newest SDAC edition (6.1.5)
e.g. for TMSQuery.SQL.Text:

Code: Select all

SELECT [EMPNO]
      ,[ENAME]
      ,[JOB]
      ,[MGR]
      ,[HIREDATE]
      ,[SAL]
      ,[COMM]
      ,[DEPTNO]
  FROM [SDACDemos].[dbo].[emp]

as generated result for insert text you get

Code: Select all

INSERT INTO [dbo].[emp]
  ([EMPNO], [], [], [], [], [], [])
VALUES
  (:[EMPNO], :[], :[], :[], :[], :[], :[])
SET :[EMPNO] = SCOPE_IDENTITY()

and for update text:

Code: Select all

UPDATE [dbo].[emp]
SET
  [EMPNO] = :[EMPNO], [] = :[], [] = :[], [] = :[], [] = :[], [] = :[], [] = :[]
WHERE
  [ENAME] = :[Old_ENAME]

Tested on RAD Studio 2010, SQL Server 2008

Best regards
Ernest

Rnest

Thank you Andrey, this solution works perfect!

Rnest

"Invalid class typecast" error calling TMSQuery.Post method of dynamically created TMSQuery in a dll.

Steps to reproduce:
1) Use included demo app {InstallDemosDir}\Demos\Miscellaneous\Dll
2) Modify procedure ShowForm in DLLMain unit:

procedure ShowForm; cdecl;
var
msq: TMSQuery;
begin
with TfmDllMain.Create(Application) do
begin
msq := TMSQuery.Create(nil);
msq.Connection := ExternalMSConnection;
//put proper SQL statements
msq.SQL.Text := 'SELECT * FROM some_table';
msq.SQLInsert.Text := 'INSERT INTO some_table...';
msq.SQLUpdate.Text := 'UPDATE some_table...';
msq.Open;
msq.Append;
msq.FieldByName('some_field').AsInteger := 0;
msq.Post; <<- invalid typecast error occurs
msq.Free;

Inc(FormCount);
Caption := IntToStr(FormCount) + '. ' + Caption;
MSQuery.Connection := ExternalMSConnection;
MSQuery.Active := True;
Show;
end;
end;

Rnest

I have a problem with opening more than one TMSQuery in DLL form (SDac ver 4.30.00.12)
Proper MSConnection is assigned to DLL's variable of TMSConnection type.
Next, this variable is assigned to MSQuery1 and MSQuery2 as "connection" property.
MSQuery1.Open - opens query, but if I try to open next Query, error message "Invalid Class Typecast" is displayed.

There is simple way to reproduce this problem. Just use demo app from SDAC Demos\Win32\Miscellaneous\Dll, place second TMSQuery component on DLL form, assign "ExternalConnection" and open query from code.

Devart Forums

Search found 10 matches

Error generating SQL Scripts [v 6.9.17]

Re: TMSChangeNotification and subscription timeout message

Re: TMSChangeNotification and subscription timeout message

Re: TMSChangeNotification and subscription timeout message

Re: TMSChangeNotification and subscription timeout message

TMSChangeNotification and subscription timeout message

TMSQuery editor, SQL Generator - error generating SQL statem

"Invalid class typecast" error with DLL's TMSQuery.Post

Invalid class typecast message on opening MSQuery in DLL