Subject Re: Table Problem
Author Luke Young
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?



--- In, Uwe Grauer
<mailinglists@o...> wrote:
> Luke,
> please show us one of your insert statements.
> Tablename depends on the way you quoted it.
> e.g. 'tablename', tablename, "tablename"
> Those are different!
> Uwe
> Luke Young wrote:
> > Sorry for the lame question... (newby)
> >
> > I have created a table using SQL. If I look at the database from say
> > Borlands Database Explorer the table is there. But when I go to view
> > the table or perform an operation such as SELECT or INSERT I get the
> > error message the table does not exist.
> >
> > When executing the CREATE TABLE query I am following it with a commit.
> >
> > Any ideas?
> >
> > TIA
> >
> > Luke