Thanks alot Seth.
That's where I am stuck. Keep getting a NOE on windows while running and Mac
just freezes when debugging with the following code.
I understand that a recordset with the schema is returned, but do not
understand how to test for existence.
Dim rs As New RecordSet
rs = db.FieldSchema("Note")
If rs.Field("clearNote") = Nil
db.SQLExecute("ALTER TABLE Note ADD COLUMN clearNote VarChar")
End If
If rs.Field("reviewNote") = Nil Then
db.SQLExecute("ALTER TABLE Note ADD COLUMN reviewNote VarChar")
End If
Thank you.
Kirt
2006/2/17, Seth Willits <[EMAIL PROTECTED]>:
>
> On Feb 17, 2006, at 12:01 AM, Kirt Cathey wrote:
>
> > Can anybody provide a hint as to how one could check whether a
> > table exists
> > in a REALSQLDatabase. Then if the table exists, to check if a field/
> > column
> > exists in that table.
>
> Look at Database's TableSchema and FieldSchema.
>
>
>
> Seth Willits
> ----------------------------------------------------------
> Freak Software - http://www.freaksw.com/
> ResExcellence - http://www.resexcellence.com/realbasic/
> ----------------------------------------------------------
>
> _______________________________________________
> 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>
>
--
Kirt Cathey
WorkPapers Development
_______________________________________________
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>
