NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Matthew51 on October 03, 2011, 02:46:25 PM

Title: SQL Dummy table in a browse
Post by: Matthew51 on October 03, 2011, 02:46:25 PM

Is it possible to have a browse on your SQL dummy table?  I've tried putting the PROP:SQL statement in every embed point I can think of and I always get no records found.

Or if there's a way to use the template to get the information I want.  Here is an example of one of the SQL statements I want to turn into a browse

Code: [Select]

SELECT CAST(t.Time as DATE), SUM(t.Quan) FROM Inventory.Location as l
JOIN History.ArcTransaction as t on t.LocationID = l.LocationID
WHERE l.LocationID = 78865 AND t.Time BETWEEN DATEADD(YEAR, -1, GETDATE()) AND GETDATE()
GROUP BY CAST(t.Time as DATE)
ORDER BY CAST(t.Time as DATE)


Title: Re: SQL Dummy table in a browse
Post by: Ubaidullah on October 03, 2011, 11:08:36 PM

Hi Matthew,

I was able to do this sometime back by putting PROP:SQL after the call to _SetView. I also recall that I omitted the generated view declaration and made my own.

HTH,

Regards,
Ubaidullah Nubar.