Delete doesn't seem to work

delete from d;
Returns plan (0 rows deleted):
================================================================================
SQL Delete (Executed by ElevateDB 1.00 Build 1)
Note: The SQL  shown here is generated by ElevateDB and may not be exactly
the
same as the SQL that was originally entered.  However, none of the
differences
alter the execution results in any way.
================================================================================
DELETE FROM "d"
Target Table
------------
d: 19988 rows
================================================================================
0 row(s) deleted in 0 secs
================================================================================

> Delete doesn't seem to work

Have not tried it, but adding a where clause to the statement should get it
to work.  Update SQL statements appear to have the same problem...  No where
clause, no update.

--

---------------------------------------
 Terry Swiers
 Millennium Software, LLC
 http://www.1000years.com
 http://www.atrex.com

 Atrex Inventory Control/POS -
    Big business features without spending big business bucks!

Atrex Electronic Support Options:
 Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
 Email: mailto:support@atrex.com
 Newsgroup: news://news.1000years.com/millennium.atrex
 Fax: 1-925-829-1851
 Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
 ---------------------------------------

>> Delete doesn't seem to work
> Have not tried it, but adding a where clause to the statement should get
> it to work.  Update SQL statements appear to have the same problem...  No
> where clause, no update.
Nope, didn't help here That was my first thought too, btw


Michael

Michael,

<< Delete doesn't seem to work >>

Fixed.

--
Tim Young
Elevate Software
www.elevatesoft.com