At 03:49 PM 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.

If you don't get an exception message from the database when submitting the
INSERT statement, then it has succeeded. However, to see it it, you'll
have to refresh the dataset that's displaying data for you in the client app.

If you have a query interface in your utility, try doing SELECT * FROM
TBLSTOCKDEF.

And get a better tool!!

/heLen