Subject Re: [firebird-support] Re: Table Problem
Author Alexandre Benson Smith
At 15:49 29/01/2004 +0000, you wrote:

>INSERT INTO TBLStockDef (UID, StockCode, StockName, Description)
>VALUES(:UID, :StockCode, :StockName, :Description)
>The SQL is fine, that I am not new to.
>The problem is the CREATE TABLE.
>The SQL is fine I am 100% sure and it does execute successfully. When
>I use Borlands Database Explorer tool I can see the table I have
>created but when I go to view its data I get table does not exist.
>I can look at the table and the Borland tool actually shows the CREATE
>In Delphi I am executing the CREATE TABLE query and then commiting the
>transaction. This all succeeds but as shown above the table is there
>in definition but no data rows exist and hence the INSERT is failing.
>Any further ideas?


Send to us the create table statement you used or the extract metadata from
this table...

see you

Alexandre Benson Smith
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil


Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.572 / Virus Database: 362 - Release Date: 27/01/2004

[Non-text portions of this message have been removed]