Subject | Re: Howto create >1 field in table, using IBOConsole or IBAccess? |
---|---|
Author | jwhinyyc <wexsessa@telusplanet.net> |
Post date | 2003-02-27T00:42:24Z |
--- In ib-support@yahoogroups.com, "Christoph <lists@a...>"
<lists@a...> wrote:
The only thing that was different this time was - I noticed
that IBAccess defaults to Dialect 1, and changed that to
Dialect 3, then it worked. But later I tried again and forgot
to change to Dialect 3, and it still works.
I need to explore this further.
Next problem was with the table name - I created it as Guest.
kinterbasdb (or Firebird) complained it could not find table GUEST.
But when I recreated the table as GUEST2 (and adjusted my
SELECT statement) all is OK.
Anyhow, I now have a minimal PythonCard program
(in Windows 2000 Pro) accessing a FireBird database.
Time to relax and celebrate before the next problem.
Thanks to all for suggestions.
<lists@a...> wrote:
>I tried again (after failing half-a-dozen times) and IT WORKS.
> You can do this in IBAccess and I think you can do it in IBOConsole.
>
> In IBAccess:
> Click on 'Tables' on the left hand side.
> Doubleclick on the table you want to change.
> Click on the 'fields' tab.
> Click on the 'new' button.
> Enter in the field details.
> Click on ok.
> Say Woo hoo!
>
The only thing that was different this time was - I noticed
that IBAccess defaults to Dialect 1, and changed that to
Dialect 3, then it worked. But later I tried again and forgot
to change to Dialect 3, and it still works.
I need to explore this further.
Next problem was with the table name - I created it as Guest.
kinterbasdb (or Firebird) complained it could not find table GUEST.
But when I recreated the table as GUEST2 (and adjusted my
SELECT statement) all is OK.
Anyhow, I now have a minimal PythonCard program
(in Windows 2000 Pro) accessing a FireBird database.
Time to relax and celebrate before the next problem.
Thanks to all for suggestions.