What you are looking for is:
rs = db.SQLSelect("PRAGMA table_info(myTable)")
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/
On Feb 7, 2007, at 2:23 AM, Francis Lessard wrote:
Question,
There is any sql command or any other way to get all info fro
each field
in table as recordSet ? Right now i use the create table SQL to get
all info
for each field by using Regexp.
Ty !
SQLite3ProfessionalPlugin is no longer for sale for new users,
registered users will continue to receive upgrades and supports.
More here:
http://www.sqlabs.net/blog/2007/01/sqlite3professionalplugin-no-
longer.html
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/
On Feb 5, 2007, at 1:06 AM, Bart Pietercil wrote:
That would probably be through the SQLIte3Professional plugin
www.sqlabs.net
hth
Bart
On 5-feb-07, at 00:22, Rick Praetzel wrote:
NUG:
I need to be able to read the default value for fields in a
REALSQLdatabase
Does anyone know how to invoke the SQLite PRAGMAs that allow me to
do that?
Thanks in advance,
Rick Praetzel
RB2007r1, Mac Dual 2.5GHz PowerPC G5
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe:
<[EMAIL PROTECTED]>
REAL Software has decided to consolidate this mailing list with the
online Forums. On Monday, February 12, 2007, this mailing list
will no longer be active. We encourage you to continue your
REALbasic and REAL SQL Server discussions on the Forums. If you
are not presently a member of the forum, please sign up today at
<http://forums.realsoftware.com>.
_______________________________________________
Unsubscribe:
<[EMAIL PROTECTED]>
REAL Software has decided to consolidate this mailing list with the online Forums.
On Monday, February 12, 2007, this mailing list will no longer be active. We
encourage you to continue your REALbasic and REAL SQL Server discussions on the
Forums. If you are not presently a member of the forum, please sign up today at
<http://forums.realsoftware.com>.
