How to update tables in Immediate window 1

[Soundsmith]

I'm primarily a Fox programmer, and am used to being able to manipulate tables from the 'Command' window. Commands like REPLACE ALL lastdate WITH DATE(), or using SQL SELECTs to extract data from tables (SELECT myTbl.* FROM myTbl WHERE lastname='SMITH' sort of thing.)

How can I perform these manipulations in VBA Immediate window? David 'Dasher' Kempton
The Soundsmith

http://www.thesoundsmith.com

 

[RickSpr]

For action queries (INSERT and UPDATE and DELETE), you can use:
DoCmd.RunSql "place your SQL statement here"

You can't do this for SELECT queries, however. The Debug window wouldn't know what to do with the returned recordset.

Another method, one that works for all SQL statements, is to create a new query object (click the Queries tab in the Database Window, then click the New button), switch to SQL view (choose View>SQL from the menu), and type your SQL statement in there. Then choose Query>Run from the menu. To type in a new SQL statement, choose View>SQL again. You could just leave the query window open as a scratch pad, similar to VFP's command window. Rick Sprague