How to execute an SQL command ?

Need help? Post your questions here.

Moderator: moderators

How to execute an SQL command ?

Postby aliceprince » Wed Aug 14, 2019 4:15 am

Hi... my quest is very simple

Does anyone know how to execute an SQL command directly using Subsonic? For example:

SELECT DISTINCT TOP 100 PERCENT qty FROM [dbo].[sales]

There are one method GetSql() in the SubSonic.Query class that returns the SQL command.
Why there aren't exists one method SetSql()? Do know where is that method or any other equivalent?
aliceprince
 
Posts: 1
Joined: Wed Aug 14, 2019 4:06 am

Re: How to execute an SQL command ?

Postby samsonic » Sat Aug 17, 2019 1:49 pm

Yes, open your Subsonic URL and add "/db.view" to the end, like https://myexampke:4443/db.view

Sam
samsonic
 
Posts: 2
Joined: Sat Aug 17, 2019 1:36 pm


Return to Help

Who is online

Users browsing this forum: No registered users and 14 guests