How do you test an SQL on a table. 1

[tripp2222]

I am new to VPF what is the best way to test SQL code on a table.

 

[alvechurchdata]

The best way to experiment is to type the SQL statement into the Command Window. If you type:

SELECT * FROM Customer

then Fox will look for a table named Customer, select the fields from that table and display the results in a Browse window on screen.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[ramani]

I suggest you read the SQL - SELECT command help. Though the command reads few in numbers, it is extremely powerful to extract data from the tables and group them or order them to your needed choice. You can get the resultant data filtered to your choice. You can also extract it to temporary cursors on the fly and make use of the resultant cursor as tables.

You can also see the topic views .

The easiest way to proceed.. is..

SELECT * FROM myTable
SELECT myField1, myField2 FROM myTable ORDER by myField1 .. etc.. commands.

You can see the resultant records drwan shown on the screen as a cursor.




____________________________________________
ramani - (Subramanian.G)

http://winnersoft.coolfreepages.com/