Subject Re: Table Problem
Author Luke Young
A better tool like....

Hoping for a recommend

and when is your book being published?


--- In, Helen Borrie <helebor@t...>
> 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
> >
> >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
> And get a better tool!!
> /heLen