I would like my app to have sort of procedure which would act as a SQL query script editor. Meaning I would type some SQL query, execute it, see results (error, updated, table from select). I would protect this proc to be usable only to me but this way I could easily solve some things directly from my app instead of going to server or using Ms sql management studio etc.
Anyone has something like this?
Bostjan
Robert Paresi used to sell this, but I don’t know if it was a separate app or an addon.
https://web.archive.org/web/20170605054448/http://www.paresi.net/iqsql/index.html
Gustavo Pinsard used to have a project on GitHub where you could type in a query and it would show the results in a virtual list box. But I cannot see it there now. I do probably have a copy somewhere. UltimateSQL from the ClarionLive folks may also have this capability.
I think this is a fork of the project Jon referred:
From my notes on a post on SV newsgroups
“…the example project prg6 wasn’t working out of the box. I found it worked commenting out these lines on ODBCDataSet.Load method of odbcClass.clw:
! IF NOT INLIST( SELF.Exec( SELF.query ), SQL_SUCCESS, SQL_SUCCESS_WITH_INFO )
! RETURN
! END
(the query was being sent twice)”
Jeff SQLite project also allows to send dynamic queries, using PROP:SQL in this case, gathering column names and showing results in a virtual listbox:
WinSQL is a great tool for developers…
…not integrated into Clarion.
The lite version is worth a look.