Snitz Forums 2000 - 2eNetWorx Table Editor Queries

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Community Forums

Code Support: ASP (Non-Forum Related)

2eNetWorx Table Editor Queries

New Topic

Topic Locked

Printer Friendly

Author

Topic

dayve
Forum Moderator

USA
5820 Posts

Posted - 13 November 2001 : 00:39:32

what is the proper syntax for delete queries using Table Editor. I am beginning to think this portion does not work.

I want to delete records that match a certain criteria but like I said earlier... NO GO. Anyone shed some light on this?

____________
dayve
http://www.nineinchnailz.com/forum

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 13 November 2001 : 01:49:39

Make sure you don't have the Query returns records box checked.

I just tried the following and it worked:

DELETE FROM FORUM_TEST WHERE FORUM_TEST.T_NAME <> FORUM_TEST.T_NAME2

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 13 November 2001 : 01:54:26

I cant get that little query box to work at all with SQL Server, with Access it works fine though.

----
-Eric (da_stimulator)
Stims Snitz Test area - Running 3.3.03, 4 beta, Huw's code, and Davio's code
Need a Mod? Check out the Mod Resource

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 13 November 2001 : 01:56:28

I've never tried it with SQL Server. I'll test it when I get home.

dayve
Forum Moderator

USA
5820 Posts

Posted - 13 November 2001 : 22:27:03

Query returns records was the problem, thanks.

____________
dayve
http://www.nineinchnailz.com/forum

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.26 seconds.