Delete?!?!?

ZeligOn
04-20-2004, 12:07 PM
Hello,

I have this line:

Conn.Execute "DELETE FROM Condition;"


Working fine on W2K and XP but giving an
error message on Win9X (see images attached)

I have confirm that this table exist with this connection...

Shurik12
04-20-2004, 01:23 PM
Hi,

What database are you working with?

Shurik.

MKoslof
04-20-2004, 01:42 PM
Do any other execute scripts run on the Win9x machine?

ZeligOn
04-20-2004, 02:03 PM
What database are you working with?

Access DB with MDAC 2.8


Do any other execute scripts run on the Win9x machine?


No, "DROP TABLE" as well... but all other
(as far as my application goes) work just fine.

Shurik12
04-20-2004, 03:38 PM
I think you have to modify you sql to

"DELETE * FROM Condition"

Shurik.

MKoslof
04-20-2004, 07:19 PM
Hmmm...you shouldn't have to. Delete * is implied with DELETE FROM and most database only require DELETE FROM.

So you can select, update and insert, but you can delete or drop the table on Win 9x?

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum