I try this, but don't give all info... Like, NOT NULL CONFLICT CLAUSE or
Collate or is autoincrement....
> 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>.
>
--
Francis Lessard
mac-x-software.com
_______________________________________________
Unsubscribe:
<[EMAIL PROTECTED]>
