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
>TABLE SQL.
>
>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?
>
>Cheers
>
>Luke

Luke,


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


see you

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br

----------


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


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